Spreadsheets by hedongchenchen

VIEWS: 1 PAGES: 8

									Spreadsheets

 Biscuit Model
            Biscuit Model
• You already should know how to enter
  formula.
• What do all formulas start with?
• Why do should you use formulas?
                                   Biscuit Model
   Today's biscuits                                                                     7.4T2c
                                                 Quantity                Quantity for    Cost for
         200            Ingredient    Measure       for 1   Cost for 1      today          today
                      Wholemeal
                         flour        grams       17.5          £0.02        3500            £4.00
                      Oatmeal         grams         5           £0.02        1000            £4.00
                      Butter          grams        11           £0.03        2200            £6.00
                      Soft brown      teaspoon
                           sugar          s        0.4          £0.01         80             £2.00
                                      teaspoon
                      Baking powder       s        0.1          £0.03         20             £6.00
                                      teaspoon
                      Salt                s       0.05          £0.01         10             £2.00


                                                                £0.12                       £24.00
Totals; These are formulas, the
formulas are written as
=SUM(E3:E8)
            Biscuit Model
• The first question asks how much would
  500 biscuits cost?
• To work this out we need to find the
  information on the spreadsheet of how
  much 1 biscuits costs?
• And we need to display the answer for 500
  biscuits so that everyone understands
  what it is.
                                      Biscuit Model
Today's biscuits                                                                                         7.4T2c
      200                   Ingredient     Measure   Quantity for 1   Cost for 1    Quantity for today   Cost for today



                   Wholemeal flour       grams            17.5              £0.02          3500                     £4.00




                   Oatmeal               grams             5                £0.02          1000                     £4.00




                   Butter                grams             11               £0.03          2200                     £6.00




                   Soft brown sugar      teaspoons        0.4               £0.01           80                      £2.00




                   Baking powder         teaspoons        0.1               £0.03           20                      £6.00




                   Salt                  teaspoons        0.05              £0.01           10                      £2.00




               Cost of one Biscuit                                        £0.12                                   £24.00
                         Biscuit Model
Today's biscuits

      200                   Change this to 500
                            and watch what
                            happens



                   Click here to see
              Biscuit model

• What do I have to alter to find out the cost
  of butter for 750 biscuits

            What do I have to do?
                    Biscuit Model

Today's biscuits

      200

                          I wonder what
                         happens when I
                           change this?

Click here to see

								
To top