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

Question

Quizplus · Accepted Answer

Using a mixed reference with the row number fixed and the column number changing allows a formula to be copied across multiple columns while always referencing the same row.

If a Cell in a Formula Should Remain in the Same