please included detailed steps with functions for each step

The purpose of this assignment is to create a worksheet that will allow the user to select a check in date and check out date for a hotel of their choice (Holiday Inn, Hyatt, Marriott or Hilton). Based on their choice, the total price for the stay will be displayed in cell H9. In order to make this work, you need to do the following: 1. Create a table called Hotels from the range in cells A4:E35. 2. Create a drop list using data validation in cell H5. The list should allow for the dates in column to be chosen. Repeat this step for H6 3. Create a drop down list using data validation to show each of the possible hotel names in cell H7 4. In cell J5, extract an array from the Hotels table that contain all of the prices for the hotel chosen in cell H7. Hint: Use the INDEX and XMATCH functions or the INDIRECT function. 5. In cell K5, create a logic create a logic array that will indicate which rows in the Hotels table fall between the two selected dates. This is done by typing the following formula in cell K5: =(Hotels[Date]>=H5)( Hotels[Date]