In MS Excel, $A$1 is an example of which type of cell reference?
Correct answer: C. Absolute
The dollar signs lock both the column and the row, so the reference does not change when the formula is copied. A$1 or $A1 would be mixed references.
medium
Answer and explanation
The correct answer is C. Absolute
The dollar signs lock both the column and the row, so the reference does not change when the formula is copied. A$1 or $A1 would be mixed references.
Topic: MS Office (Word, Excel, PowerPoint) MCQs · Subject: Computer