Question

1.Write the functions to find of the sum and average of the values entered in the cell J17,N25,Q15,R23 and S79
2. Write the function to find out the maximum and minimum of the values entered in the cells A5,B19,D25,H37. and K3​

Answer 1

Answer:

1) For Average

= AVERAGE (J17, N25, Q15, R23, S79)

For Sum

= SUM (J17, N25, Q15, R23, S79)

2) For Maximum

= MAX (A5, B19, D25, H37, K3)

For Minimum

= MIN (A5, B19, D25, H37, K3)

Mark as brainliest

Answer 2

Answer:

1) For Average

= AVERAGE (J17, N25, Q15, R23, S79)

For Sum

= SUM (J17, N25, Q15, R23, S79)

2) For Maximum

= MAX (A5, B19, D25, H37, K3)

For Minimum

= MIN (A5, B19, D25, H37, K3)