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.

Answers: 2

Show answers

Another question on Mathematics

Mathematics, 21.06.2019 12:30

Acable car begins its trip by moving up a hill. as it moves up, it gains elevation at a constant rate of 50 feet/minute until it reaches the peak at 2,000 feet. then, as the car moves down to the hill’s base, its elevation drops at the same rate.

Answers: 1

Answer

Mathematics, 21.06.2019 22:00

White shapes and black shapes are used in a game. some of the shapes are circles. while the rest are squares. the ratio of the number of white shapes to the number of black shapes is 5: 11. the ratio of the number of white cicrles to the number of white squares is 3: 7. the ratio of the number of black circles to the number of black squres is 3: 8. work out what fraction of all the shapes are circles.

Answers: 2

Answer

Mathematics, 21.06.2019 23:30

Astudent must have an average on five test that is greater than it equal to 80% but less than 90% to receive a final grade of b. devon's greades on the first four test were 78% 62% 91% and 80% what range if grades on the fifth test would give him a b in the course? ( assuming the highest grade is 100%)

Answers: 1

Answer

Mathematics, 22.06.2019 00:00

Ineed on this question me get the answer

Answers: 1

Answer

You know the right answer?

Each account rep is assigned to a tier, which determines whether they receive a salary bonus. Bao wa...

Questions

Mathematics, 06.03.2021 01:10

A girl cycles for 3hours at a speed of 37km/h .What distance did she cover...

Mathematics, 06.03.2021 01:10