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)absolute reference
C)relative reference
D)mixed reference

Name: 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)absolute reference C)relative reference D)mixed reference
Brand: Quizplus
Rating: 4.7 (26 reviews)

Question

Quizplus · Accepted Answer

A mixed reference is used when you want to keep the column constant but allow the row to change when copying a formula.

If a Cell in a Formula Should Remain in the Same