Open the start file CentralSierra$-02.$xisx workbook. 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$6$:B$10,$ and create range names using the Create from Selection button $[$Formulas tab, Defined Names group$].$

Select cells B$1$:F$2$ and click the Name box. Name the selection$/$HRates$.$ Note that the first row is arranged in ascending order.

Create an HLOOKUP function to display the bonus rate.

a$.$ Click the Commissions sheet tab and select cell F$5.$

b$.$ Start the HLOOKUP function and use cell E$5$ 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).$

$$ Format the results 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 total earnings.

a$.$ Select cell G$5.$

b$.$ Build a formula to add the to the commissions

Figure $2-100$ HLOOKUP function to display bonus

amount times the rate $($F$5*$E$5).$

c$.$ Copy the formula in cell G$5$ to cells G$6$:G$14.$