Question

Consider a formula "= A3 + B4" in cell A5. If cell A5 is copied and pasted into E9, then what will be the formula in cell E9?
1. = A3 + B4
2. = E8 + F7
3. = E7 + F8
4. = B4 + C5

Answer 1

Correct Answer - Option 3 : = E7 + F8

The correct answer is = E7 + F8.

• By Assuming a formula "= A3 + B4" in cell A5.
  • If cell A5 is copied and pasted into E9, then the formula in cell E9 = E7 + F8.

• All the formulas in MS Excel started with an equal sign.
• After an equal sign, one can add formula or function.
  • For example, add values in cella A1 through A4, then type the whole equation after the equal sign.
    • = A1 + A2 + A3 + A4.