Scribd
Upload
45 views2 pages

Excel Assignment: Formulas Practice

The document outlines three assignments focused on the use of various Excel formulas such as Sum, Average, If, Count, Counta, Countif, Sumif, Product, NestedIf, and Vlookup. Each assignment includes specific tasks related to calculating totals, averages, grades, and item amounts based on given data for students and items. The assignments require applying these formulas to derive insights and perform calculations for both academic performance and inventory management.

Uploaded by

pritambkup
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
45 views2 pages

Excel Assignment: Formulas Practice

The document outlines three assignments focused on the use of various Excel formulas such as Sum, Average, If, Count, Counta, Countif, Sumif, Product, NestedIf, and Vlookup. Each assignment includes specific tasks related to calculating totals, averages, grades, and item amounts based on given data for students and items. The assignments require applying these formulas to derive insights and perform calculations for both academic performance and inventory management.

Uploaded by

pritambkup
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

Assignment -1

Use of Formulas Sum, Average, If, Count, Counta, Countif & Sumif to answer the below mentioned
questions :

Roll No Student Name Hind English Math Physic Chemistry Total Average Grade
i s
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 ? ? ?

1. Find the Total Number & Average in all Subjects in Each Student.
2. Find Grade Using If Function - If Average Greater >15 then "A" Grade otherwise "B" Grade.
3. How Many Students "A" and "B" Grade [Use of Countif]
4. Student Ashok and Manoj Total Number and Average [Use of Sumif].
5. Count how many Students [Use of Counta].
6. How Many Students Hindi & English Subject Number Grater Then > 20 and <15 [Use of Countif].

Assignment -2
Use of Formulas - Product, If, Counta, Countif, Sumif to answer the below mentioned questions :

SRN ITEMS QTY RATE AMOUNT GRADE


O
1 AC 20 40000 800000 Expensive
2 FRIDGE 30 20000 ?
3 COOLER 15 10000 ?
4 WASHING MACHINE 14 15000 ?
5 TV 18 20000 ?
6 FAN 17 2000 ?
7 COMPUTER 10 25000 ?
8 KEYBOARD 5 250 ?
9 MOUSE 25 100 ?
10 PRINTER 30 12000 ?

1. Using of Product Fomula for Calculate Amount = Qty*Rate


2. How Many Items in a List
3. How Many Items qty Greate Then > 20 and Less Then <20
4. Calculate Item Computer Qty, Rate and Amount using Sumif Formula.
5. If Items Amount is Greater > 500000, Then Items "Expensive" otherwise "Lets Buy it".

Assignment -3
Use of Formulas - Sum, NestedIf, Counta, Countif, Sumif, Vlookup

SUBJECT 1ST 2ND 3RD TOTAL AVERAGE GRADE


HINDI 20 15 20 55 18.33333333 B
ENGLISH 30 12 15 ? ? ?
MATH 15 14 14 ? ? ?
PHYSICS 12 17 17 ? ? ?
CHEMISTRY 14 18 18 ? ? ?
HISTORY 16 25 20 ? ? ?
GEO 18 21 22 ? ? ?
BIO 17 23 13 ? ? ?
BOTANY 20 25 25 ? ? ?

6. How many subject? Use of Counta


7. How many subject 1 paper greater than 20? Use of countif
8. Subject Hindi, Math & English Total No and Grade. Use of Vlookup

You might also like