COMPUTER APPLICATIONS
OFFICE AUTOMATION SOFTWARE
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
!A!1
|
|
|
$A$1
|
|
|
#a#1
|
|
|
None of these
|
Detailed explanation-1: -An absolute reference in Excel is a cell address with the dollar sign ($) in the row or column coordinates, like $A$1.
Detailed explanation-2: -There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.
Detailed explanation-3: -The cell reference of the very first cell of MS Excel is A1. To create an absolute cell reference, the user needs to add the ‘$’ sign at the beginning of the name of the row and column. For example, the absolute cell reference of A1 will be $A$1.