Question

Q31. Study the given table and answer the following question.
А
B
с
D
E
F
G
1
1
Name
Maths
Science
English
Hindi
Sanskrit
Total
2.
Aman
86
57
71
82
87
3
Bhavya
89
84
78
85
79
Amit
52
69
84
59
5
56
Arun
40
36
74
69
6
Chandan
86
89
42
63
76
7
Rashmi
43
52
40
34
8
57
Mayank
85
84
71
88
81
65
a.
Enter the formula in G2 to calculate the total marks scored by Aman
b. Enter the formula in H2 to calculate the average scored by Aman.
c. Enter the formula in B9 to find out the highest score obtained for science.
d. Enter the formula in B10 to find out the lowest score obtained by students in each subject.
Enter the formula in B12 to find out the average score of each subject​

Answer 1

Answer:

you search it on Google also ok