Question

write the formula to calculate the following.
To add the contents of cells B2, B3, B4 and B5 and divide the sum by the contents of cell C7.
To multiply the contents of the cells C12 and C13 and then divide the product by the contents of
2.
the cell D18.
3.
-CC12013)/D18
To subtract the contents of the cell A6 from the contents of the cell B6 and then multiply the
difference with the contents of the cell 06. B6- A6* C6
Selecting the maximum value out of a range A1 to B20. 15 is the sight answer
calculating average of marks entered in cells E5, F5, G5, H5 and 15. AVERAGE Ces:
6. calculating total expenses incurred if(expenses are given monthfwise in cells A1, B1, C1 and Di​

Answer 1

Answer:

write the formula to calculate the following.

To add the contents of cells B2, B3, B4 and B5 and divide the sum by the contents of cell C7.

To multiply the contents of the cells C12 and C13 and then divide the product by the contents of

2.

the cell D18.

3.

-CC12013)/D18

To subtract the contents of the cell A6 from the contents of the cell B6 and then multiply the

difference with the contents of the cell 06. B6- A6* C6

Selecting the maximum value out of a range A1 to B20. 15 is the sight answer

calculating average of marks entered in cells E5, F5, G5, H5 and 15. AVERAGE Ces:

6. calculating total expenses incurred if(expenses are given monthfwise in cells A1, B1, C1 and Di