NEED ANSWERED ASAP!!

Assignment Tasks Context for IF Tasks Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. This set of tasks has a total of 20 points. A B D E F G H J M 1 2 3 4 5 6 7 8 Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. Price Per Donut Commission Rates Total Sales $217.55 0-11 $0.50 Type Threshold Rate Total Commission $0.00 12+ $0.40 Beverage 10% Sales > $5 $5.00 1% Buy a donut? Sales > $10 $10.00 9 10 11 12 13 14 15 296 D E F G H Rate 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Sales Amount Order # #Donuts Beverage Price/Donut 1 60 $0.00 2 12 $0.00 3 48 $66.24 4 24 $37.20 5 10 $0.00 6 3 $0.00 7 6 $7.50 8 48 $0.00 9 36 $56.88 10 6 $0.00 11 4 $0.00 12 3 $0.00 13 9 $11.61 14 24 $0.00 15 7 $0.00 16 10 $0.00 17 2 $0.00 18 60 $0.00 19 12 $0.00 20 3 $0.00 21 24 $0.00 22 4 $5.76 23 24 $0.00 24 8 $10.40 25 60 $0.00 26 36 $0.00 27 9 $0.00 28 7 $0.00 29 8 $0.00 30 36 $0.00 31 3 $0.00 32 11 $0.00 33 12 $1.49 34 3 $0.00 35 60 $0.00 36 36 $0.00 37 36 $0.00 38 36 $0.00 39 48 $0.00 40 9 $14.31 41 60 $0.00 Donuts $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.00 $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.00 $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.00 $0.00 $0.00 Total $0.00 $0.00 $66.24 $37.20 $0.00 $0.00 $7.50 $0.00 $56.88 $0.00 $0.00 $0.00 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 Commissions Sales Beverage $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.00 $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.00 $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.00 $0.00 $0.00 Total Commission $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.00 $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.00 $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.00 $0.00 $0.00 Ann B D E F . J K 9 24 7 10 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 2 60 12 3 24 4 24 8 60 36 9 7 8 36 3 11 12 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.16 $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.00 $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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.16 $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.00 $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.00 $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.00 $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.00 $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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 3 60 36 36 36 48 9 60 60 24 24 36 12 5 7 5 45 46 47 48 49 50 Home Insert Draw Page Layout Formulas Data Review View Assignment Tell me Share Comments X Calibri (Body) 11 ab Wrap Text Currency ST ZY .O. 5 Paste av A. .00 V Delete Insert Format 3 Merge & Center Conditional Format Formatting as Table Ideas Sort & Find & Filter Select Cell Styles E18 A B D E F G J L L M N O P Q R S T U V W Y Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning Price Per Donut 0-11 $0.50 12+ $0.40 Commission Rates Threshold Total Sales Total Commission $217.55 $0.00 Assignment Tasks Context for IF Tasks Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. Type Beverage Sales > $5 Sales > $10 Rate 10% 1% 2% $5.00 $10.00 Buy a donut? This set of tasks has a total of 20 points. 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 15 e 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 -40 -41 42 -43 44 Sales Amount Order # #Donuts Beverage Beverage Price/Donut 1 60 $0.00 2 12 $0.00 3 48 $66.24 4 24 $37.20 5 5 10 $0.00 6 3 $0.00 7 6 $7.50 8 48 $0.00 9 36 $56.88 10 6 $0.00 11 4 $0.00 12 3 3 $0.00 13 9 $11.61 14 24 $0.00 15 7 $0.00 16 10 $0.00 17 2 $0.00 18 60 $0.00 19 12 $0.00 20 3 $0.00 21 24 $0.00 22 4 $5.76 23 24 $0.00 24 8 $10.40 25 60 $0.00 26 36 $0.00 27 9 Sann Boolean Functions IF Function Donuts Total $0.00 $0.00 $0.00 $0.00 $0.00 $66.24 $0.00 $37.20 $0.00 $0.00 $0.00 $0.00 $0.00 $7.50 $0.00 $0.00 $0.00 $56.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.61 $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.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $0.00 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 S000 Lookup Functions Commissions Rate Sales Beverage $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.00 $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.00 $0.00 Conditional Functions Total Commission $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.00 $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.00 S000 + Select destination and press ENTER or choose Paste Average: $20.30 Count: 3 Sum: $60.90 + 100% Home Insert Draw Page Layout Formulas Data Review View Assignment Tell me Share o Comments Calibri (Body) V 11 P A = = ab Wrap Text Currency E- 28On 5 V Paste au A. == .00 $ % ) 60 00 Insert V Delete Format Merge & Center Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select E18 fx H . J L M N 0 P Q R S T U V W Y $0.00 Assignment Tasks Context for IF Tasks Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. $0.00 B D E F 36 19 12 $0.00 $0.00 $0.00 37 20 3 $0.00 $0.00 $0.00 38 21 24 $0.00 $0.00 $0.00 39 22 4 $5.76 $0.00 $5.76 40 23 24 $0.00 $0.00 41 24 8 $10.40 $0.00 $10.40 42 25 60 $0.00 $0.00 $0.00 43 26 36 $0.00 $0.00 $0.00 44 27 9 $0.00 $0.00 $0.00 45 28 7 $0.00 $0.00 $0.00 46 29 8 $0.00 $0.00 $0.00 47 30 36 $0.00 $0.00 $0.00 48 31 3 $0.00 $0.00 $0.00 $ 49 32 11 $0.00 $0.00 $0.00 50 33 12 $1.49 $0.00 $1.49 51 34 3 $0.00 $0.00 $0.00 52 35 60 $0.00 $0.00 $0.00 53 36 36 $0.00 $0.00 $0.00 54 37 36 $0.00 $0.00 $0.00 55 38 36 $0.00 $0.00 $0.00 56 39 48 $0.00 $0.00 $0.00 57 40 9 9 $14.31 $0.00 $14.31 58 41 60 $0.00 $0.00 $0.00 59 42 60 $0.00 $0.00 $0.00 60 43 24 $0.00 $0.00 61 44 24 $0.00 $0.00 $0.00 62 45 36 $0.00 $0.00 $0.00 63 46 12 $0.00 $0.00 $0.00 64 47 5 $0.00 $0.00 $0.00 65 48 7 $0.00 $0.00 $0.00 66 49 5 $0.00 $0.00 $0.00 67 67 50 4 $6.16 $0.00 $6.16 68 69 70 71 72 73 74 75 76 77 78 79 Boolean Functions IF Function Lookup Functions Select destination and press ENTER or choose Paste I $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.00 $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.00 $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.00 $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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 This set of tasks has a total of 20 points. $0.00 Conditional Functions + Average: $20.30 Count: 3 Sum: $60.90 13 + 100% Assignment Tasks Context for IF Tasks Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. This set of tasks has a total of 20 points. A B D E F G H J M 1 2 3 4 5 6 7 8 Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. Price Per Donut Commission Rates Total Sales $217.55 0-11 $0.50 Type Threshold Rate Total Commission $0.00 12+ $0.40 Beverage 10% Sales > $5 $5.00 1% Buy a donut? Sales > $10 $10.00 9 10 11 12 13 14 15 296 D E F G H Rate 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Sales Amount Order # #Donuts Beverage Price/Donut 1 60 $0.00 2 12 $0.00 3 48 $66.24 4 24 $37.20 5 10 $0.00 6 3 $0.00 7 6 $7.50 8 48 $0.00 9 36 $56.88 10 6 $0.00 11 4 $0.00 12 3 $0.00 13 9 $11.61 14 24 $0.00 15 7 $0.00 16 10 $0.00 17 2 $0.00 18 60 $0.00 19 12 $0.00 20 3 $0.00 21 24 $0.00 22 4 $5.76 23 24 $0.00 24 8 $10.40 25 60 $0.00 26 36 $0.00 27 9 $0.00 28 7 $0.00 29 8 $0.00 30 36 $0.00 31 3 $0.00 32 11 $0.00 33 12 $1.49 34 3 $0.00 35 60 $0.00 36 36 $0.00 37 36 $0.00 38 36 $0.00 39 48 $0.00 40 9 $14.31 41 60 $0.00 Donuts $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.00 $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.00 $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.00 $0.00 $0.00 Total $0.00 $0.00 $66.24 $37.20 $0.00 $0.00 $7.50 $0.00 $56.88 $0.00 $0.00 $0.00 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 Commissions Sales Beverage $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.00 $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.00 $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.00 $0.00 $0.00 Total Commission $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.00 $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.00 $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.00 $0.00 $0.00 Ann B D E F . J K 9 24 7 10 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 2 60 12 3 24 4 24 8 60 36 9 7 8 36 3 11 12 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.16 $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.00 $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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.61 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.49 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.31 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.16 $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.00 $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.00 $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.00 $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.00 $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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 3 60 36 36 36 48 9 60 60 24 24 36 12 5 7 5 45 46 47 48 49 50 Home Insert Draw Page Layout Formulas Data Review View Assignment Tell me Share Comments X Calibri (Body) 11 ab Wrap Text Currency ST ZY .O. 5 Paste av A. .00 V Delete Insert Format 3 Merge & Center Conditional Format Formatting as Table Ideas Sort & Find & Filter Select Cell Styles E18 A B D E F G J L L M N O P Q R S T U V W Y Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning Price Per Donut 0-11 $0.50 12+ $0.40 Commission Rates Threshold Total Sales Total Commission $217.55 $0.00 Assignment Tasks Context for IF Tasks Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. Type Beverage Sales > $5 Sales > $10 Rate 10% 1% 2% $5.00 $10.00 Buy a donut? This set of tasks has a total of 20 points. 1 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 15 e 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 -40 -41 42 -43 44 Sales Amount Order # #Donuts Beverage Beverage Price/Donut 1 60 $0.00 2 12 $0.00 3 48 $66.24 4 24 $37.20 5 5 10 $0.00 6 3 $0.00 7 6 $7.50 8 48 $0.00 9 36 $56.88 10 6 $0.00 11 4 $0.00 12 3 3 $0.00 13 9 $11.61 14 24 $0.00 15 7 $0.00 16 10 $0.00 17 2 $0.00 18 60 $0.00 19 12 $0.00 20 3 $0.00 21 24 $0.00 22 4 $5.76 23 24 $0.00 24 8 $10.40 25 60 $0.00 26 36 $0.00 27 9 Sann Boolean Functions IF Function Donuts Total $0.00 $0.00 $0.00 $0.00 $0.00 $66.24 $0.00 $37.20 $0.00 $0.00 $0.00 $0.00 $0.00 $7.50 $0.00 $0.00 $0.00 $56.88 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.61 $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.00 $0.00 $0.00 $0.00 $0.00 $5.76 $0.00 $0.00 $0.00 $10.40 $0.00 $0.00 $0.00 $0.00 $0.00 S000 Lookup Functions Commissions Rate Sales Beverage $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.00 $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.00 $0.00 Conditional Functions Total Commission $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.00 $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.00 S000 + Select destination and press ENTER or choose Paste Average: $20.30 Count: 3 Sum: $60.90 + 100% Home Insert Draw Page Layout Formulas Data Review View Assignment Tell me Share o Comments Calibri (Body) V 11 P A = = ab Wrap Text Currency E- 28On 5 V Paste au A. == .00 $ % ) 60 00 Insert V Delete Format Merge & Center Ideas Conditional Format Cell Formatting as Table Styles Sort & Filter Find & Select E18 fx H . J L M N 0 P Q R S T U V W Y $0.00 Assignment Tasks Context for IF Tasks Beverly sells donuts at the local bakery. Donuts cost $.50 each unless customers buy a dozen or more. When customers buy at least a 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 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 calculate her commission based on the 50 customers she helped this morning. $0.00 B D E F 36 19 12 $0.00 $0.00 $0.00 37 20 3 $0.00 $0.00 $0.00 38 21 24 $0.00 $0.00 $0.00 39 22 4 $5.76 $0.00 $5.76 40 23 24 $0.00 $0.00 41 24 8 $10.40 $0.00 $10.40 42 25 60 $0.00 $0.00 $0.00 43 26 36 $0.00 $0.00 $0.00 44 27 9 $0.00 $0.00 $0.00 45 28 7 $0.00 $0.00 $0.00 46 29 8 $0.00 $0.00 $0.00 47 30 36 $0.00 $0.00 $0.00 48 31 3 $0.00 $0.00 $0.00 $ 49 32 11 $0.00 $0.00 $0.00 50 33 12 $1.49 $0.00 $1.49 51 34 3 $0.00 $0.00 $0.00 52 35 60 $0.00 $0.00 $0.00 53 36 36 $0.00 $0.00 $0.00 54 37 36 $0.00 $0.00 $0.00 55 38 36 $0.00 $0.00 $0.00 56 39 48 $0.00 $0.00 $0.00 57 40 9 9 $14.31 $0.00 $14.31 58 41 60 $0.00 $0.00 $0.00 59 42 60 $0.00 $0.00 $0.00 60 43 24 $0.00 $0.00 61 44 24 $0.00 $0.00 $0.00 62 45 36 $0.00 $0.00 $0.00 63 46 12 $0.00 $0.00 $0.00 64 47 5 $0.00 $0.00 $0.00 65 48 7 $0.00 $0.00 $0.00 66 49 5 $0.00 $0.00 $0.00 67 67 50 4 $6.16 $0.00 $6.16 68 69 70 71 72 73 74 75 76 77 78 79 Boolean Functions IF Function Lookup Functions Select destination and press ENTER or choose Paste I $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.00 $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.00 $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.00 $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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 This set of tasks has a total of 20 points. $0.00 Conditional Functions + Average: $20.30 Count: 3 Sum: $60.90 13 + 100%