Calculate the construction cost for upper$-$tier hotels, which is cell F$3$ in the $4.$ Upper$-$tier

Hotels$$ worksheet. Use a formula that multiplies the hotel size $($# of rooms$)$ in cell D$3$ by

the construction cost per room listed for its appropriate State in the $$Construction cost per

room$$ table. Use the Index$+$Match function to find the cost per room for the

appropriate State for upper$-$tier hotels in the $$Construction cost per room$$ table and

multiply it by the hotel size $($in cell D$3)$ in the $6.$ Upper$-$tier Hotels$$ worksheet. Copy this

formula $($in cell F$3)$ and paste it into cells F$4$ through F$1$