## Party Time 2

**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

1. Load the spreadsheet party.

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

3. Save your work call it – PARTY 2

4. What formula is written into the spreadsheet to calculate the money spent on each type of food?

5. Explain how this formula works.