Which of the following is the correct entry for an absolute cell reference?
A)C4
B)*C4
C)$C$4
D)*C*4

Question

Quizplus · Accepted Answer

Absolute cell references are indicated with a dollar sign before the column letter and row number, such as $C$4, to indicate that the reference should not change when the formula is copied to other cells. The other options either use an asterisk, which is not a valid symbol for absolute references, or only partially show the absolute reference with a dollar sign in front of the column letter but not the row number.

Which of the Following Is the Correct Entry for an Absolute