1. In the Commission & Bonus column (H), use the Lookup function*.

   Apply the correct formula to cell H14 (based on total sales) and fill down the formula through H26. (Hint: At one point, you will need to use absolute referencing on certain ranges so that your formula works for the entire column.)

Excel File Edit View Insert Format Tools Data Window Help ON Sun Nov 22 6:37 PM $ U AutoSave OF: Dominguez_Alex_A12_ Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Open Sans V Insert v 12 A Y General sy, Wrao Text D Y 3 Paste B Merga & Centar v % 9 Delete Format Conditional Format Cell Formatting as Table Styles Ideas Z Sort & Filter Find & Select Sensitivity A1 fr PLS 21 Associate Sales Employees Report L M N O a A B C D E F G H 1 J K 1 PLS 21 Associate Sales Employees Report 2 Shipping UC Davis 3 Address 1 Shields Ave. 4 Davis, CA 95616 5 Base Salary $25 6 Commission 10% 7 8 Sales $0 $50 $75 $100 $125 $150 Commission & 9 Bonus $1.00 $5.00 $6.50 $8.00 $10.00 $12.50 10 11 12 Quarterly Sales (in thousands) Total Commision & Total Date Years 13 Employee First Second Third Fourth Sales Salary Bonus Salary Hired W/Fim 14 Gabrielle 26.93 14.23 4.12 8.22 53.50 47.19 28-Jan-17 15 Mitchell 22.18 18.34 32.54 7.50 80.56 53.74 27-May-97 16 Kyle 42.03 11.23 30.50 29.81 113.57 38.52 2-Jul-05 17 Courtney 7.14 11.50 12.87 18.04 49.55 47.54 8-May-01 18 Juliana 15.24 28.41 15.90 20.12 79.67 42.22 14-Aug-19 19 Paul 36.06 32.12 22.10 29.41 119.69 52.16 18-Aug-02 20 Bella 38.29 26.52 21.12 20.65 106.58 37.29 23-May-09 21 Liyuan 14.87 32.49 53.87 33.33 134.56 53.11 24-Dec-12 22 Caleb 15.98 9.50 12.47 18.50 56.45 37.46 29-Jun-07 23 Jenny 33.12 38.52 23.51 121.82 48.22 29-Oct-12 24 Amy 45.02 57.34 40.21 23.56 166.13 53.25 19-Mar-11 25 Conor 13.00 33.59 48.20 10.40 105.19 60.11 7-Nov-88 26 Aedric 40.24 22.67 78.75 29.99 20-Apr-94 27 PLS 21 Average Total Sales $97.39 28 Report + + Training Required? 26.67 5.99 9.85 DO PU + 158% % NON 22 ctv A ca