If a cell containing =B$14 is copy and pasted three columns over and two rows down, what would the resultant cell reference become?
A)E$14
B)$E$14
C)B16
D)B$16

Question

Quizplus · Accepted Answer

The dollar sign before the row number in =B$14 makes the row reference absolute, meaning it won't change when copied. Moving three columns over changes the column from B to E, and moving two rows down doesn't affect the row number due to the absolute reference, resulting in E$14.

If a Cell Containing =B$14 Is Copy and Pasted Three