Scribd
Upload
45 views2 pages

Excel Assignment 1

The document presents the results of an assignment for 10 students, detailing their scores in various subjects, total scores, averages, and grades. It includes specific questions regarding the calculation of totals, averages, and grade distributions among the students. The final results indicate that 7 students received an 'A' grade and 3 received a 'B' grade.

Uploaded by

anshulgupta0141
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
45 views2 pages

Excel Assignment 1

The document presents the results of an assignment for 10 students, detailing their scores in various subjects, total scores, averages, and grades. It includes specific questions regarding the calculation of totals, averages, and grade distributions among the students. The final results indicate that 7 students received an 'A' grade and 3 received a 'B' grade.

Uploaded by

anshulgupta0141
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Assignment 1

Roll no. Student Name Hindi English Maths Physics Chemistry Total Average Grade
1 RAM 20 10 14 18 15 ? ? ?
2 ASHOK 21 12 14 12 18 ? ? ?
3 MANOJ 33 15 7 13 17 ? ? ?
4 RAJESH 15 14 8 14 20 ? ? ?
5 RANJANA 14 18 19 16 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 13 19 ? ? ?
10 PREM 26 12 10 11 27 ? ? ?

Questios :

1 Find the total and average of all students in each subject.


2 Find the grade using IF function - If average > 15 "A" else "B".
3 How many students have A and B grade ?
4 Student Ashok and Manoj Total number and average.
5 Count total number of students.
6 How many students have Hindi and english number >20 and <15 ?
Assignment 1
Roll no. Student Name Hindi English Maths Physics Chemistry Total Average Grade
1 RAM 20 10 14 18 15 77 15.4 A
2 ASHOK 21 12 14 12 18 77 15.4 A
3 MANOJ 33 15 7 13 17 85 17 A
4 RAJESH 15 14 8 14 20 71 14.2 B
5 RANJANA 14 18 19 16 18 85 17 A
6 POOJA 16 8 20 17 15 76 15.2 A
7 MAHESH 18 19 3 10 14 64 12.8 B
8 ASHUTOSH 19 20 7 14 18 78 15.6 A
9 ANIL 22 13 8 13 19 75 15 B
10 PREM 26 12 10 11 27 86 17.2 A

Questios :

1 Find the total and average of all students in each subject.


2 Find the grade using IF function - If average > 15 "A" else "B".
3 How many students have A and B grade ?
A grade 7
B grade 3
4 Student Ashok and Manoj Total number and average.
Total no. 162
Average 32.4
5 Count total number of students.
Total No. Of Students 10
6 How many students have Hindi and english number >20 and <15 ?
>20 4
<15 7

You might also like