Complete three columns on the Data worksheet: Available room nights, Occupied room nights, and Percentage.

R$1.$ Cell E$4$: Enter a formula that results in the number of room nights available in June.

R$2.$ Cell K$4$: Enter a formula that results in the number of occupied room nights in June.

NOTE: Range $F3$:$J3$ gives the number of room nights a guest stayed once checked in$.$

Range $F4$:$J4$ gives the number of guests who stayed for the number of nights shown in row $3$ in the same column.

R$3.$ Cell L$4$: Enter a formula that results in the occupancy percentage. $($Round to the nearest whole percentage, such as $95\%.)$

$\%$

R$4.$ Copy down the entries in cells $E4,K4,$ and $L4$ to all other rows with data.