A reference that changes when a formula is copied is a:

  1. relative reference
  2. constant
  3. absolute reference
  4. fixed reference
Answer

A) relative reference

e.g. A1 becomes A2 when copied down.

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