Question

Give some appropriate functions for the following situations. (a) Selecting the maximum value out of a range A1 to B20. (b) Calculating average of marks entered in cells E5, F5, G5, H5 and 15. (c) Calculating total expenses incurred if expenses are given month-wise in cells A1, B1, C1 and D1.​

Answer 1

Answer:

Suggest the appropriate function for the following situations: Selecting the maximum value out of a range A1 to B20.

= MAX(A1 : B20)

= AVG(E5:15)

=IF(J10 >= 40

Explanation: