How is an absolute cell reference indicated?
(A) With a # sign before the cell
(B) With a $\$$ sign before the column and/or row
(C) With parentheses around the cell
(D) With a $ sign before the column and/or row
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 1
The correct answer is Option 1: (B) only
An absolute cell reference which consists of the column letter and row number surrounded by dollar ($) signs e.g. $C$4. An absolute cell reference is used when we want a cell reference to stay fixed on specific cell, which means that when a formula or function is copied and pasted to other cells, the cell references in the formula or function do not change.