Which of the selections below is a valid formula using relative 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

Option A uses relative references correctly, as it references cells A1, B1, and C1 without using absolute references like the '$' symbol.

Option B uses absolute references, denoted by the '$' symbol, which means the formula will always reference cells A20, B20, and C20 no matter where the formula is copied or pasted.

Option C contains syntax errors, as it includes both the '$' symbol and the 'M6' text in the same cell reference, as well as an extra '$' symbol.

Option D is also incorrect, as it references cells using row and column numbers instead of letters and numbers.

Which of the Selections Below Is a Valid Formula Using