Question

The following is an Excel question:

Concert tickets are priced as follows:

	Ticket Costs (Age Group)
Ticket Location Category	22 and under	over 22
Premier tickets	$65	$90
Floor tickets	$50	$70
Balcony tickets	$30	$30
Standing Room	$15	$20

(a) Create a model that allows a person to enter his/her age and the preferred ticket location (Premier, Floor, Balcony, Standing Room) and automatically gives the price of the ticket. Use a lookup table. You may use data validation for ticket location.

(b) Create 2 test cases to demonstrate the solution.

Show ALL FORMULAS used in getting the answer.

Answer 1

Here is the model:

The inputs are:

Two Examples are:

First:

Second:

Data Validation for Preferred Ticket Location:

Please do upvote if you are satisfied! Let me know in the comments if anything is not clear. I will reply ASAP!