If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?
A)Fixed
B)Relative
C)Mixed
D)Absolute

Question

Quizplus · Accepted Answer

Absolute reference is used when you want to reference a specific cell and you do not want it to change when copying and pasting the formula to other cells. This is denoted by adding a dollar sign ($) before the column letter and row number of the cell reference, such as $A$1.

If You Wanted to Reference a Cell in a Formula