USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A cell reference that always stays the same, even if you copy it.
|
|
|
A cell reference that has a formula in it
|
|
|
The cell you always need to come back to in a table
|
|
|
Another name for cell A1, the main cell in a spreadsheet.
|
Detailed explanation-1: -Unlike relative references, absolute references do not change when copied or filled. You can use an absolute reference to keep a row and/or column constant. An absolute reference is designated in a formula by the addition of a dollar sign ($) before the column and row.
Detailed explanation-2: -What Is An Absolute Reference? In Excel, an absolute reference is a cell reference in which the column and row coordinates stay constant while copying a formula from one cell to the other. A dollar symbol ($) is used before the coordinates to correct them. For instance, $D$2 is an absolute reference to cell D2.
Detailed explanation-3: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.
Detailed explanation-4: -Ctrl + D-Copy a formula from the cell above and adjusts the cell references. For example, if you have a formula in cell A1 and you want to copy it to cell A2, select A2 and press Ctrl + D. Ctrl + R-Copy a formula from the cell to the left and adjusts the cell references.