Follow the instructions from the file to fix the excel document and send that document back to me
Excel 2016 In Practice Independent Project 2-4 Instructions F5 ~ X v' f,, =HLOOKUP(ES,H _ Rates,2) A I B I C I D I E I F I G I H I I I J I K I L I M N 1_ Centra l Sierra Insura nce I Commission Sales and Bonuses 2 Function Arguments ? X 3 HLOOKUP 4 ID Last Name First Name Branch Commissions Bonus Rate Lookup_value I ES 1~1 = 15000< 101="" lincle="" bob="" cameron="" park="" sl'.,000="" rates="" 2)="" t~ble_array="" i="" h_rates="" 1~1="{3000,6000,9000," 12000,15000;0.015,0.(="" 6="" 102="" mccartnev="" lanita="" folsom="" s12="" ooo="" row_index_num="" 121="" 1~1="2" 7="" 103="" santos="" eleesha="" cameron="" park="" $5,500="" range_l="" ookup="" c="" ~="logteal" 8="" 104="" baxter="" roy="" granite="" bay="" s4,500="0.025" 9="" 105="" a="" laro="" jennifer="" folsom="" s3,000="" looki="" f="" or="" -,="" va="" l="" ue="" in="" th="" e="" top="" row="" of="" a="" tab="" l="" e="" or="" om1y="" ofvolun="" ond="" rcturn5="" t="" h="" e="" voluc="" in="" the="" h="" i="" me="" column="" fro="" m="" a="" row="" you="" specify,="" 10="" 115="" chan="" tami="" cameron="" park="" s3,ooo="" row_index_num="" is="" the="" row="" number="" in="" table_arrayfrom="" w="" hi="" ch="" the="" match="" ing="" value="" 11="" 117="" althouse="" charl="" ene="" granite="" bay="" s4,700="" sh="" ould="" be="" return="" ed="" .="" the="" firit="" row="" of="" volu="" c="" ~="" in="" the="" tabl="" e="" i="" ~="" row="" 1,="" 12="" 119="" taylor="" juan="" granite="" bay="" s41000="" 120="" reia="" wayne="" cameron="" park="" s41000="" formula="" rnult="0" .02~="" 13="" 14="" 125="" nevens="" cheryl="" cameron="" park="" s12,ooo="" hell;!:="" on="" this="" function="" i="" ok="" i="" ~="" 1j="" 15_="" j-="" -1-="" .="">< 2-100="" hlookup="" function="" to="" display="" bonus="" rate="" using="" microsoft="" excel="" 2016="" independent="" project="" 2-4="" step="" 1:="" download="" start="" file="" excel="" 2016="" chapter="" 2="" working="" with="" formulas="" and="" functions="" last="" updated:="" 12/18/17="" page="" 1="" independent="" project="" 2-4="" central="" sierra="" insurance="" (csi)="" sets="" bonus="" percentages="" based="" on="" commissions="" earned="" by="" each="" agent="" and="" calculates="" totals="" by="" branch="" office.="" this="" workbook="" also="" tracks="" fundraising="" efforts="" of="" employees="" for="" a="" community="" event.="" skills="" covered="" in="" this="" project="" •="" create,="" copy,="" and="" edit="" formulas.="" •="" name="" cell="" ranges.="" •="" set="" mathematical="" order="" of="" operations.="" •="" set="" cell="" references="" to="" be="" absolute.="" •="" use="" the="" now="" function.="" •="" use="" hlookup="" and="" vlookup="" functions.="" •="" use="" the="" sumif="" function.="" •="" build="" an="" if="" function.="" 1.="" open="" the="" centralsierra-02.xlsx="" start="" file.="" if="" the="" workbook="" opens="" in="" protected="" view,="" click="" the="" enable="" editing="" button="" so="" you="" can="" modify="" it.="" the="" file="" will="" be="" renamed="" automatically="" to="" include="" your="" name.="" change="" the="" project="" file="" name="" if="" directed="" to="" do="" so="" by="" your="" instructor,="" and="" save="" it.="" 2.="" on="" the="" tables="" sheet,="" select="" cells="" a6:b10="" and="" create="" range="" names="" using="" the="" create="" from="" selection="" dialog="" [formulas="" tab,="" defined="" names="" group].="" 3.="" select="" cells="" b1:f2="" and="" click="" the="" name="" box.="" name="" this="" as="" h_rates.="" 4.="" create="" an="" hlookup="" function="" to="" display="" the="" bonus="" rate.="" a.="" click="" the="" commissions="" sheet="" tab="" and="" select="" cell="" f5.="" b.="" start="" the="" hlookup="" function="" and="" use="" cell="" e5="" as="" the="" lookup_value.="" c.="" for="" the="" table_array="" argument,="" use="" the="" h_rates="" range.="" d.="" use="" the="" second="" row="" for="" the="" row_index_num="" argument="" (figure="" 2-100).="" 5.="" format="" the="" results="" as="" percent="" style="" with="" two="" decimal="" places.="" 6.="" copy="" the="" formula="" in="" cell="" f5="" to="" cells="" f6:f14.="" 7.="" set="" order="" of="" operations="" to="" calculate="" total="" earnings.="" a.="" select="" cell="" g5.="" b.="" build="" a="" formula="" to="" add="" the="" commissions="" amount="" (e5)="" to="" the="" commissions="" amount="" times="" the="" rate="" (f5*e5).="" c.="" copy="" the="" formula="" in="" cell="" g5="" to="" cells="" g6:g14.="" 8.="" create="" and="" copy="" a="" sumif="" function="" to="" calculate="" total="" earnings="" by="" branch="" office.="" a.="" select="" cell="" e18.="" b.="" start="" the="" sumif="" function="" with="" cells="" $d$5:$d$14="" as="" the="" range="" argument.="" fo="" rmat="" cells="" x="" ~="" alignment="" font="" i="" bo="" rder="" i="" fill="" i="" prot,="" ction="" i="" ~atego="" ry.="" general="" number="" currency="" .~m.°untin="" g="" time="" percentage="" fraction="" scientifi="" c="" text="" special="" cust="" om="" sample="" janua="" ry="" 1,="" 2018="" !ype:="" 14="" -ma="" r="" 14-mar-12="" 14-mar-12="" mar-12="" march-12="" ihffiilbf~="" i="" 3/="" 1-4/="" 12="" 1:30="" pm="" .!:o="" cale="" (lo="" cation):="" i="" english="" (united="" states~="" h="" date="" formats="" di="" splay="" date="" and="" time="" serial="" numb="" ers="" as="" date="" values.="" date="" fo="" rmats="" that="" begin="" w="" ith="" an="" asteri="" st="" (*)="" re="" spond="" to="" changes="" in="" regio="" nal="" date="" and="" time="" settings="" that="" .are="" specified="" for="" the="" o="" perating="" system="" .="" fo="" rmats="" without="" an="" a="" sterisk="" are="" not="" affeded="" by="" operating="" system="" sett="" ings="" .="" ~-o_k="" _~i="" i="" cancel="" 2-101="" date="" format="" selected="" using="" microsoft="" excel="" 2016="" independent="" project="" 2-4="" c.="" the="" criteria="" argument="" is="" a="" relative="" reference="" to="" cell="" c18.="" step="" 2="" upload="" &="" save="" step="" 3="" grade="" my="" project="" d.="" select="" cells="" g5:g14="" for="" the="" sum_range="" argument="" and="" make="" the="" references="" absolute.="" e.="" copy="" the="" formula="" in="" cell="" e18="" to="" cells="" e19:e20="" without="" formatting.="" f.="" format="" cells="" e18:e20="" as="" currency.="" 9.="" total="" the="" earnings="" in="" cell="" e21.="" 10.="" create="" and="" format="" the="" current="" date.="" a.="" select="" cell="" g23="" and="" insert="" the="" now="" function.="" b.="" select="" cell="" g23="" and="" click="" the="" number="" group="" launcher="" [home="" tab].="" on="" the="" number="" tab,="" select="" the="" date="" category.="" c.="" scroll="" the="" type="" list="" to="" find="" the="" date="" that="" displays="" the="" month="" spelled="" out,="" the="" date,="" a="" comma,="" and="" a="" four-digit="" year="" (figure="" 2-101).="" d.="" click="" ok.="" press="" ctrl+home.="" 11.="" create="" and="" copy="" a="" vlookup="" function="" to="" display="" goals="" for="" each="" funding="" source.="" a.="" click="" the="" family="" day="" sheet="" tab="" and="" select="" cell="" f6.="" b.="" start="" the="" vlookup="" function="" and="" use="" cell="" e6="" as="" the="" lookup_value.="" c.="" click="" the="" tables="" sheet="" tab="" for="" the="" table_array="" argument="" and="" use="" cells="" $a$6:$b$10.="" d.="" use="" the="" second="" column="" as="" the="" col_index_num="" argument.="" e.="" copy="" the="" formula="" in="" cell="" f6="" to="" cells="" f7:f20="" without="" formatting="" to="" preserve="" the="" fill="" color.="" f.="" format="" cells="" f6:f20="" as="" currency="" with="" no="" decimal="" places.="" 12.="" create="" and="" copy="" an="" if="" function.="" a.="" select="" cell="" h6="" and="" start="" an="" if="" function.="" b.="" type="" a="" logical_argument="" to="" determine="" if="" cell="" g6="" is="" greater="" than="" or="" equal="" to="" (="">=) cell F6. c. Type Yes as the Value_if_true argument and No as the Value_if_false argument. d. Copy the formula in cell H6 to cells H7:H20 without formatting to maintain the fill color. e. Center align cells H6:H20. f. Press Ctrl+Home. 13. Insert a new sheet at the end of the tab names and paste the range names starting in cell A1. Name the worksheet as Range Names. 14. Save and close the workbook (Figure 2-102). 15. Upload and save your project file. 16. Submit project for grading. Excel 2016 Chapter 2 Working with Formulas and Functions Last Updated: 12/18/17 Page 2 Central Sierra Insurance Fam ily Day Comm unit~ Fu ndrais;,r · - I: kmltr Fd,om CH10cno1on =Tabfe,!,e;,6 Cmh_OJrut i::Jn =T 11 bfe,!sB$-7 H..Rat•s -Tabl•slsBusf». Pedcml!be r~ole., =T11bfe,!s8s8 lt affie_l d::ets =T 11 bfes!sfi$.g w a111 .. .1u nJ)le<1g•-tabl•sl~ to 2-102 excel 2-4 completed independent project 2-4 skills covered in this project to="" 2-102="" excel="" 2-4="" completed="" independent="" project="" 2-4="" skills="" covered="" in="" this="">