Please do Exercise 2

Please do Exercise 2

Exercise 1: At the Riverview Pizza Parlor, pizzas are priced as follows: Extra Cheese Pepperoni Meat Lovers Taco Supreme Soda Small $7.95 8.95 11.95 10.45 10.00 0.95 Medium 8.95 10.55 14.95 11.95 12.00 1.25 Large 10.95 11.95 17.95 13.45 14.00 1.75 Exercise 2: (Use the same Index Table that you created in Exercise 1. Do not copy it into sheet 2. I want you to link back to the first sheet when you have to reference the Index Table). 1) Create a worksheet that allows a customer to enter up to five different pizzas (or drinks) with a max quantity of 10 of each item. The worksheet should then calculate the total bill for the customer. For example the customer might order 2 medium Meat Lovers, 4 Large Supreme, and 6 Large Soda. The worksheet should calculate the total price of the order. 2) The worksheet will have the following output cells: a) An output cell for the price of each order type (index and match) b) An output cell for the total cost by order type (price times quantity) c) A final output cell that sums the individual total cost by order type and delivers a cost for the full order. 3) Use a drop down list for the inputs for both type and size. Use data validation to limit order quantity to 10 for each item. 4) If there are unused rows on the order form (ex: customer orders three different items rather than five), those rows should display as blank cells all the way across (including the total cell for that row). 5) Test your worksheet to make sure you do not have any N/A errors (even when no inputs have been entered). Total Type Pepperoni Soda Pizza Order Form Quantity Size Price 5 Medium $ 10.55$ 2 Small $ 0.95 $ 52.75 1.90 TOTAL AMOUNT $ 54.65 Exercise 1: At the Riverview Pizza Parlor, pizzas are priced as follows: Extra Cheese Pepperoni Meat Lovers Taco Supreme Soda Small $7.95 8.95 11.95 10.45 10.00 0.95 Medium 8.95 10.55 14.95 11.95 12.00 1.25 Large 10.95 11.95 17.95 13.45 14.00 1.75 Exercise 2: (Use the same Index Table that you created in Exercise 1. Do not copy it into sheet 2. I want you to link back to the first sheet when you have to reference the Index Table). 1) Create a worksheet that allows a customer to enter up to five different pizzas (or drinks) with a max quantity of 10 of each item. The worksheet should then calculate the total bill for the customer. For example the customer might order 2 medium Meat Lovers, 4 Large Supreme, and 6 Large Soda. The worksheet should calculate the total price of the order. 2) The worksheet will have the following output cells: a) An output cell for the price of each order type (index and match) b) An output cell for the total cost by order type (price times quantity) c) A final output cell that sums the individual total cost by order type and delivers a cost for the full order. 3) Use a drop down list for the inputs for both type and size. Use data validation to limit order quantity to 10 for each item. 4) If there are unused rows on the order form (ex: customer orders three different items rather than five), those rows should display as blank cells all the way across (including the total cell for that row). 5) Test your worksheet to make sure you do not have any N/A errors (even when no inputs have been entered). Total Type Pepperoni Soda Pizza Order Form Quantity Size Price 5 Medium $ 10.55$ 2 Small $ 0.95 $ 52.75 1.90 TOTAL AMOUNT $ 54.65