Correct Answer - Option 1 : Absolute Addressing
The correct answer is Absolute Addressing
Cell References:
- There are 16384 rows and 256 columns in one worksheet. The first cell is labelled as A1 (column as A and row number as 1).
- The cell reference is given in the format as “Starting cell:ColumnRow” so a cell starting in B1 with column G and row 10 will be given as “B1:G10” in Microsoft excel.
Types of Cell Reference:
-
Relative: This refers to the cell relative to the given position.
-
Absolute: This refers to the specific cell irrespective of the position of the formula. The '$' sign is used to denote an absolute reference.
-
Mixed: It is a combination of both relative and mixed references. It has one absolute co-ordinate and one relative co-ordinate. $D1 and D$1 are both examples of mixed references.
Hence, we conclude that Addressing a cell as $A$4 is called Absolute Addressing.
