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 a donut. b$.$ Refer to the appropriate price in cells $(3)$ and $(4)$ for your "value$\_$if$\_$true" and "value$\_$if$\_$false" arguments. c$.$ Use absolute and relative references when appropriate. $2\mathrm{.}2)$ Copy your formula in cell E$10)$ and paste it down to complete the "Price$/$Donut$"$ column of the table. $(2\mathrm{.}3)$ Use an IF function in cell $)$ to calculate the commission rate for the total sale for order $1.$ a$.$ The commission rate is fpr all sales that total more than $.$ It is for all sales that total more than $,$ but are less than or equal to $.$ b$.$ No commission is paid on sales that total or less. c$.$ Reference the threshold levels $($cells $)$ and $)$ in your logical tests for your IF function and the commission rates $($cells $)$ and G$6)$ as your "value$\_$if$\_$true" and "value$\_$if$\_$false" arguments. d$.$ Use appropriate relative and absolute references. $(2\mathrm{.}4)$ Copy your formula in cell H$10)$ and paste it down to complete the "Rate" column of the table. $(2\mathrm{.}5)$ Use an IF function in cell J$10)$ to calculate the commission earned for beverages for order $1.$ a$.$ The beverage commission is of the total sale if the customer buys a beverage. b$.$ If the beverage sale amount $($cell $-$ D$10)$ is greater than $0,$ the beverage commission equals the sales total $($cell G$10)$ multiplied by the beverage commission rate $($cell G$4).$ c$.$ Otherwise, the beverage commission is $0.$ d$.$ Use appropriate relative and absolute cell references. $(2\mathrm{.}6)$ Copy your formula in cell and paste it down to complete the "Beverage" commission column of the table. $1(2\mathrm{.}7)$ Beverly treats herself to a donut if her daily commission is more than her set Donut Threshold. a$.$ Use an IF function in cell K$5)$ to determine if she should buy herself a donut. b$.$ Cell K$5)$ should contain the value "Yes" if her total commission in cell $)$ is more than her "Donut Threshold". c$.$ Otherwise, cell K$5)$ should contain the value $"$No$".$ d$.$ Be sure to reference the "Donut Threshold" value in cell K$6)$ in your formula.