Which of the following is the correct entry for an absolute cell reference?
A)C4
B)$ { }^{*} \mathrm{C} 4 $
C)$ \mathrm{SC \$ 4} $
D)$ { }^{*} \mathrm{C}^{*} 4 $

Question

Which of the following is the correct entry for an absolute cell reference? 
A)C4
B)$ { }^{*} \mathrm{C} 4 $
C)$ \mathrm{SC \$ 4} $
D)$ { }^{*} \mathrm{C}^{*} 4 $

Quizplus · Accepted Answer

An absolute cell reference is a reference to a specific cell that does not change when the formula is copied to another cell. The correct syntax for an absolute cell reference is to use the dollar sign ($) before the column letter and row number, like $C$4.

Which of the Following Is the Correct Entry for an Absolute