USING MICROSOFT EXCEL
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: -Fill formulas into adjacent cells You can use the Fill command to fill a formula into an adjacent range of cells. Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left.
Detailed explanation-4: -Excel and all other Office programs have a default undo/redo maximum of 100 actions.