Question
Which reference remains fixed when copied to another cell?
Select an option. Your answer will be checked instantly.
Correct Answer: A. $A$1
Explanation:
Dollar signs before both the column and row create an absolute reference.
The formula continues to point to cell A1 regardless of where it is copied.
Leave a Reply