The aim of this lesson is to build on the previous lesson,
and help you to consolidate your knowledge of simple formulae.
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 an extra column to the spreadsheet to show how much pocket money each child saves each week.
3. Add another column to your spreadsheet to show how much money each child saves each year. (52 weeks)
4. Apply currency formatting to any cells that contain money.
5. Save your work call it – POCKET 2
Name |
P/Money Week |
Spends / Week |
John |
£1.50 |
£0.95 |
Mary |
£1.50 |
£1.45 |
Peter |
£2.00 |
£1.30 |
David |
£1.00 |
£0.60 |
Paul |
£2.50 |
£1.75 |
Joanne |
£2.50 |
£2.30 |
Louise |
£1.50 |
£1.25 |
Charlotte |
£1.00 |
£0.50 |
Emma |
£2.00 |
£0.85 |
Terry |
£2.00 |
£1.65 |