When should you use relative cell references?
A) When you want to preserve the exact cell address in a formula.
B) When you want to preserve the relationship to the formula location.
C) When you want to insert a function.
D) When you want to enter sequential values in a range of cells.

Question

Quizplus · Accepted Answer

Relative cell references should be used when you want to preserve the relationship of the referenced cell to the location of the formula. This means that when the formula is copied to another cell, the reference will adjust accordingly. This is useful for calculations that need to be repeated for different sets of data.

When Should You Use Relative Cell References