Home / Microsoft Excel / Question
MCQ
Which cell reference never changes when copied to another cell?
Microsoft Excel
A $A$1
B A1
C A$1
D $A1
Explanation

$A$1 is an absolute reference; both row and column stay fixed.

Related MCQs

Which box shows the name of the active cell?
Microsoft Excel View
Which function returns a match using both vertical and horizontal lookup?
Microsoft Excel View
Which button quickly inserts a SUM function?
Microsoft Excel View
Which tab is used to insert charts?
Microsoft Excel View
What is a cell address in Excel?
Microsoft Excel View
Which tab contains Data Validation?
Microsoft Excel View