Assignment -1
Use of Formulas Sum, Average,
If, Count, Counta,
Countif & Sumif
|
Roll No |
Student Name |
Hindi |
English |
Math |
Physics |
Chemistry |
Total |
Average |
Grade |
|
1 |
RAM |
20 |
10 |
14 |
18 |
15 |
77 |
15.4 |
A |
|
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 |
? |
? |
? |
Q.1 Find the Total Number
& Average in all Subjects
in Each Student
.
Q.2 Find Grade Using
If Function - If Average Greater
>15 then "A" Grade otherwise "B" Grade
Q.3 How Many Student
"A" and "B" Grade Use of Countif
Q.4 Student Ashok and Manoj Total Number and Average
Use of Sumif
Q.5 Count how many Students
Use of Counta
Q.6 How Many Student
Hindi & English
Subject Number Grater Then > 20 and <15 Use of Countif
0 Comments