Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started