If the cell references should not be modified when moved to a new location, you should use a(n) relative reference.

Name: If the cell references should not be modified when moved to a new location, you should use a(n) relative reference.
Brand: Quizplus
Rating: 4.8 (33 reviews)

Question

Quizplus · Accepted Answer

To prevent cell references from changing when moved to a new location, you should use an absolute reference, not a relative reference. Absolute references are denoted by dollar signs (e.g., $A$1).

If the Cell References Should Not Be Modified When Moved