Question 3 (4 points) In the above spreadsheet, create a formula in cell D4 that will determine the discount applicable to each person based on the Ticket Discounts table (F2:G9) You should be able to drag your formula from D4 to D8 and have it fill in all values appropriately. Tickets Ticket Discounts Name John Smith Matthew Smith Damian Smith Brianna Smith Susan Smith Discount 32 21 Closest Age Discount 0 10 20 30 40 50 5.00% 10.0% 15.0% 20.0% 25.0% 30.0% 14