Question
What happens to the reference A1 when the formula =A1*2 is copied one row downward?
Select an option. Your answer will be checked instantly.
Correct Answer: D. It normally changes to A2
Explanation:
A1 is a relative reference, so it adjusts according to the formula’s new position.
Copying downward changes the row relationship from row 1 to row 2.
Leave a Reply