USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS 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: -If you drag the fill handle to the left or up, Excel will increment the series rather than decrement the series. In the accompanying figure, the formula in cell B14 contains an absolute reference.
Detailed explanation-2: -When the active cell contains a formula, dragging the fill handle causes Excel to? copy the formula and change the cell references relative to each destination location.
Detailed explanation-3: -Do you know the fill handle feature in Microsoft Excel? When you put your mouse in the bottom right corner of a selection, it transforms into a black cross. That’s the fill handle.
Detailed explanation-4: -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-5: -The fill handle: is a small green square at the bottom-right corner of a cell.