Question

c. Write the formula to calculate the following.
1. To add the contents of cells B2, B3, B4 and B5 and divide the sum by the contents of cell 07.
2. To multiply the contents of the cells C12 and 13 and then divide the product by the contents of
the cell D18
3 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 C6.
4. Selecting the maximum value out of a range A1 to B20
5. Calculating average of marks entered in cells E5, F5, G5, H5 and 15.
6. Calculating total expenses incurred if expenses are given month-wise in cells A1 B1. C1 and D1​

Answer 1

Answer:

1) =SUM(B2+B3+B4+B5)/5

2) =C12*C13/C18

3 =B6-A6*C6

4) =MAX(A1:B20)

5) =AVERAGE( E5:I5)

6) =SUM(A1:D1)