Video Game Shop

1. Load Excel and open a blank spreadsheet.  

2. In cell A1 type Game Name.  

3. In cell B1 type Game Price.  

4. In cell C1 type Genre.  

5. Select cells A1 – C1 and make bold.  

6. Enter the data shown in the image below:

Table 1

7. Select column B and click the Currency icon shown in the Ribbon.

Currency Icon

8. In column E enter the data shown below:

Table 2

9. In cell F1 type =SUM (B2:B12) to display the cost of all of the games.

10. In cell F2 type =SUM(B2+B6) to show the cost of the Action games.

 

11. Using the structure of the formula above type in the correct formulae for the Cost Of Driving Games.

 

12. Using the structure of the formula above type in the correct formulae for the Cost Of Strategy Games.

 

13. Using the structure of the formula above type in the correct formulae for the Cost Of Arcade Games.

 

Challenge: Add more games to the table and change the formulae to show the updated totals.