Question
What does the reference $B4 do when copied?
Select an option. Your answer will be checked instantly.
Correct Answer: B. It fixes column B but allows the row number to change
Explanation:
A dollar sign before B locks the column, while the row has no dollar sign.
This mixed reference is useful when one dimension must stay constant.
Leave a Reply