If a cell in a formula should remain in the same column when copied,but change the row,use a(n)________.
A) named range
B) relative reference
C) absolute reference
D) mixed reference

Question

Quizplus · Accepted Answer

A mixed reference in Excel is used when you want to keep one part of the reference constant (either the row or the column) while allowing the other part to change. In this case, to keep the column constant but allow the row to change when the formula is copied, a mixed reference with the column locked (e.g., $A1) is used.

If a Cell in a Formula Should Remain in the Same