do 2.1-2.7

Beverly seits denuts for 5.5 each at ine ioes bakery. if a custemer buja at feas a dozen Gowuts, the cojr is festuced 5.40 ach. EPvorly elarns a cormmsish bateed on the numbetr of donat she sitis fog customer. - if a saie totals reare than 110 , the carms a. ore biat sale toieal, - Ia sale totals mers than sis tout as 110 or lessk, she rarns 1 th. cummishet on that sale tofal - If a saie tocal ts or lesk stre dones notecom a comuriminn: fecause the bwery inavea so much meneyon biveriges, the alab farm a bererige commiston in adertert be her dorest commeculor. Hiventy ears a 10a contimissices oos the fecal sale ed any order where al cultimer buy a worksheet to help Beverly calculate her commission based on the 50 customers she helped this marning. (2.) Use an if function in cell E10] to calculare the price to charge per donut for order 1. a. Customer are charged s. 50 per. donut unless they buy a dozen or more, In this case, they ate charged 5.40 a donut. b. Refer to the appropriate price in cells (C3) and CA ) for your value if true" and value. if talse" argument: c. Use abseluee and relativet references when appropriate (5)) (22) copy ybur formina in cell (23) Use an if function in ceif H110] (24) Copy your formuta in cell (25) Lse an yf Auscrion in cell 110 (2.1) Use an IF function in celi ETO to calculate the price to charge per donve for order 1. a. Customer are charged 5.50per donut unless they bwy a doren of more. In this case, they are charged 5.40 a donut. . Refer to the appropriate price in cells C3 and C4 foryour "value of true" and value if false: argument: c. Use absciute and reiathe references whert appropriate. (2.2) Copy your tormala in cell Etojand paste it down to camplece the "Price/Donut" column of the table. (23) Ust an if funceion in cell M10) Copy your formula incell Use an if function in ceil 1L0. Copy your formela in coll 110 . (2.2) Copy your fammuls in ceil E10) and paste it dowa to coin plete the Pricerponut column of the table. 11 (7) (jie an if funceon inceil H19. to calculate the commissian rate for the total sale for order 1. a. The commision rate is 24 for al sales that total more chan 510 if is 176 for all sales that total inore. than $5, but arcless than or equal 10.510 b. No comumession is paid on saies that total $5 ef lies. c Meference the thireshold levels. (ceits 75 ) and f6 ) in yeur logical bests for your If furction and the comrnistian rates (celis G5) and G6 ds your "Yalue if trye and Vasue if fabe aghamenti. d. Use appregeiate relative and absulua references. than 55 , bot are less than or equal to $10. bx. No cortirnission is paid on sales that total 55 of lass. c. Peference the threshold ievels: (cells. 55 ) and 66 an yous logital. tests for your if function and the commission rates (ceits 55 fand G6.) as yout "vake it true" and Nalue if fakre" argumerits. d. Uise sppropriafe relabive and absolufe referericet. (24) Capy your formula io cell HIO) and pasqe it down to complete the "Rate" column of the table (4) (25) Use an if function in cel 1 to. to calculate the commiasion earned far beverages for order:-1. a. The beverage cominssion is 104 of the total sale if the customer bays a boverage. b. If the beveragtede amount icell Dios is ereater than 0 , the biverage commtssion chua tie tates total (cell 5 ro) multiplied by the beverage reminisuon tate icelf cia. c) Oherwire the beverage cortmiguon a 0. d. Use apgroprate relotive and abselise cerf teferences. b. If the beverage saies ameunt fcel Dioj is grester than 0 , the beverage contmbsion equals the sales total fcell 610. multipued by the beverase cornmisilon rate. (ceil G4) ) c. Otherwise, the beverase commission is Q. d. Use apgropriate eflatle and absolute ceil referentes. (26) Copyyour formisa in cell /10. and paste it dowe to complete the "Reperage' comvisson column of the table. 1. (27) Eencely treats herself to a darsut if ber daly commissont is mor: than her set Donut Threshald a. Use an if tuncoion lis cril ks to defermine if the should buy herself a dorut. b. Ceil kS I should contain the value "Vei" if her tocal commiseion in cel x3 is more than her "Donut. Thieshold: Ctherwise, cell (ks) should contan the value "Wo" d. Besur tarafecence the "Dond theshold value in ceil not in your fermula