Absolute references are mainly used for:

  1. constant values such as a tax rate stored in one cell
  2. typing text
  3. inserting charts
  4. changing fonts
Answer

A) constant values such as a tax rate stored in one cell

The constant cell must not move.

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