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?
[amp_mcq option1=”Relative referencing” option2=”Hybrid referencing” option3=”Hyperlink” option4=”Absolute referencing” correct=”option4″]
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.