PHS CyberSchool

Computer Studies SG

Modified  19 July 2005

Stock (Inventory) counts in a computer shop

Open the program Excel. Open the file stock.xls.  Save it in your folder with the name stockYourInitials. Answer the following questions based on that file. You must use formulaes and functions to find the answers. Use the COUNTIF Formulaes and Functions in the Excel / Help / Index if necessary.

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.

Count the number of the following.  How many of ... are there in the store?    (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. Books
4. CD Writers
5. Cell phones
6. Digital cameras
7. DVD drives
8. Games
9. Glossaries
10. Keyboards
11. Laptops
12. Monitors
13. Motherboards
14. Processors
15. Operating systems
16. RAID systems
17. Servers
18. Switch hubs
19. USB drives
20. Web design software

Count the number of the following.  How many times have the following supplied goods?

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

Count the number of the following.  How many products from SA Computer Magazine of a particular month and year were found in the store?

1. October 2000
2. April 2001
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.