DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
You can AutoFill formulas, but not functions.
|
|
|
AutoFill automatically adjusts formulas with relative cell references.
|
|
|
You cannot AutoFill formulas with absolute cell references.
|
|
|
None of the above
|
Detailed explanation-1: -D. None of the above. Based on the options given, the most likely answer to this query is “B. Auto Fill automatically adjusts formulas with relative cell references.” This excel function is helpful in those tasks.
Detailed explanation-2: -Relative Cell References This is the most widely used type of cell reference in formulas. Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.
Detailed explanation-3: -By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)-in the same row (2).
Detailed explanation-4: -A relative cell reference is the location of a cell, such as cell B2. The type of cell references included in a formula determines the result of a formula when it is copied.
Detailed explanation-5: -Put the mouse pointer over the bottom right-hand corner of the cell until it’s a black plus sign. Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And the series is filled in for you automatically using the AutoFill feature.