Question

    In MS Excel 365, which of the following is an example of

    absolute reference pointing to cell A1?
    A @A1 Correct Answer Incorrect Answer
    B 1A Correct Answer Incorrect Answer
    C A1 Correct Answer Incorrect Answer
    D $A$1 Correct Answer Incorrect Answer

    Solution

    In Excel, $A$1 is an absolute reference, meaning it will not change when the formula is copied to another cell. The dollar signs ($) lock both the column and the row. Knowledge Booster: 1. A1 is a relative reference that adjusts when copied. 2. Absolute references are essential for fixed-value formulas. 3. Mixed references like $A1 or A$1 lock only one dimension. 4. Shortcut: Press F4 to toggle reference types.

    Practice Next

    Relevant for Exams: