A$1 copied downwards will:

  1. change to A2
  2. produce an error
  3. change to B1
  4. keep row 1 fixed
Answer

D) keep row 1 fixed

The $ before 1 fixes the row.

Computer Science MCQ · More Lab: MS Excel MCQs · Practise