Hands On
Find out the functions used to complete the following table by calculating
1. Sum of all the 5 Subjects in Column H (using Sum() as stated above)
2. Percentage/Average of the 5 subjects in column |
3. Highest marks in each Subject in 18th Row
4. Lowest marks in each Subject in 19th Row
G
C С
F
Percentage
Hindi
1
2
3
H
Total
75
70
90
89
5
6
7
8
9
10
11
12.
13
14
15
16
17
18
A
R.No. Name
1 Amit
2 Arun
3 Babita
4 Chaitanya
5 Falguni
6 Kavya
7 Nirmit
8 Parul
9 Pooja
10 Rahul
11 Ryu
12 Shinish
13 Torun
14 Ukarsh
15 Yash
D
English
77
67
85
92
45
92
88
65
54
87
79
70
56
68
66
E
Maths
78
65
82
95
58
90
80
69
70
89
84
67
70
Science
75
80
85
99
77
100
90
89
78
99
89
88
55
45
67
S.St.
80
75
88
94
65
98
87
65
78
90
88
84
65
78
56
95
89
74
67
94
79
67
89
65
60
55
Highest Marks
Lowest Marks​