Question

(a)=SUM (B3:B7)
(b)=AVERAGE (C3:D7)
(c)=MAX (B3:D7)
(d)=MIN (D3:D7)
(e)=PRODUCT (B4:B5)

Answer 1

Answer:

Explanation:

a returns the sum of all the values in the range B3 to B7

b) Returns the average of all the numbers in the range C3 to D7

c) It will return maximum value in the range B3 to D7

d) It will return minimum value in the range of D3 to D7

e) it will multiply all the values in the range of B4 to B5