"Central Sierra Insurance Commission Sales and Bonuses" ID Last Name First Name Branch Commissions Bonus Rate Commissions with Bonus $101$ Lingle Bob Cameron Park $$15,000102$ McCartney Lanita Folsom $$12,000103$ Santos Eleesha Cameron Park $$5,500104$ Baxter Roy Granite Bay $$4,500105$ Alaro Jennifer Folsom $$3,000115$ Chan Tami Cameron Park $$3,000117$ Althouse Charlene Granite Bay $$4,700119$ Taylor Juan Granite Bay $$4,000120$ Reza Wayne Cameron Park $$4,000125$ Nevens Cheryl Cameron Park $$12,000$ Mark the steps as checked when you complete them. Open the workbook 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$.$ Select the Tables sheet, select cells A$1$:B$6,$ and create range names using the Create from Selection button $[$Formulas tab, Defined Names group$].$ Create an XLOOKUP function to display the bonus rate. $($If XLOOKUP is not available, build the following formula $=$VLOOKUP$($E$5,$Tables!$A$$2$:$B$$6,2).$ Leave the Range$\_$lookup argument empty so that VLOOKUP finds the closest match$).$ Click the Commissions sheet tab and select cell F$5.$ Start the XLOOKUP function and use cell E$5$ as the Lookup$\_$value. For the Lookup$\_$array argument, use the Commission$\_$Level range. For the Return$\_$array argument, use the Bonus$\_$Rate range. For the Match$\_$mode argument, type $1$ which finds the next smaller match $($Figure $2-106).$ XLOOKUP function to display bonus rate Figure $2-106$ XLOOKUP function to display bonus rate Format the result as Percent Style with two decimal places. Copy the formula in cell F$5$ to cells F$6$:F$14.$ Set order of operations to calculate the commission and bonus totals. $($An alternative formula is $=$E$5*(1+$F$5)).$ Select cell G$5.$ The total paid is the dollar amount of the commissions plus the commissions times t km to miles