Scribd
Upload
17 views

Practice Excel

Uploaded by

sada.apnacode
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
17 views

Practice Excel

Uploaded by

sada.apnacode
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/ 4

Product ID Category Sub-Category Product Name

OFF-ST-10000988 Office Supplies Storage Fellowes Folders, Blue


TEC-AC-10004144 Technology Accessories SanDisk Numeric Keypad, Bluetooth
OFF-LA-10001915 Office Supplies Labels Avery Legal Exhibit Labels, 5000 Label Set
OFF-ST-10004550 Office Supplies Storage Fellowes Folders, Wire Frame
TEC-AC-10004068 Technology Accessories Memorex Memory Card, USB
OFF-ST-10002271 Office Supplies Storage Rogers Shelving, Wire Frame
TEC-PH-10003963 Technology Phones Apple Signal Booster, Full Size
TEC-CO-10004325 Technology Copiers Canon Personal Copier, Laser
OFF-AP-10004512 Office Supplies Appliances Hoover Stove, Red
OFF-FA-10002393 Office Supplies Fasteners Accos Push Pins, Bulk Pack
OFF-LA-10002805 Office Supplies Labels Hon Color Coded Labels, Alphabetical
OFF-AP-10002330 Office Supplies Appliances Hamilton Beach Stove, Silver
OFF-AR-10000505 Office Supplies Art Binney & Smith Pens, Easy-Erase
TEC-PH-10002898 Technology Phones Samsung Smart Phone, Full Size

Count products which 7 Total sale 27648.219


Count products which 1 Minimum Sale 12.21
Max Sale 8669.184
Average 1974.872785714
1 5000
2 8000
3 12000
4 15000
Sales Quantity Discount Profit Sub Total IFError Bonus_IFS Quality
$ 79.20 3 0 $ 39.60 $ 237.60 2 12000 Normal
$ 388.92 2 0 $ - $ 777.84 0 100 Satisfactory
$ 35.19 3 0 $ 16.11 $ 105.57 2.1843575419 12000 High
$ 50.94 2 0 $ 13.20 $ 101.88 3.8590909091 100 Normal
$ 307.44 1 0 $ 73.71 $ 307.44 4.1709401709 5000 Satisfactory
$ 122.40 2 0 $ 37.92 $ 244.80 3.2278481013 100 Normal
$ 413.82 3 0 $ 20.61 $ 1,241.46 20.07860262 12000 Average
$ 428.22 1 0 $ 192.69 $ 428.22 2.2223260159 5000 Medium
$ 3,979.29 2 0 $ 1,989.54 $ 7,958.58 2.000105552 100 Very High
$ 43.56 3 0 $ 12.60 $ 130.68 3.4571428571 12000 Below Average
$ 25.26 4 0 $ 0.48 $ 101.04 52.625 15000 High
$ 2,443.91 3 0.1 $ 760.30 $ 7,331.72 3.2143744944 12000 Very High
$ 12.21 1 0 $ - $ 12.21 0 5000 Low
$ 2,167.30 4 0.15 $ 790.42 $ 8,669.18 2.7419687861 15000 Average
Xlookup
Normal
Satisfactory
High
Normal
Satisfactory
Normal
Average
Medium
Very High
Below Average
High
Very High
Low
Average
Sub-Category Quality
Storage Normal
Accessories Satisfactory
Labels High
Art Low
Phones Average
Copiers Medium
Appliances Very High
Fasteners Below Average

You might also like