Which of the following selections 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) =A1B1C1

Question

Quizplus · Accepted Answer

The formula in option B uses absolute references ($A$20, $B$20, $C$20) which means that when the formula is copied to other cells, it will always refer to those specific cells. This is useful when we want to lock specific cells in a formula and prevent them from changing their reference when the formula is copied. Options A, C, and D contain invalid references or incorrect syntax.

Which of the Following Selections Is a Valid Formula Using