$C4 or C$4 is an example of _____ reference.
Answer & explanation
Correct answer: option 2
The correct answer is Option (2) → Mixed
A dollar sign in a cell reference locks the part it stands before. In $C4 only the column C is locked and the row 4 changes when the formula is copied; in C$4 only the row is locked. One part fixed and the other free is a mixed reference. With both parts locked ($C$4) the reference would be absolute, and with neither (C4) relative.
NCERT (2026-27 edition):
|
