ONLY Solve Letter E, Follow the special instructions to solve For E!!

Parte: The customer must be allowed to enter up to 6 different pizzas (small pepperoni medium pepperoni, and large pepperoni are three different pizzas) Parte: For each different pizza, the customer must enter the quantity for that pizza (the customer could order 3 small pepperoni, a medium pepperoni, and 5 large pepperoni) Parte: If a customer orders less than 6 different pizzas, then the bill must correctly calculate WITHOUT requiring the customer to enter information for all 6 different pizzas 12-7. At the Royal Pizza Parlor, pizzas are priced as follows: Triple Cheese Pepperoni Small $7.95 8.95 Medium 8.95 10.45 Large 10.95 11.95 ILLIUILDIU 2 Goat Cheese and Fig Sausage and Pepper The Works 11.95 9.45 10.00 14.95 10.95 12.00 17.95 12.45 14.00 (a) Create a worksheet that allows a person to enter a type and a size and learn the price of the pizza. Use VLOOKUP. (b) Create a worksheet that allows a person to enter a type and a size and learn the price of the pizza. Use INDEX and MATCH. (c) Give an appropriate error message if the person enters a type or size that the Parlor does not carry. Use Data Validation. (d) Use drop-down menus for the inputs of type and size of pizza. (e) Create a worksheet that allows a customer to enter up to six different pizzas with quantities and then calculates the total bill for the customer. For example, the customer might order 2 Medium Sausage and Pepper and 4 Large The Works