Question

26.Cell D5 contains the formula =$B5 + C$5 and this formula is copied to cell E6, what will be the copied formula in cell E6?

1. =$B5 + C$5

2. =$C5 + D$5

3. =$B6 + D$5

4. =$C6 + D$6

​

Answer 1

Answer:

$B5+C$5

Explanation:

Since we can't change the expression to be calculated