Directpropdisplaygraph

Document Sample
Directpropdisplaygraph Powered By Docstoc
					Number of People         1       2            4          6          8          10         12
Chicken Breast (grams)   150     =$B2*C$1     =$B2*D$1   =$B2*E$1   =$B2*F$1   =$B2*G$1   =$B2*H$1
Roquefort (grams)        18.75   =$B3*C$1     =$B3*D$1   =$B3*E$1   =$B3*F$1   =$B3*G$1   =$B3*H$1
Sour cream (cl)          5       =$B4*C$1     =$B4*D$1   =$B4*E$1   =$B4*F$1   =$B4*G$1   =$B4*H$1
Olive oil (cl)           2       =$B5*C$1     =$B5*D$1   =$B5*E$1   =$B5*F$1   =$B5*G$1   =$B5*H$1

                                                                            Recipe for "x" number of peop
                                           4000
                                           3500
                                           3000

                                  Amount
                                           2500
                                           2000
                                           1500
                                           1000
                                            500
                                              0
                                                  0             5                 10                 15
                                                                                          Number of People
                                                                       Chicken Breast
                                                                       Sour Cream
        14         16         18         20         22         24
        =$B2*I$1   =$B2*J$1   =$B2*K$1   =$B2*L$1   =$B2*M$1   =$B2*N$1
        =$B3*I$1   =$B3*J$1   =$B3*K$1   =$B3*L$1   =$B3*M$1   =$B3*N$1
        =$B4*I$1   =$B4*J$1   =$B4*K$1   =$B4*L$1   =$B4*M$1   =$B4*N$1
        =$B5*I$1   =$B5*J$1   =$B5*K$1   =$B5*L$1   =$B5*M$1   =$B5*N$1

or "x" number of people




        15               20                25                  30
 Number of People
             Roquefort
             Olive Oil
Formulat Auditing Mode ( CTRL SHIFT 4 )
This is a useful mode for showing students the
formulas you used to construct the formulas using
Excel.

If you want the numbers in the table to be visible
on the "Proportion Graphs" worksheet use Tools -
Formula Auditing - Formula Auditing Mode -
"formula auditing mode".

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:2/23/2012
language:
pages:4