When you copy a formula that contains an absolute reference to a new location,the reference ____.
A)is updated automatically
B)does not change
C)becomes bold
D)has a dotted outline in its cell

Question

Quizplus · Accepted Answer

When you copy a formula that contains an absolute reference to a new location, the reference does not change. Absolute references in a formula are indicated by the use of the dollar sign ($) before the row and column identifier, and they remain constant when the formula is copied to a new location.

When You Copy a Formula That Contains an Absolute Reference