In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used.
A) absolute
B) fixed
C) relative
D) constant

Name: In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used. A) absolute B) fixed C) relative D) constant
Brand: Quizplus
Rating: 4.7 (31 reviews)

Question

Quizplus · Accepted Answer

Absolute references in Excel are used to keep a cell reference constant when copying a formula to another cell.

In Some Situations, When Cell References Should Not Be Modified