If a cell included in a formula needs to remain unchanged when the formula is copied,use a(n)________.
A) relative reference
B) mixed reference
C) named range
D) absolute reference

Question

Quizplus · Accepted Answer

Absolute references are used when a cell reference needs to remain constant when a formula is copied. This is achieved by adding dollar signs before the column letter and row number, such as $A$1, which will not change when the formula is copied to other cells.

If a Cell Included in a Formula Needs to Remain