PHS CyberSchool

Computer Studies SG Grade

Modified  19 July 2005

Stock (Inventory) costs of a computer shop

Open the program Excel. Open the file stock.xls (CSSG folder or online). Answer the following questions based on that file. You must use formulaes and functions to find the answers. Use the Excel Formulaes and Functions SUMIF tip sheet.  For the last section, it works best if you use the cell name, and not its contents.

Look at the spreadsheet.  Note in which column the different items are found.  Check the spelling of the items. 

Submit the answers on foolscap paper or as a word processed document.  Next to each answer indicate the formula used to find the answer. 

Indicate the cost of the following:  All the ...   (Please note   the "s" at the end of some of the names is to make it grammatically correct.  Ignore where necessary.)

1. Hardware
2. Software
3. CD Writers
4. Cell phones
5. Digital cameras
6. DVD drives
7. Educational software
8. Games
9. Graphics software
10. Laptops
11. Modems
12. MP3 players
13. Notebooks
14. PDAs
15. Operating systems
16. RAID systems
17. Servers
18. Switch hubs
19. USB drives
20. Web design software

Indicate the cost of all the goods supplied by:

1. Hewlett-Packard
2. Intersoft
3. Linux Warehouse
4. Mustek
5. Rectron
6. Siltek Distribution Dynamics

Indicate the cost of all the goods advertised in SA Computer Magazine edition:

1. October 2000
2. December 2000
3. July 2001
4. September 2001

Return to Computer Studies lesson plan index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.