Each account rep is assigned to a tier, which determines whether they receive a salary bonus. Bao wants to list the tier for each account rep according to the Bonus Tiers data in the range K5:L9. In cell H11, enter a formula using the VLOOKUP function. Use a structured reference to the Eval Score (cell G11) as the lookup value. Use absolute cell references to the Bonus Tiers data (range K6:L9) as the table_array. Use the Tier column (column 2) as the col_index_num. Accept the default of an approximate match because the scores listed represent ranges of values rather than exact values. If Excel does not copy the formula automatically, fill the range H12:H29 with the formula in cell H11.