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
The Evaluations table in the range E:I ranks the six most popular courses and notes the average evaluation scores that the four fulltime instructors received. Justin has created an area in the range E:F 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 E begin to enter a formula using the HLOOKUP function.
b Use the instructor name in cell E 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
