Does my work seem correct given with these instructions?

A14 x fx L A B C D E F G J K 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 her sales. 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 Price Per Donut 0-11 $0.50 12+ $0.40 Total Sales Total Commission $669.75 $39.95 Commission Rates Type Threshold Beverage Sales > $5 $5.00 Sales > $10 $10.00 Rate 10% 1% 2% Buy a donut? no Rate 2% ..... 0% 2% 2% 4 5 6 7 8 9 10 11 12 13 4 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 30 35 36 37 30 38 39 10 40 0% 0% 2% 2% 270 2 0% 0% 0% 2% 1% 0% 0% 41 12 42 42 43 43 44 44 40 45 46 47 17 48 49 50 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Sales Amount Order # # Donuts Beverage Price/Donut 1 60 $0.00 $0.40 ... 2 12 $0.00 $0.40 . 3 48 $66.24 $0.40 4 24 $37.20 $0.40 5 10 $0.00 $0.50 6 3 $0.00 $0.50 . 7 6 $7.50 $0.50 8 48 $0.00 $0.40 9 36 $56 88 $56.88. $0.40 10 6 $0.00 $0.50 $ 11 4 $0.00 $0.50 12 3 $0.00 $0.50 13 9 ma $11.61 $0.50 14 24 $0.00 con $0.40 15 7 $0.00 $0.50 16 10 $0.00 $0.50 $ 17 2 0 $0.00 $0.50 $ 18 60 $0.00 $0.40 19 12 $0.00 $0.40 $ 20 3 $0.00 so ...... $0.50 21 24 $0.00 $0.40 22 4 $5.76 . $0.50 23 24 $0.00 $0.40 24 8 $10.00 $10.40. $0.50 25 60 $0.00 ca $0.40 26 36 $0.00 so $0.40 . 27 9 son con $0.00 ...... $0.50 28 7 ...... $0.00 $0.50 29 8 $0.00 con ...... $0.50 30 36 $0.00 con $0.40 31 3 $0.00 co $0.50 con Coo 32 11 $0.00 $0.50 33 12 $1.49 $0.40 34 3 $0.00 co con $0.50 35 60 $0.00 $0.40 36 36 $0.00 $0.40 37 36 $0.00 $0.40 38 36 $0.00 ..... $0.40 39 48 $0.00 $0.40 ..... 40 9 $14.31 $0.50 41 60 $0.00 $0.40 ..... 42 60 $0.00 $0.40 43 24 $0.00 $0.40 44 24 $0.00 $0.40 45 36 $0.00 ... $0.40 46 12 $0.00 $0.40 47 5 $0.00 $0.50 48 7 $0.00 $0.50 49 5 $0.00 $0.50 50 4 $6.16 $0.50 Donuts $24.00 .... $4.80 . $19.20 $9.60 $5.00 $1.50 $3.00 $19.20 $14.40 $3.00 $ ..2.0. $2.00 $1.50 $4.50 $ So $9.60 ca $3.50 $5.00 $1.00 $24.00 $4.80 $1.50 $9.60 $2.00 $9.60 $4.00 non $24.00 $14.40 $4.50 50 $3.50 $4.00 ca man $14.40 $1.50 $5.50 $4.80 $1.50 $24.00 $14.40 $14.40 $14.40 $19.20 $4.50 $24.00 . $24.00 ... $9.60 $9.60 $14.40 .... $4.80 $2.50 $3.50 $2.50 $2.00 Total $24.00 ...... $4.80 ... $85.44 $46.80 ........ $5.00 $1.50 $10.50 . $19.20 $71.28 co $3.00 $2.00 $ $1.50 $16.11 $9.60 $3.50 $5.00 $1.00 sum $24.00 $4.80 $1.50 . enco $9.60 $7.76 $ $9.60 $14.40 $24.00 $14.40 $4.50 TA doen ........ $3.50 $4.00 $14.40 $1.50 TER $5.50 $6.29. $1.50 $24.00 $14.40 $14.40 $14.40 $19.20 1.2 $18.81 ... $24.00 ... $24.00 a.com $9.60 $9.60 .. $14.40 $4.80 ... $2.50 $3.50 $2.50 $8.16 0% 2% 0% 0% 1% 1% 1% 2% 2% 2% 0% 0% 0% 2% 0% 1% 1% 0% 2% 2% 2% 2% 2% 2% 2% 2% 1% 1% 2% 0% 0% 0% 0% 1% Commissions Sales Beverage Total Commission $0.48 $0.00 $0.48 ..... $0.00 $0.00 $0.00 $1.71 $8.54 $10.25 .. .. $0.94 $4.68 $5.62 ... . $0.00 $0.00 $0.00 . $0.00 $0.00 $0.00 ... $0.21 $1.05 $1.26 $0.38 $0.00 $0.38 Tor $1.43... $7.13 $8.55 $0.00 $0.00 $0.00 $0.00 $0.00 JU......... $0.00 $0.00 $0.00 $0.00 $0.32 $1.61 $1.93 $0.10 $0.00 $0.10 $ $0.00 $0.00 JU......... $0.00 $0.00 $0.00 JU......... $0.00 $0.00 $0.00 non SU.00..... $0.48 $0.00 $0.48 ........... $0.00 $0.00 JU......... $0.00 $0.00 $0.00 JU......... $0.00 $0.10 $0.00 $0.10 . $0.08 $0.78 $0.85 $0.10 $0.00 SU..10....... $0.10 $0.29 $1.44 $1.73 $0.48 $0.00 $0.48 $0.29 $0.00 20 $0.29 JU........... $0.00 $0.00 $0.00 .............. $0.00 $0.00 JU......... $0.00 $0.00 $0.00 $0.00 $0.29 $0.00 $0.29 . $0.00 $0.00 $0.00 $0.06 $0.00 $0.06 $0.06 $0.63 $0.69 $0.00 $0.00 $0.00 $0.48 $0.00 $0.48 $0.29 $0.00 $0.29 . $0.29 $0.00 $0.29 $0.29 $0.00 $0.29 ... $0.38 $0.00 $0.38 $0.38 $1.88 $2.26 . .. $0.48 $0.00 $0.48 $0.48 $0.00 $0.48 ... $0.10 $0.00 $0.10 .... $0.10 $0.00 $0.10 . $0.29 $0.00 $0.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.08 $0.82 $0.90 . Task # Points Task Description 1 5 Use an IF function in cell E18 to calculate the price to charge per donut for order 1. A customer is charged $.50 per donut unless they buy a dozen or more. In this case, they are charged $.40 a donut. Refer to the appropriate price in cells C11 and C12 for your "value_if_true" and "value_if_false" arguments. Use absolute and relative references when appropriate. 2 1 Copy your formula in cell E18 and paste it down to complete the "Price/Donut" column of the table. 3 5 Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references. 4 1 Copy your formula in cell H18 and paste it down to complete the "Rate" column of the table. 5 5 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. 6 1 Copy your formula in cell J18 and paste it down to complete the "Beverage" commission column of the table. 7 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" Total: 20 A14 x fx L A B C D E F G J K 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 her sales. 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 Price Per Donut 0-11 $0.50 12+ $0.40 Total Sales Total Commission $669.75 $39.95 Commission Rates Type Threshold Beverage Sales > $5 $5.00 Sales > $10 $10.00 Rate 10% 1% 2% Buy a donut? no Rate 2% ..... 0% 2% 2% 4 5 6 7 8 9 10 11 12 13 4 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 30 35 36 37 30 38 39 10 40 0% 0% 2% 2% 270 2 0% 0% 0% 2% 1% 0% 0% 41 12 42 42 43 43 44 44 40 45 46 47 17 48 49 50 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Sales Amount Order # # Donuts Beverage Price/Donut 1 60 $0.00 $0.40 ... 2 12 $0.00 $0.40 . 3 48 $66.24 $0.40 4 24 $37.20 $0.40 5 10 $0.00 $0.50 6 3 $0.00 $0.50 . 7 6 $7.50 $0.50 8 48 $0.00 $0.40 9 36 $56 88 $56.88. $0.40 10 6 $0.00 $0.50 $ 11 4 $0.00 $0.50 12 3 $0.00 $0.50 13 9 ma $11.61 $0.50 14 24 $0.00 con $0.40 15 7 $0.00 $0.50 16 10 $0.00 $0.50 $ 17 2 0 $0.00 $0.50 $ 18 60 $0.00 $0.40 19 12 $0.00 $0.40 $ 20 3 $0.00 so ...... $0.50 21 24 $0.00 $0.40 22 4 $5.76 . $0.50 23 24 $0.00 $0.40 24 8 $10.00 $10.40. $0.50 25 60 $0.00 ca $0.40 26 36 $0.00 so $0.40 . 27 9 son con $0.00 ...... $0.50 28 7 ...... $0.00 $0.50 29 8 $0.00 con ...... $0.50 30 36 $0.00 con $0.40 31 3 $0.00 co $0.50 con Coo 32 11 $0.00 $0.50 33 12 $1.49 $0.40 34 3 $0.00 co con $0.50 35 60 $0.00 $0.40 36 36 $0.00 $0.40 37 36 $0.00 $0.40 38 36 $0.00 ..... $0.40 39 48 $0.00 $0.40 ..... 40 9 $14.31 $0.50 41 60 $0.00 $0.40 ..... 42 60 $0.00 $0.40 43 24 $0.00 $0.40 44 24 $0.00 $0.40 45 36 $0.00 ... $0.40 46 12 $0.00 $0.40 47 5 $0.00 $0.50 48 7 $0.00 $0.50 49 5 $0.00 $0.50 50 4 $6.16 $0.50 Donuts $24.00 .... $4.80 . $19.20 $9.60 $5.00 $1.50 $3.00 $19.20 $14.40 $3.00 $ ..2.0. $2.00 $1.50 $4.50 $ So $9.60 ca $3.50 $5.00 $1.00 $24.00 $4.80 $1.50 $9.60 $2.00 $9.60 $4.00 non $24.00 $14.40 $4.50 50 $3.50 $4.00 ca man $14.40 $1.50 $5.50 $4.80 $1.50 $24.00 $14.40 $14.40 $14.40 $19.20 $4.50 $24.00 . $24.00 ... $9.60 $9.60 $14.40 .... $4.80 $2.50 $3.50 $2.50 $2.00 Total $24.00 ...... $4.80 ... $85.44 $46.80 ........ $5.00 $1.50 $10.50 . $19.20 $71.28 co $3.00 $2.00 $ $1.50 $16.11 $9.60 $3.50 $5.00 $1.00 sum $24.00 $4.80 $1.50 . enco $9.60 $7.76 $ $9.60 $14.40 $24.00 $14.40 $4.50 TA doen ........ $3.50 $4.00 $14.40 $1.50 TER $5.50 $6.29. $1.50 $24.00 $14.40 $14.40 $14.40 $19.20 1.2 $18.81 ... $24.00 ... $24.00 a.com $9.60 $9.60 .. $14.40 $4.80 ... $2.50 $3.50 $2.50 $8.16 0% 2% 0% 0% 1% 1% 1% 2% 2% 2% 0% 0% 0% 2% 0% 1% 1% 0% 2% 2% 2% 2% 2% 2% 2% 2% 1% 1% 2% 0% 0% 0% 0% 1% Commissions Sales Beverage Total Commission $0.48 $0.00 $0.48 ..... $0.00 $0.00 $0.00 $1.71 $8.54 $10.25 .. .. $0.94 $4.68 $5.62 ... . $0.00 $0.00 $0.00 . $0.00 $0.00 $0.00 ... $0.21 $1.05 $1.26 $0.38 $0.00 $0.38 Tor $1.43... $7.13 $8.55 $0.00 $0.00 $0.00 $0.00 $0.00 JU......... $0.00 $0.00 $0.00 $0.00 $0.32 $1.61 $1.93 $0.10 $0.00 $0.10 $ $0.00 $0.00 JU......... $0.00 $0.00 $0.00 JU......... $0.00 $0.00 $0.00 non SU.00..... $0.48 $0.00 $0.48 ........... $0.00 $0.00 JU......... $0.00 $0.00 $0.00 JU......... $0.00 $0.10 $0.00 $0.10 . $0.08 $0.78 $0.85 $0.10 $0.00 SU..10....... $0.10 $0.29 $1.44 $1.73 $0.48 $0.00 $0.48 $0.29 $0.00 20 $0.29 JU........... $0.00 $0.00 $0.00 .............. $0.00 $0.00 JU......... $0.00 $0.00 $0.00 $0.00 $0.29 $0.00 $0.29 . $0.00 $0.00 $0.00 $0.06 $0.00 $0.06 $0.06 $0.63 $0.69 $0.00 $0.00 $0.00 $0.48 $0.00 $0.48 $0.29 $0.00 $0.29 . $0.29 $0.00 $0.29 $0.29 $0.00 $0.29 ... $0.38 $0.00 $0.38 $0.38 $1.88 $2.26 . .. $0.48 $0.00 $0.48 $0.48 $0.00 $0.48 ... $0.10 $0.00 $0.10 .... $0.10 $0.00 $0.10 . $0.29 $0.00 $0.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.08 $0.82 $0.90 . Task # Points Task Description 1 5 Use an IF function in cell E18 to calculate the price to charge per donut for order 1. A customer is charged $.50 per donut unless they buy a dozen or more. In this case, they are charged $.40 a donut. Refer to the appropriate price in cells C11 and C12 for your "value_if_true" and "value_if_false" arguments. Use absolute and relative references when appropriate. 2 1 Copy your formula in cell E18 and paste it down to complete the "Price/Donut" column of the table. 3 5 Use an IF function in cell H18 to calculate the commission rate for the total sale for order 1. The commission rate is 2% for all sales that total more than $10 and 1% for all sales that total more than $5. No commission is paid on sales that total $5 or less. Reference the threshold levels (cells F13 and F14) in your logical tests for your IF function and the commission rates (cells G13 and G14) as your "value_if_true" and "value_if_false" arguments. Use appropriate relative and absolute references. 4 1 Copy your formula in cell H18 and paste it down to complete the "Rate" column of the table. 5 5 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. 6 1 Copy your formula in cell J18 and paste it down to complete the "Beverage" commission column of the table. 7 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" Total: 20