DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The Increase Indent button indents the contents of a cell to the right by three spaces each time you click it. You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow. You can replace a formula with its function so it remains constant.
Detailed explanation-2: -A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. You can nest IF functions as deep as you want, but after you get yet beyond a nest of three IF functions, the logic becomes difficult to follow.
Detailed explanation-3: -Excel and all other Office programs have a default undo/redo maximum of 100 actions.
Detailed explanation-4: -Press CONTROL + 1. The “Format Cells” dialog box opens. If the “Alignment” page is not open, press CONTROL + TAB until the “Alignment” page opens. TAB to the “Horizontal” list and use the Arrow Keys to select an alignment.