Pocket Money 1

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 receives in one year (52 weeks in a year).

 

3. Add the values in your new column to work out the total amount of money that Mr. and Mrs. Smith give to their children in one year.

 

4. Apply currency formatting to any cells that contain money.

 

5. Save your work call it – POCKET1

John

£1.50

Mary

£1.50

Peter

£2.00

David

£1.00

Paul

£2.50

Joanne

£2.50

Louise

£1.50

Charlotte

£1.00

Emma

£2.00

Terry

£2.00