1. In I7 Create a calculation to work out how many mains dishes are available (Category is Mains and Off Menu is not set to Y). Copy down to I10.

2. In J7 create a calculation to work out the average cost of Medium size Mains dishes. Use appropriate referencing so that the formula can be dragged down and across. (1 mark for correct referencing.)

 

Transcribed Image Text:

17 X v fx B D F G H K L 4 Ingredient Costs v Dish Category Large $87 6. 6 Menu Cod Category Medium Off Menu Dishes Available Average Price Medium Average Price Large 7 7 2627 Mains Roast Turkey Platter $58 Y Mains 1151 Mains $78 $117 Finger Foods Whole Turkey Roast with Stuffing Honey Maple Glazed Leg Ham Y 9 1236 Malns $83 $125 Salads 10 3039 Mains Seasoned Roast Pork with Crackling $53 $80 Desserts 11 1261 Mains Traditional Lamb Roast $75 $113 12 1003 Mains Fruit Cake with Frosting and Decoration $60 $90 Highest Price $125.00 13 3341 Mains Lasagna Vegetarian $47 $71 Lowest Price $20.00 14 2948 Mains Gnocchi (Spinach and Ricotta) $35 $53 15 3821 Mains Cannelloni (Beef) $45 $68 16 1316 17 3053 Mains Lasagna (the way that Mama makes) $52 $78 Maloe Mains Tortellini a la Parna $34 $51 Ravioli Fresh (Spinach and Ricotta) Ravioli Fresh (Veal) 18 3992 Mains $39 $59 19 3908 Mains $39 $59 20 2864 Mains Gnocchi Con Patate $40 $60 Spaghetti Bolognaise Siciliana Marinara 21 3868 Mains $34 $51 Mains $51 $77 $87 22 3295 Y 23 2697 Mains Garlic Prawns and Pasta $58 24 1189 25 2346 26 1770 27 3924 Mains Cannelloni (Spinach & Ricotta) $40 $60 Mains $53 Eggplant Parmigiana Pineapple Glazed Ham $35 Mains $83 $125 Mains Italian Pot Roast $117 Regt $78 28 1873 Mains Roast Vegetables $35 $53 Chicken Cacciatore $35 $53 $72 29 2267 Mains 30 2430 Mains Chicken Stroganoff $48 31 2792 Mains BBQ Chicken Platter $42 $63 32 1780 33 1913 Mains Herb Crusted Leg of Lamb $70 $105 Mains Roast Chicken Roll Platter $37 $56 34 3750 Mains Chicken Platter Trio $46 $69 35 1660 Finger Foods Vegetable Kebabs $42 $63 Finger Foods Curry Puffs $48 36 3483 $32 Finger Foods Finger Foods Finger Foods 37 3781 Fish, Prawns and Calamari Platter $53 $80 38 3523 Sushi $38 $57 39 1467 Arancini Platter - Baby Size $45 $68 Finger Foods Finger Foods Arancini Platter - Baby Size Vegetarian Vegetarian Platter Cooked Mini Quiches Mini Vegetarian Pies Ribbon Sandwiches - Vegetarian Foccacia Platter - Vegetarian Meatball Platter - Italian Style Pizza Platter (Vegetarian) 40 1831 $35 $53 41 1185 $44 $66 Finger Foods Finger Foods 42 2965 $40 $60 43 3413 $35 $53 44 2150 Finger Foods Finger Foods $31 $47 45 1793 $32 $48 46 3203 Finger Foods Finger Foods $37 $56 47 3726 $27 $41 48 2379 Finger Foods Pizza Platter $32 $48 17 X v fx B D F G H K L 4 Ingredient Costs v Dish Category Large $87 6. 6 Menu Cod Category Medium Off Menu Dishes Available Average Price Medium Average Price Large 7 7 2627 Mains Roast Turkey Platter $58 Y Mains 1151 Mains $78 $117 Finger Foods Whole Turkey Roast with Stuffing Honey Maple Glazed Leg Ham Y 9 1236 Malns $83 $125 Salads 10 3039 Mains Seasoned Roast Pork with Crackling $53 $80 Desserts 11 1261 Mains Traditional Lamb Roast $75 $113 12 1003 Mains Fruit Cake with Frosting and Decoration $60 $90 Highest Price $125.00 13 3341 Mains Lasagna Vegetarian $47 $71 Lowest Price $20.00 14 2948 Mains Gnocchi (Spinach and Ricotta) $35 $53 15 3821 Mains Cannelloni (Beef) $45 $68 16 1316 17 3053 Mains Lasagna (the way that Mama makes) $52 $78 Maloe Mains Tortellini a la Parna $34 $51 Ravioli Fresh (Spinach and Ricotta) Ravioli Fresh (Veal) 18 3992 Mains $39 $59 19 3908 Mains $39 $59 20 2864 Mains Gnocchi Con Patate $40 $60 Spaghetti Bolognaise Siciliana Marinara 21 3868 Mains $34 $51 Mains $51 $77 $87 22 3295 Y 23 2697 Mains Garlic Prawns and Pasta $58 24 1189 25 2346 26 1770 27 3924 Mains Cannelloni (Spinach & Ricotta) $40 $60 Mains $53 Eggplant Parmigiana Pineapple Glazed Ham $35 Mains $83 $125 Mains Italian Pot Roast $117 Regt $78 28 1873 Mains Roast Vegetables $35 $53 Chicken Cacciatore $35 $53 $72 29 2267 Mains 30 2430 Mains Chicken Stroganoff $48 31 2792 Mains BBQ Chicken Platter $42 $63 32 1780 33 1913 Mains Herb Crusted Leg of Lamb $70 $105 Mains Roast Chicken Roll Platter $37 $56 34 3750 Mains Chicken Platter Trio $46 $69 35 1660 Finger Foods Vegetable Kebabs $42 $63 Finger Foods Curry Puffs $48 36 3483 $32 Finger Foods Finger Foods Finger Foods 37 3781 Fish, Prawns and Calamari Platter $53 $80 38 3523 Sushi $38 $57 39 1467 Arancini Platter - Baby Size $45 $68 Finger Foods Finger Foods Arancini Platter - Baby Size Vegetarian Vegetarian Platter Cooked Mini Quiches Mini Vegetarian Pies Ribbon Sandwiches - Vegetarian Foccacia Platter - Vegetarian Meatball Platter - Italian Style Pizza Platter (Vegetarian) 40 1831 $35 $53 41 1185 $44 $66 Finger Foods Finger Foods 42 2965 $40 $60 43 3413 $35 $53 44 2150 Finger Foods Finger Foods $31 $47 45 1793 $32 $48 46 3203 Finger Foods Finger Foods $37 $56 47 3726 $27 $41 48 2379 Finger Foods Pizza Platter $32 $48

Answer rating: 100% (QA)

It appears from the question that all the data is given in Table in excel I am assuming that you hav... View the full answer