1-Use an IF function in cell J18 to calculate the commission earned for beverages for order 1. The beverage commission is 10% of the total sale if the customer buys a beverage. If the beverage sale amount (cell D18) is greater than 0 the beverage commission equals the sales total (cell G18) multiplied by the beverage commission rate (cell G12). Otherwise, the beverage commission is 0. Use appropriate relative and absolute cell references.

2-Beverly always treats herself to a donut if her daily commission is more than $40. Use an IF function in cell K13 to determine if she should buy herself a donut. Cell K13 should contain the value "Yes" if her total commission in cell K11 is more than $40. Otherwise cell K13 should contain the value "No"

how to find these two on an excel sheet

Sheet Guide IF fc Beverly always treats herself to a donut if her daily commission is more than $40. Use an IF function in cell K13 to determine if she should buy herself a donut. Cell K13 should contain the value "Yes" if her total commission in cell K11 is more than $40. Otherwise cell K13 should contain the value "No" [2 points] Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at leasta dozen they cost $.40 each. Beverly earns a commission based on her sales performance. Because the bakery makes so much money on beverages, she earns 10% commission (based on the total sale) when a customer buys a drink. She also earns commission on hersales. She earns 2% on each sale that totals more than $10. She earns 1% commission on each sale that totals more than $5 (but less than $10). She does not earn commission on each sale that totals $5 or less (though she will earn the beverage commission). Complete the table below to help Beverly calculate her commission based on the 50 customers she helped this morning. Total Sales Total Commission $669.75 $7,044.64 Price Per Donut Commission Rates Threshold Rate 10% $0.40 Beverage Sales > $5 Sales> $10 S5.00 Buy a donut? Sales Amount Commissions Order##Donuts Price/Donut Beverage 0.00 $0.00 $66.24 $37.20 0.00 $0.00 $7.50 Donuts $24.00 $4.80 $19.20 9.60 5.00 1.50 3.00 $19.20 $14.40 $3.00 $2.00 $1.50 $4.50 Rate Sales Beverage Total Commission $24.00 $4.80 $85.44 $46.80 5.00 2% | $0.48 | $0.00 0.40 $0.00$0.00 $0.00 48 24 $0.94$0.00 $0.10$0.00 0.00$0.00 $0.21$252.00 $0.38$0.00 $1.43$6,090.16 $0.00$0.00 $0.00$0.00 $0.00$0.00 $0.32 $169.16 $0.19$0.00 $0.94 $0.10 $0.00 $252.21 0.38 $6,091.59 $0.00 0.00 $0.00 $169.48 4 $0.50 S0.50 $0.50 $0.40 S56.88 $0.00 0.00 $0.00 $10.50 $19.20 $71.28 $3.00 2.00 $1.50 16.11 $0.50 0.50 4 $0.50 $0.00 $0.00