Which of the selections below is a valid formula using absolute references?
A) =A1+B1+C1
B) =$A$20+$B$20+$C$20
C) =A1+M6$2+S$4$
D) =$4+Z55+D7

Question

Quizplus · Accepted Answer

The use of dollar signs before the column and row references makes the formula a valid absolute reference. Option A uses only relative references, option C has an invalid reference with an incomplete cell reference, and option D uses a mix of relative and absolute references incorrectly.

Which of the Selections Below Is a Valid Formula Using