A spreadsheet has the formula =$A3 + B2 in cell C4. If this formula in cell C4 is copied to cell C5, what will be the value referenced structure in cell C5?

B8 ✓ Correct

C17

D16

Correct answer: (B) 8

Explanation

Copying the formula one row down changes it to =$A4 + B3, and evaluating those cells gives 8.

The dollar sign in $A3 locks the column A but lets the row adjust, so it becomes $A4.

The relative reference B2 has no lock, so moving down one row shifts it to B3.

Column letters stay the same here because the copy moves down, not across.

Absolute referencing with the dollar sign keeps a part of the address fixed during copying.

Mixed references like $A3 fix only the column or only the row, unlike fully absolute $A$3.

Want more like this? Create a free account to practise a full test, track your progress, and get spaced-repetition review.