basic computer MCQ #706

Which of the following is an absolute cell reference?

basic computer MCQ #706

  1. Question 1

    Q1. Which of the following is an absolute cell reference?

    • A) !A!1
    • B) $A$1
    • C) #a#1
    • D) A1

    Answer: $A$1

    Explanation: An absolute cell reference in Excel uses dollar signs before both the column letter and row number (e.g., $A$1) to prevent it from changing when the formula is copied.