hamburger menu
All Coursesall course arrow
adda247
reward-icon
adda247
    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

    PSSSB Group D Full Mock Test 1

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

    PSSSB Excise Inspector (Paper I) Mock Test -01

    languageIcon English
    • pdpQsnIcon50 Questions
    • pdpsheetsIcon50 Marks
    • timerIcon30 Mins
    languageIcon English
    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
    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
    368k+ students have already unlocked exclusive benefits with Test Prime!
    Our Plans
    Monthsup-arrow