ReviseICT.co.uk homepage
Microsoft Excel
Spreadsheet software

Tasks

 
Sweets

Close any open Excel spreadsheets.  Right click and save the file below.


sweets.xls

Directions

1. Double click on the file you have downloaded.  A basic spreadsheet should appear on the screen. You are going to add information to this to create a "computer model".

2. Firstly, select cell B5 and type in how much you think a small bag of mints will cost.  Make this any number between 10 and 90 pence.  Repeat this until you have the imaginary cost of all four items. Be careful when entering the information - just enter the numbers.

3. In column C, type in the following numbers:

4. Using your knowledge of formulas, create a formula in column D to show the total costs for each type of sweet.  Make sure you show the answers in "currency" - you will need to right click and "format cells" to do this.

5. If you have completed this correctly, you will be able to change the numbers in columns B and C and see the results in column C.  Try this - change the price of Caramels to 1.10.

6. This is a basic "computer model" - you are using Excel to calculate or model what would happen if you bought a certain number of sweets at a certain price.  To complete this task, add a formula to cell D9 that will calculate the total cost of all the sweets.

 

All done?
Move onto the next task.

Index page