Question

Cell B7 contains the formula =B5 + B6 and this formula is copied to cell C7, what will be the copied formula in cell C7? CLASS 7

Answer 1

Answer:-

The Copied Formula in cell C7 = C5 + C6.

Explanation:-

• When the formula was in cell C7 it showed up the value of B5 + B6 without any cell reference.

• So it will follow up the same pattern whenever copied to another cell.

• Here we can notice that the cell C7 shows up the value of sum of above two cells i.e. B5 and B6.

• So when it will be copied to cell C7 it will again show up the value of sum of the two cells above the C7 i.e. it will show the value of C5 + C6.

• Therefore C7 would be equal to C5 + C6.