Look up the average evaluation score earned by instructor Egan for the Emergency Care course:In cell E14, begin to enter a formula using the XLOOKUPUse the instructor name in cell E12 as the value to look up.Use a structured reference to the header row of the Evaluations table as the table to search.Return the value in the range E4:I4.I need help with the sttructured reference refered in #3 2 tions3 Equipment?4567891011 Certification?12 N13 Y14 Y15161718192021222324252627282930313233343536373839YNYNYYFunction ArgumentsXLOOKUPLookup_value E12Lookup_arrayReturn_array E4:14If_not_foundMatch_modeFormula result =InstructorEmergency CareCardio SymposiumBedside BestHelp on this functionEthics for RNsHolistic NursingIV TherapyInstructorEganScoreE4:14)个↑Evaluations: Average ScoresBarca959099898892CourseEmergency CareRank1= "Egan"= reference= {"Emergency Care",95,98,90,89}= anynumberSearches a range or an array for a match and returns the corresponding item from a second range or array. By default,an exact match is used.Return_array is the array or range to return.Egan989287909393OK?xCancelGomez908895878589Tham899388959591

Evaluations: Average scoresInstructorBarcaEganGomezThamEmergency Care95989089Cadio…

Answered: Look up the average evaluation score…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Look up the average evaluation score earned by instructor Egan for the Emergency Care course:
1. In cell E14, begin to enter a formula using the XLOOKUP
2. Use the instructor name in cell E12 as the value to look up.
3. Use a structured reference to the header row of the Evaluations table as the table to search.
4. Return the value in the range E4:I4.

I need help with the sttructured reference refered in #3

2 tions
3 Equipment?
4
5
6
7
8
9
10
11 Certification?
12 N
13 Y
14 Y
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Y
N
Y
N
Y
Y
Function Arguments
XLOOKUP
Lookup_value E12
Lookup_array
Return_array E4:14
If_not_found
Match_mode
Formula result =
Instructor
Emergency Care
Cardio Symposium
Bedside Best
Help on this function
Ethics for RNs
Holistic Nursing
IV Therapy
Instructor
Egan
Score
E4:14)
个
↑
Evaluations: Average Scores
Barca
95
90
99
89
88
92
Course
Emergency Care
Rank
1
= "Egan"
= reference
= {"Emergency Care",95,98,90,89}
= any
number
Searches a range or an array for a match and returns the corresponding item from a second range or array. By default,
an exact match is used.
Return_array is the array or range to return.
Egan
98
92
87
90
93
93
OK
?
x
Cancel
Gomez
90
88
95
87
85
89
Tham
89
93
88
95
95
91

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions