JKSSB Written 2024
Answer & Explanation
Click "Check Answer" to reveal
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.