Atlas $3\mathrm{.}0$ remoder the rooms. Ine manager has asked you to complete the "Remodel" worksheet to help him schedule employees for the remodel.

$1\mathrm{.}1$ Calculate the number of

$1\mathrm{.}2$ Calculate the "Room Total" for the first transaction.

Use an IF function to calculate a $10\%$ discount for any stay greater than or equal to $7$ nights.

Copy and paste the function down the column to calculate the room total for the other transactions.

$10$

$1\mathrm{.}3$ Calculate the "Add$-$On

$1\mathrm{.}4$ The manager would like

$1\mathrm{.}5$ In cell Q$14),$ use a SUMIF

$1\mathrm{.}6$ The manager would like a

$1\mathrm{.}7$ The manager would like to