Question: 1 9 . The Evaluations table in the range E 3 :I 9 ranks the six most popular courses and notes the average evaluation scores

19. The Evaluations table in the range E3:I9 ranks the six most popular courses and notes the average evaluation scores that the four full-time instructors received. Justin has created an area in the range E11:F14 for looking up data in the Evaluations table.
Look up the average evaluation score earned by instructor Egan for the Emergency Care course:
a. In cell E14, begin to enter a formula using the HLOOKUP function.
b. Use the instructor name in cell E12 as the value to look up.
c. Use a structured reference to the entire Evaluations table as the table to search.
d. Display the value in row 2 of the table.
e. Specify an exact match (FALSE) for the range lookup.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!