subject
Mathematics, 06.04.2021 01:00 hannah2718

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.

ansver
Answers: 2

Another question on Mathematics

question
Mathematics, 21.06.2019 21:30
Nine people are going to share a 128-ounces bottle of soda. how many ounces will each person get drink? choose the correct equation and answer for this situation
Answers: 1
question
Mathematics, 21.06.2019 22:00
Luke wants to reduce the area of his rectangular garden by 1/4 the expression 14/w can be used to represent this change. what is another way to write this expression?
Answers: 1
question
Mathematics, 21.06.2019 23:20
Interpret the following expression (5y^2-7)^3/(2y)^2
Answers: 2
question
Mathematics, 22.06.2019 00:00
Apassenger train and a freight train leave san jose at 3pm, traveling in the same direction. the passenger train is going three times as fast as the freight train. at 6pm they are 240 miles apart. how fast is each travelling? explain your answer and show your
Answers: 1
You know the right answer?
Each account rep is assigned to a tier, which determines whether they receive a salary bonus. Bao wa...
Questions
Questions on the website: 13722367