Scribd
Upload
40 views2 pages

Practical: 6 Aim:: Create Following Worksheet and Apply Formulas Sum, Average, If, Count, Counta, Countif & Sumif

066

Uploaded by

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

Practical: 6 Aim:: Create Following Worksheet and Apply Formulas Sum, Average, If, Count, Counta, Countif & Sumif

066

Uploaded by

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

PRACTICAL: 6

AIM: Create following worksheet and apply Formulas Sum, Average, If, Count, Counta,
Countif & Sumif.

Student Chemastr Averag


Roll No Name Hindi English Math Physics y Total e 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 ? ? ?
ASHUTOS
8 H 19 20 7 14 18 ? ? ?
9 ANIL 22 13 8 12 19 ? ? ?
10 PREM 26 12 10 11 27 ? ? ?
9 ANIL 22 13 8 12 19 ? ? ?
10 PREM 26 12 10 11 27 ? ? ?

INPUT:
a. Find the Total Number & Average in all Subjects in Each Student.

b. Find Grade Using If Function - If Average Greater >15 then "A" Grade otherwise "B" Grade

c. How Many Student "A" and "B" Grade Use of Countif

d. Student Ashok and Manoj Total Number and Average Use of Sumif

e. Count how many Students Use of Counta

f. How Many Student Hindi & English Subject Number Grater Then > 20 and

Student Chemastr Averag


Roll No Name Hindi English Math Physics y Total e 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 14 17 86 17.2 A
4 RAJESH 15 14 8 16 20 73 14.6 B
5 RANJANA 14 17 10 13 18 72 14.4 B
6 POOJA 16 8 20 17 15 76 15.2 A
7 MAHESH 18 19 3 10 14 64 12.8 B
ASHUTOS
8 H 19 20 7 14 18 78 15.6 A
9 ANIL 22 13 8 12 19 74 14.8 B
10 PREM 26 12 10 11 27 86 17.2 A
9 ANIL 22 13 8 12 19 74 14.8 B
10 PREM 26 12 10 11 27 86 17.2 A

You might also like