Part 3: 7 points. Reservation Worksheet - Instructions The Daily Charge is determined by using the Room Number and Rate Code to lookup the value in the DailyChg worksheet. Use the XLOOKUP() function with a nested XLOOKUP() function to find the correct daily charge and display it in column I of the Reservation worksheet. Use the IFS function to determine the seating surcharge (column K) based upon the value in column H. The seating codes are: CI, CL, LE, US. The Cl seating style costs an addition $50, CL is the standard - for which there is no additional charges, LE is an upcharge of $125, and US costs an additional $200. Don't hardcode the values in the function, but rather, create an input area on the DailyChg worksheet. Calculate the Reservation's Total Charges using formula of Daily Charge * Booked days + Seating Surcharge. Use absolute cell references or named ranges in your formulas. Format the data, to present meaningful and an easy to consume report. 123 E3 A fx 5/1/2023 B C D E F G H | J K L Megan Davis Convention Center Reservation Analysis Worksheet May 1, 2023 Reservation 4 Number Room Number Reservation Start Customer Number Rate Code Reservation Date Date 11 13 15 56982212345 R0010 AL C0001 AD 10/7/23 3/8/24 Reservation End Date 3/8/24 Seating Style Code LE Daily Charge Booked Days Seating Surcharge Total Charges 1 R0010 CA C0001 AD 10/7/23 3/8/24 3/8/24 CI 1 7 R0011 CO C0002 ST 10/7/23 3/8/24 3/8/24 US 1 R0012 FL C0003 SP 10/7/23 3/8/24 3/8/24 CL 1 R0013 AL C0004 AD 10/26/23 4/1/24 4/4/24 LE 4 10 R0013 GA C0004 AD 10/26/23 4/1/24 4/4/24 LE 4 R0014 AL C0005 AD 11/17/23 5/2/24 5/6/24 CL 12 R0014 CA C0005 ST 11/17/23 5/2/24 5/6/24 CL R0014 CO C0005 ST 11/17/23 5/2/24 5/6/24 CL 14 R0014 FL C0005 ST 11/17/23 5/2/24 5/6/24 CL R0014 GA C0005 ST 11/17/23 5/2/24 5/6/24 CL 55555