Which cell reference is used when we want a cell reference to stay fixed on a specific cell, which means that when a formula or function is copied and pasted to other cells, it does not change?
Answer & explanation
Correct answer: option 4
The correct answer is Option (4) → Absolute cell reference
NCERT (2026-27 edition):
|
