show formulas used

only solve E show formula used

(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. FUNCTIONS RELATED TO IF | 249 14.95 Goat Cheese and Fig Sausage and Pepper The Works 11.95 9.45 10.00 10.95 12.00 17.95 12.45 14.00 FUNCTIONS RELATED TO IF | 249 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