|
Roll No |
Student Name |
Hindi |
English |
Math |
Physics |
Chemistry |
Total |
Average |
Grade |
|
1 |
RAM |
20 |
10 |
14 |
18 |
15 |
|
|
|
|
2 |
ASHOK |
21 |
12 |
14 |
12 |
18 |
|
|
|
|
3 |
MANOJ |
33 |
15 |
7 |
14 |
17 |
|
|
|
|
4 |
RAJESH |
15 |
14 |
8 |
16 |
20 |
|
|
|
|
5 |
RANJANA |
14 |
17 |
10 |
13 |
18 |
|
|
|
|
6 |
POOJA |
16 |
8 |
20 |
17 |
15 |
|
|
|
|
7 |
MAHESH |
18 |
19 |
3 |
10 |
14 |
|
|
|
|
8 |
ASHUTOSH |
19 |
20 |
7 |
14 |
18 |
|
|
|
|
9 |
ANIL |
22 |
13 |
8 |
12 |
19 |
|
|
|
|
10 |
PREM |
26 |
12 |
10 |
11 |
27 |
|
|
|
Questions – 10 Practice Tasks
- Find the Total Marks of each student using SUM.
- Find the Average Marks of each student using AVERAGE.
- Find the Grade using IF: Average > 15 = A, otherwise B.
- Count how many students got Grade A using COUNTIF.
- Count how many students got Grade B using COUNTIF.
- Find the Total Marks of Ashok and Manoj using SUMIF.
- Find the Average Marks in Hindi using AVERAGE.
- Find the total number of students using COUNTA.
- Count students who scored more than 20 in Hindi using COUNTIF.
- Count students who scored more than 20 in Hindi AND less than 15 in English using COUNTIFS.