πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!


    Question

    In Microsoft Excel, what is the purpose of the '$' sign

    in a cell reference (e.g., `$A$1`)?
    A It indicates a named range. Correct Answer Incorrect Answer
    B It makes the row and column absolute, preventing them from changing when copied. Correct Answer Incorrect Answer
    C It signifies a formula error. Correct Answer Incorrect Answer
    D It denotes a currency format. Correct Answer Incorrect Answer
    E None of the above Correct Answer Incorrect Answer

    Solution

    It makes the row and column absolute, preventing them from changing when copied.

    Practice Next
    More Microsoft Office Questions
    ask-question