Party Time 1

Useful formulae:

=SUM(A1+B1) Addition

=SUM(A1:A20) Addition of a set of numbers (sum)

=SUM(A1-B1) Subtraction

=SUM(A1*B1) Multiplication

=SUM(A1/B1) Division

Ten friends have a total of £100 to spend on a birthday party.

Forty people will be attending the party, so they need to carefully consider what food and drink to buy with their £100.

The local shop sells the items below at the given prices:

Canned drinks 40p

Sandwiches 50p

Crisps 15p

Jelly 30p

Sausage rolls 60p

1. Copy the spreadsheet that is shown started below.

2. Write the formula for Cost X Quantity To Buy into the Money Spent column.

3. Copy it down the spreadsheet by clicking and dragging the small square in the corner of the cell.

4. Use the sum function to display the Total Spent so far.

5. Now add values into the Quantity To Buy  column so that exactly £100 is spent on party food and drink.

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

7. Save your work call it – PARTY

 

Food / Drink

Cost

Quantity To Buy

Money Spent

Canned drinks

0.40

 

 

Sandwiches

0.50

 

 

Crisps

0.15

 

 

Jelly

0.30

 

 

Sausage rolls

0.60

 

 

 

 

Total Spent =