Question

Based on the following data, find the values of the expressions :


A. B. C. D. E
1 Roll No. Name Hindi Eng lish Mathe mat ics Eco nom ics His tory To tal %

2 1 Ruchi 40 40 45 35 40

3 2 Juhi 45 35 40 30 40

4 3 Priya 30 45 40 35 35

5 4 Prasant 40 30 45 35 40

6 5 Mohit 45 35 30 40 45

(i) In cell H2 function as = SUM(C2 : G2) and copy the function in cell H3

to H6

(ii) In cell I2 formula as = (H2*100)/250 and copy the formula in cell I3

to I6

(iii) In cell H7 as = Max(H2 : H6)

(iv) In cell I7 as = Max(I2 : I6)​

Answer 1

The answer is in the above picture

hope it helps

mark as brainliest