ЁЯУв Too many exams? DonтАЩt know which one suits you best? Book Your Free Expert ЁЯСЙ call Now!

    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
    More MS Office Questions

    Relevant for Exams:

    ask-question