Question

What is the formula in cell B3 if you copy the formula "=10+D2" from cell A1 to B3?

a) =10+B3
b) =10+B4
c) =10+E3
d) =10+E4

Answer 1

The formula in cell B3, if you copy the formula "=10+D2" from cell A1, would be option c) =10+E3.

Step-by-step explanation:

The formula in cell B3, if you copy the formula "=10+D2" from cell A1, would be option c) =10+E3.

When you copy a formula to another cell, the cell references adjust accordingly. In this case, the formula in cell B3 would refer to cell E3 instead of D2.

Therefore, the correct formula in cell B3 would be "=10+E3".