accounting for excel help

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: Field Level Middle Deck Private Box Upper Deck General Public $125.00 $75.00 $750.00 $50.00 Current Student $200.00 $100.00 $750.00 $20.00 Alumni $100.00 $65.00 $500.00 $35.00 Employee $125.00 $75.00 $700.00 $30.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 must be the blank cell in the upper left corner of the data table) 3. To the right of the input cells, determine the ticket price based on the user's inputs. a. First, determine the ticket price using INDEX and MATCH in a single formula. b. Second, 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