The steps to set up function for the following.

a)Find the sum of values from cells A3 to A9 to be displayed in A10
b)find the maximum value from cells D3 to D11 to be displayed in D15
c)find the minimum value from cells E4 to E9 to ve displayed in E10
d)find the average of the values from cells A3 to X3 to be displayed in Y3?

plzzzz answer

1

Answers

2015-07-13T11:59:34+05:30
A.CLICK ON THE CELL A10 AND WRITE=SUM(A3:A9) AND PRESS ENTER.
B.
CLICK ON THE CELL D15 AND WRITE=MAX(D3 :D11) AND PRESS ENTER.
C.CLICK ON THE CELL E10 AND WRITE =MAX( E4 :E9) AND PRESS ENTER.
D.
CLICK ON THE CELL Y3 AND WRITE=AVERAGE(A3:X3) AND PRESS ENTER.
1 5 1