Scribd
Upload
102 views2 pages

Excel Assignment 2

The document outlines an assignment involving the calculation of amounts for various electronic items based on their quantities and rates. It includes questions related to product formulas, item counts, and categorization of items as 'expensive' or 'let's buy it' based on their total amounts. The assignment provides a completed table with calculated amounts and grades for each item.

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
102 views2 pages

Excel Assignment 2

The document outlines an assignment involving the calculation of amounts for various electronic items based on their quantities and rates. It includes questions related to product formulas, item counts, and categorization of items as 'expensive' or 'let's buy it' based on their total amounts. The assignment provides a completed table with calculated amounts and grades for each item.

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 2

Sr. No. Item Qty. Rate Amount Grade


1 AC 20 40000.00 ? ?
2 FRIDGE 30 20000.00 ? ?
3 WASHING MACHINE 15 10000.00 ? ?
4 COOLER 14 15000.00 ? ?
5 TV 18 20000.00 ? ?
6 FAN 17 2000.00 ? ?
7 COMPUTER 10 25000.00 ? ?
8 KEYBOARD 5 250.00 ? ?
9 MOUSE 25 100.00 ? ?
10 PRINTER 30 12000.00 ? ?

Questios :

1 Using of product formula to calculate amount.


2 How many items in a list
3 How many items quantity greater >than 20 and less than < 20 ?
4 Calculate item computer Qty. , rate and amount using SUMIF formula.
5 IF item amount is Greater than > 500000 ,than item is "expensive", otherwise "Let's buy it".
Assignment 2
Sr. No. Item Qty. Rate Amount Grade
1 AC 20 40000.00 800000.00 Expensive
2 FRIDGE 30 20000.00 600000.00 Expensive
3 WASHING MACHINE 15 10000.00 150000.00 Let's buy it
4 COOLER 14 15000.00 210000.00 Let's buy it
5 TV 18 20000.00 360000.00 Let's buy it
6 FAN 17 2000.00 34000.00 Let's buy it
7 COMPUTER 10 25000.00 250000.00 Let's buy it
8 KEYBOARD 5 250.00 1250.00 Let's buy it
9 MOUSE 25 100.00 2500.00 Let's buy it
10 PRINTER 30 12000.00 360000.00 Let's buy it

Questios :

1 Using of product formula to calculate amount.


Column E
2 How many items in a list ?
Total items in list 10
3 How many items quantity greater >than 20 and less than < 20 ?
Qty. greater than 20 3
Qty. less than 20 6
4 Calculate item computer Qty. , rate and amount using SUMIF formula.
250000
5 IF item amount is Greater than > 500000 ,than item is "expensive", otherwise "Let's buy it".
Column F

You might also like