In MS Excel, which of the following is an absolute cell reference?

Knowledge of Computers ·Previously asked in JKSSB Patwari 2024

View the full solved paper: JKSSB Patwari – 1 September 2024 Set A

Question

In MS Excel, which of the following is an absolute cell reference?

  1. A. !A1!
  2. B. A1 (Correct answer)
  3. C. A1
  4. D. A1

Correct Answer

Option B — A1

Detailed Solution & Explanation

The correct answer is $A$1.

Key Points

  • In MS Excel, an absolute cell reference uses $ before both the column letter and row number: $A$1. This reference remains fixed and does NOT change when the formula is copied to other cells.
  • A relative reference like A1 adjusts automatically.