DATABASE FUNDAMENTALS
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: -The fill handle only allows you to copy formulas to several different cells. Any changes made to an Excel document can be tracked in a separate worksheet. The Subtotals command adds numbers in a designated column. Sparklines are tiny charts that fit into one cell.
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.