Question

Consider a formula "= B2 + 4" in cell A1. If cell A1 is copied and pasted into D4, then what will be the formula in D4?
1. = B4 + 7
2. = D4 + 4
3. = E5 + 4
4. = B2 + 4

Answer 1

Correct Answer - Option 3 : = E5 + 4

The correct answer is = E5 + 4.

•  If a formula = B2 + 4 is in cell A1 then cell A1 is copied into D4, then the formula in D4 will be = E5 + 4.

• How to Write Formulas in Excel
  • All Excel formulas start with an equal (=) sign.
  • The answer to the formula is displayed in the cell into which the formula is entered.
  • Cells are referenced in a formula by their column-row identifier.
  • The symbols for addition, subtraction, multiplication, and division are: + - * /
  • We do not have to enter capital letters in the formula, They will be capitalized automatically.