Question

6. Suggest the appropriate function for the following:
a. Selecting the maximum value out of A1 to B20.
b. Calculating the average of marks entered in cells E5, F5, G5, and H5.

Answer 1

Answer:

a : The maximum value of range a1 to b20 is 15

b: AVERAGE(e5:h5)