A person wishes to apply a formula in the entire column of the spreads

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

Download PDF Attempt Online

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.

Relative referencing (e.g., A1) adjusts the cell reference based on the relative position when copied to other cells. Hybrid referencing (e.g., $A1$ or A$1$) fixes either the column or the row, but not both. A hyperlink is a link to another location or document and is unrelated to cell referencing in formulas.

Join Our Telegram Channel

More similar MCQ questions for Exam preparation:-