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 stays fixed when a formula is copied. It is written with a dollar sign before the column letter and/or the row number, as in $C$4 (both fixed) or $C4 and C$4 (one part fixed, a mixed reference).
(A) With a # sign before the cell Incorrect. The # sign marks an error value in a cell, such as #VALUE!, not a fixed reference.
(B) With a $ sign before the column and/or row Correct. The $ sign holds the column, the row or both constant.
(C) With parentheses around the cell Incorrect. Parentheses enclose the arguments of a function or group parts of a formula; they do not fix a reference.
(D) With a $ sign before the column and/or row Correct. It is the same statement as (B).
Note: Statements (B) and (D) are printed the same, so both state the correct rule. No option offers (B) and (D) together; Option (1), (B) only, is the one option with no wrong statement, since every other option takes in (A) or (C). So Option (1) is taken as the answer.
NCERT (2026-27 edition):
|
