Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Show formula used. 12-7. At the Royal Pizza Parlor, pizzas are priced as follows: Small Triple Cheese Pepperoni $7.95 8.95 Medium 8.95 10.45 Large 10.95

Show formula used. image text in transcribed
image text in transcribed
12-7. At the Royal Pizza Parlor, pizzas are priced as follows: Small Triple Cheese Pepperoni $7.95 8.95 Medium 8.95 10.45 Large 10.95 11.95 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting A Managerial Emphasis

Authors: Charles T. Horngren, George Foster, Srikant M. Datar

9th Edition

0306457229, 978-0306457227

More Books

Students also viewed these Accounting questions

Question

Discuss the objectives of discipline and appeals systems

Answered: 1 week ago