If a cell containing =B$14 is copied 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 formula =B$14 has a relative column reference and an absolute row reference. When copied three columns over, the column B becomes E. The row remains 14 because it is absolute. Thus, the resultant cell reference is E$14.

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