File Home Insert Draw Page Layout Formulas Data Review View Help P Comments A Shar Franklin Gothic Bo 11 A A Insert ()- General Cunditional Furrmat as Cel DX Delete Sart 8 Find & Analyzn Paste BIU - $...

Extracted text: File Home Insert Draw Page Layout Formulas Data Review View Help P Comments A Shar Franklin Gothic Bo 11 A A Insert ()- General Cunditional Furrmat as Cel DX Delete Sart 8 Find & Analyzn Paste BIU - $ - % 9 3 8 Formatting Table Styles H Format Filter Select Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis E14 V: XV fx A В C D E G K L TTT 2 Classroom Locations Evaluations: Average Scores 3 Location Capacity Equipment? Instructor Barca - Egan - Gomez- Tham - Emergency Care Cardio Symposium 4 Clarke 204 12 Y 95 98 90 89 5 Baldwin 100 15 N 90 92 88 93 6 Baldwin 121 30 Y Bedside Best 99 87 95 88 Hart 220 12 Ethics for RNs 89 90 87 95 8 Hart 252 Holistic Nursing 15 Y 88 93 85 95 9 Sheldon 102 IV Therapy 12 Y 92 93 89 91 10 11 Online Course - Credits - Certification? Course Instructor 12 Preventing Falls 1 N Egan Emergency Care 13 Diabetes Care 1 Y 1 Y Score Rank 14 Allergies 15 16 17 18 19 20 21 22 23 24 25 26 ... Training Continuing Education All Courses Course Details Edit


Extracted text: 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 HLOOKUP function. а. b. Use the instructor name in cell E12 as the value to look up. С. Use a structured reference to the entire Evaluations table as the table to search. d. Display the value in row 2 of the table. е. Specify an exact match (FALSE) for the range lookup. 20. Find the rank in popularity of a course listed in the Evaluations table as follows: In cell F14, begin to enter a formula using the MATCH function. а. b. Use the course name in cell F12 as the value to look up. С. Use a structured reference to the Instructor column in the Evaluations table (range E4:E9) as the column to search. d. Specify an exact match (0) for the match type.