All of Mr. and Mrs. Smith’s children are going on holiday.
In 25 weeks time they must each have saved £20.00 towards the cost of the holiday.
The children need some help to sort out how much of their pocket money they can spend
each week, yet, still have saved £20.00 in 25 weeks time.
Useful formulae:
=SUM(A1+B1) Addition
=SUM(A1:A20) Addition of a set of numbers
=SUM(A1-B1) Subtraction
=SUM(A1*B1) Multiplication
=SUM(A1/B1) Division
1. Produce a spreadsheet to clearly display the information shown below.
2. Add a column to show the amount of money saved in 25 weeks.
3. Add a column to show the shortfall (£20.00 - amount saved in 25 weeks )
4. Apply currency formatting to any cells that contain money.
5. Change the values in the Spends / Week column until the values in the shortfall column reach 0 for each child.
6. Save your work call it – POCKET 3
Name |
P/Money Week |
Spends / Week |
Saved / Week |
John |
£1.50 |
£0.95 |
£0.55 |
Mary |
£1.50 |
£1.45 |
£0.05 |
Peter |
£2.00 |
£1.30 |
£0.70 |
David |
£1.00 |
£0.60 |
£0.40 |
Paul |
£2.50 |
£1.75 |
£0.75 |
Joanne |
£2.50 |
£2.30 |
£0.20 |
Louise |
£1.50 |
£1.25 |
£0.25 |
Charlotte |
£1.00 |
£0.50 |
£0.50 |
Emma |
£2.00 |
£0.85 |
£1.15 |
Terry |
£2.00 |
£1.65 |
£0.35 |