Question

Which of the following will occur when the formula =B1+B2 in E5 is copied down the column?

1) The formula will change to =B2+B3 in E6
2) The formula will change to =B3+B4 in E6
3) The formula will change to =B1+B3 in E6
4) The formula will change to =B2+B4 in E6

Answer 1

When the formula =B1+B2 in E5 is copied down the column, the row numbers in the formula will change accordingly.

Step-by-step explanation:

When the formula =B1+B2 in E5 is copied down the column, the row numbers in the formula will change accordingly. So, the correct option would be option 2) The formula will change to =B3+B4 in E6. As we copy the formula down, the row numbers in the formula increment by 1, leading to the change in the formula itself.