If =B2C2 in D2 is copied to D3, it becomes:

  1. =B2C2
  2. =B3C2
  3. =C3D3
  4. =B3C3
Answer

D) =B3C3

Relative references move with the formula.

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