Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Explain and show work Auburn University wants a worksheet that will allow the user to input their name, ticket location, and customer category to find
Explain and show work Auburn University wants a worksheet that will allow the user to input their name, ticket location, and customer category to find out the price of a football ticket. The following table has the price information: Upper Deck Middle Deck Field Level Luxury Box General Public $75.00 $100.00 $150.00 $750.00 Current Student $25.00 $125.00 $200.00 $950.00 Alumni $50.00 $75.00 $125.00 $600.00 Employee $40.00 $85.00 $175.00 $700.00 Required: 1. At the top of the worksheet, create user input cells that allow the user to input their name, select their ticket location, and indicate their customer category. a. The input cells must use data validation so that the user cannot enter invalid data for the ticket location or the customer category. 2. The data table shown above must start in cell A10 (A10 is the blank cell in the upper left corner of the data table). The data table must be entered in Excel exactly as it is shown above. 3. To the right of the input cells, determine the ticket price based on the user's inputs. a. Determine the ticket price using INDEX and MATCH in a single formula. b. In another cell, determine the ticket price using VLOOKUP and MATCH in a single formula Note: The single formula statement means that you must determine the ticket price using only one cell. This will require you to nest some functions in the formula
Explain and show work
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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