$3\mathrm{.}3$ You are interested in purchasing a home. You have been quoted monthly payments of $$950$ for a $30$ year mortgage. Your original loan amount is $$212,000.$ What is the interest rate you will pay on the loan?

Use the RATE function.

Reference the loan information in the "Task $3$ & $4$ Data", cells as the arguments for your function.

Remember to multiply the computed nominal interest rate by $12($to calculate the annual interest rate$).$

she helped this morning.

$2\mathrm{.}1$ Use an IF function in cell E$10$ to calculate the price to charge per donut for order $1.$

a$.$ Customer are charged $$\mathrm{.}50$ per donut unless they buy a dozen or more. In this case, they are charged $$\mathrm{.}40$ a donut.

b$.$ Refer to the appropriate price in cells $($C$3)$ and $($C$4)$ for your "value$\_$if$\_$true" and "value$\_$ if$\_$false" arguments.

c$.$ Use absolute and relative references when appropriate.

$(1.)5$

$2\mathrm{.}2$ Copy your formula in cell E$10$ and paste it down to

$2\mathrm{.}3$ Use an IF function in cell $($H$10)$ to calculate the commission rate for the donuts sale for order $1.$

a$.$ The commission rate is $2\%$ for donuts sales that total more than $$10.$ If is $1\%$ for all donut's sates that lotal more than $$5,$ but $$re less than or equal to $$10.$

b$.$ No commission is paid on donut sales that total $$5$ or less

c$.$ Relerence the threshold levels $($cells $($F$5)$ and F$6)$ in your logical tesis for your IF function and the commission rated $($cells G$5)$ and G$6)$ as your "value it inve" and "value if laise" argument: