A person wishes to apply a formula in the entire column of the spreadsheet, with regard to only one cell. Which type of referencing should he use to obtain correct result?
Relative referencing
Hybrid referencing
Hyperlink
Absolute referencing
Answer is Right!
Answer is Wrong!
This question was previously asked in
UPSC CBI DSP LDCE – 2023
The correct answer is D) Absolute referencing.
Absolute referencing in a spreadsheet uses dollar signs ($) before the column letter and row number (e.g., $A$1) to fix the reference to a specific cell. When the formula containing an absolute reference is copied to other cells, the reference remains unchanged, always pointing to the original cell. This is essential when a formula in an entire column needs to refer consistently to a single specific cell.