$2$

$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 $10\%$ of the total sale if the customer buys a beverage.

b$.$ If the beverage sale amount $($cell $)$ is greater than $0,$ the beverage commission equals the sales total $($cell G$10)$ multiplied by the beverage commission rate $($cell $1.$

c$.$ Otherwise, the beverage commission is $0.$

d$.$ Use appropriate relative and absolute cell references.

$10$

$2\mathrm{.}6.$ Cony your formula in cell

$2\mathrm{.}7$ Beverly treats herself to