50.1K

Verified Solution

Link Copied!

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

Answer & Explanation Solved by verified expert

See Answer