Occupancy Worksheet $1.$ Open the file Hotel$\_$Data.xlsx$.2.$ Switch to the Occupancy worksheet if needed. $3.$ Replace the $[$Insert Year$]$ in A$1$ with the year number for last year. $4.$ You need to calculate the January capacity for the hotel in C$5.$ The capacity shows how many people the hotel can hold during the month. It is calculated by first multiplying the occupants per room by the number of rooms in the hotel. This result is then multiplied by the number of days in the month $($cell B$5$ for January$).$ Hint: Create this formula using absolute references so that the appropriate cells do not change when the formula is pasted throughout column C$.5.$ Copy the formula in cell C$5$