In MS-Excel, a formula =B$1+C$3+5 in cell D9, when copied to cell F12, will become:

A=D1+E3=5

B=B$2+C$4+5

C=C$1+D$3+5

D=D$1+E$3+5 ✓ Correct

Correct answer: (D) =D$1+E$3+5

Explanation

The dollar sign fixes only the row numbers, so rows 1 and 3 stay unchanged when the formula is copied.

Column letters have no dollar sign, so they shift by the same distance as the move from D to F, two columns right.

Thus B becomes D and C becomes E, giving D$1 plus E$3 plus 5.

D1 plus E3 equal to 5 is wrong because it drops the absolute rows and mistypes the operator.

B$2 plus C$4 shifts the rows, but rows are locked and must not change.

C$1 plus D$3 shifts columns by only one, not the two required by the D-to-F move.

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