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.