Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please post answer in excel with formulas! please only answer letter E! TOOKON lli ns stn u o(d) 12-7. At the Royal Pizza Parlor, pizzas
please post answer in excel with formulas! please only answer letter E! TOOKON lli ns stn u o(d) 12-7. At the Royal Pizza Parlor, pizzas are priced as follows: Medium Small Large 10.95 Triple Cheese Pepperoni $7.95 8.95 8.95 10.45 11.95 FUNCTIONS RELATED TO IF 249 Goat Cheese and Fig Sausage and Pepper 11.95 9.45 10,00 14.95 17.95 10.95 12.00 12.45 The Works 14.00 (a) Create a worksheet that allows a person to enter a type and a size and learn the price of the nizza. 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. (e) 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
please post answer in excel with formulas! please only answer letter E!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started