At the Downtown Theater: Orchestra seats are $40, Mezzanine seats are $30, and Balcony seats are $20. Children (under 12) are half price. Seniors (65 or over) receive a $5 discount. Complete the model on the Problem 1 worksheet, so that if you enter a ticket location in cell C14 and an age in cell C15, you get the final price of the ticket in cell C18. If the person types in a non-valid seat location in cell C14, your formula should return the text "Invalid Location" rather than an error. Note. If easier for you, you can first find the ticket price BEFORE discount (enter that formula in cell C19) and then use it in cell C18 to find the final, after discount, price. Test your formula for Orchestra for an 88-years-old, Mezzanine for a 7 years-old, Backstage for an 18 year-old, and Orchestra for a 21 year-old.

Respuesta :

Answer:

Explanation:

Student Exam Student Case 1Case 2Case 3Case 4Name Score Effort Grade (P/F)Grade (P/F)Grade (P/F)Grade (P/F)

Heloise 102

Frieda 704

Mark 895

Jo 251

Herbert 942

Khan 965

Mary 962

Jacob 914

Lindsey 872

Chelsea 332

Rip 901

B.B. 702

Joe 893

Grant 732

Jul 905

Jennife 343

Use Nested to establish the Grade as P or F.