Computer question from Patwari exam, 2024 by JKSSB
In MS Excel, which of the following is an absolute cell reference?
Last updated Jun 24, 2026
Correct Answer:
Option B —
$A$1
An absolute cell reference in Excel is a cell address that contains dollar signs ($) before the column letter and the row number. This tells Excel to keep the reference locked to that specific cell, even if the formula is copied or moved to a different location.
• $A$1 locks both the column (A) and the row (1).
• The other symbols (!, #) are used for different purposes in Excel, such as sheet references or error indicators, but not for locking cell coordinates.
Answer verified by Quintessence Classes faculty — Karan Nagar, Srinagar.
