home

[[image:olgctalk:Pizza.jpg]]
=Spreadsheet Data for Pizza Lunch= Directions: You are planning a pizza lunch in your classroom. The entire class will **__W__** **__ork in groups__** to: **__Create an invitation on Wikispace__** and plan the party. ** __Create an Excel sheet.__ ** Carefully enter the following data. This will give you an effective way to plan the lunch and figure the cost. 1. Open a new spreadsheet in Microsoft Excel. 2. Use data below to create a Pizza Lunch Spreadsheet. 3. Save the completed document as Pizza Lunch. 4. After entering data below, calculate B x D to get Item totals. 5. Select Item totals and hit Auto Sum to get totals. __Cell Data__ A5 - pizza C13 - packages B3 - Quantity D9 - 1.90 A13 - napkins D7 - .50 C16 - Bags D5 - 8.00 C8 - lb. bag A8 - pretzels D15 - 1.40 D11 - Food Costs C5 - # of pies A3 - item C7 - cones D13 - 1.30 C3 - label E3 - Item Total D6 - .45 A14 - plates A6 - soda C6 - # of cans C14 - packages A15 - straws A16 - ice D14 - 1.00 A7 - ice cream D16 - 1.00 D18 - Paper Cost C15 - box/es A9 - chips D3 - Cost Each D8 - 1.50