Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that ____ is an absolute cell reference.
A) A1
B) $A1
C) A$1
D) $A$1

Question

Quizplus · Accepted Answer

The absolute cell reference is denoted by the symbol $. In this case, the reference to the cell A1 is fixed, both in the column (A) and in the row (1). Therefore, $A$1 is the correct answer as it is an absolute cell reference.

Tyler Is Teaching Eleni How to Perform Calculations in Her