If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5.
A) =B3+B4
B) =B4+B5
C) =$B3+$B4
D) =B$4+B$5

Question

Quizplus · Accepted Answer

When using relative cell references in Excel, copying a formula adjusts the cell references based on the relative position of the target cell. Therefore, copying =A3+A4 from A5 to B5 shifts the references one column to the right, resulting in =B3+B4.

If You Were Using Relative Cell References, the Formula =A3+A4