Use HLOOKUP and VLOOKUP Use the SUMIF function. Build an IF function. K https://brightspac... Steps to complete This Project Mark the steps as checked when you complete them. 1. Open the start file Central Sierra-02.xlsx 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. 2. Select the Tables sheet, select cells A6:B10, and create range names using the Create from Selection button [Formulas tab, Defined Names group]. a. 0 Temps rise Assignments Piercey, Tera (pier0254) 3. Select cells B1:F2 and click the Name box. Name the selection H Alaia iL i il. arranged in Reset Progress Back to top 4. Create an HLOOKUP function to display the bonus rate. Click the Commissions sheet tab and select cell F1 T F2 F3 Q Search F4 F5 n