arrow
arrow
arrow
Which symbol is used to indicate an absolute cell reference in Excel?
Question

Which symbol is used to indicate an absolute cell reference in Excel?

A.

#

B.

@

C.

&

D.

$

Correct option is D

The correct answer is: (d) $

Explanation:
In Excel, the $ symbol is used to indicate an absolute cell reference. When you add a dollar sign before the row number and/or column letter (e.g., $A$1), it locks the reference to that specific cell, meaning it does not change when you copy the formula to other cells.

  • $A$1: Both the column (A) and the row (1) are absolute.
  • A$1: Only the row is absolute.
  • $A1: Only the column is absolute.

The other symbols (#, @, &) are not used for cell references in Excel.

Free Tests

Free
Must Attempt

Punjab Police Constable Paper-I & II PYP (Held on 30th July 2024 Shift 1)

languageIcon English
  • pdpQsnIcon150 Questions
  • pdpsheetsIcon150 Marks
  • timerIcon180 Mins
languageIcon English
Free
Must Attempt

Punjab Police Constable Paper-I & II PYP (Held on 6th Aug 2024 Shift 1)

languageIcon English
  • pdpQsnIcon150 Questions
  • pdpsheetsIcon150 Marks
  • timerIcon180 Mins
languageIcon English
Free
Must Attempt

PSSSB Clerk 2022-23 Mock 01

languageIcon English
  • pdpQsnIcon150 Questions
  • pdpsheetsIcon150 Marks
  • timerIcon150 Mins
languageIcon English
test-prime-package

Access ‘PSSSB Clerk’ Mock Tests with

  • 60000+ Mocks and Previous Year Papers
  • Unlimited Re-Attempts
  • Personalised Report Card
  • 500% Refund on Final Selection
  • Largest Community
students-icon
353k+ students have already unlocked exclusive benefits with Test Prime!
Our Plans
Monthsup-arrow