Can I please have help in properly generating these two functions in my excel worksheet

E14 X fx =HLOOKUP(E12, Evaluations,2,FALSE) A B C D E F G H I Course Details N Instructor Emergency Care Cardio Symposium Bedside Best Ethics for RNS Holistic Nursing IV Therapy Evaluations: Average Scores Barca - Egan Gome ! 95 98 90 90 92 88 99 87 95 89 90 87 88 93 85 92 93 89 Tham 89 93 88 95 95 91 N Y Look up the average evaluation score earned by instructor Egan for the Emergency Care Georgia Medical Center course: 1 2 Classroom Locations a. In cell E14, begin to enter a formula using the HLOOKUP function. 3 Location Capacity Equipment? 4 Clarke 204 12 Y b. Use the instructor name in cell E12 as the value to look up. 5 Baldwin 100 15 N C. Use a structured reference to the entire Evaluations table as the table to search. 6 Baldwin 121 6 30 Y 7 Hart 220 12 d. Display the value in row 2 of the table. 8 Hart 252 15 9 Sheldon 102 12 Y e. Specify an exact match (FALSE) for the range lookup. 10 11 Online Courses Credits - Certification? Find the rank in popularity of a course listed in the Evaluations table as follows: 12 Preventing Falls 1 N a. In cell F14, begin to enter a formula using the MATCH function. 13 Diabetes Care 14 Allergies 1 b. Use the course name in cell F12 as the value to look up. 15 16 c. Use a structured reference to the Instructor column in the Evaluations table 17 (range E4:E9) as the column to search 18 d. Specify an exact match (0) for the match type. 19 20 erkbook should look like the Final Figures on the following pages. Save your changes, 21 e workbook, and then exit Excel. Follow the directions on the SAM website to submit your 22 23 ced project. 24 Instructor Egan Score #N/A Course Emergency Care Rank 1 Y Y 25 26 E14 X fx =HLOOKUP(E12, Evaluations,2,FALSE) A B C D E F G H I Course Details N Instructor Emergency Care Cardio Symposium Bedside Best Ethics for RNS Holistic Nursing IV Therapy Evaluations: Average Scores Barca - Egan Gome ! 95 98 90 90 92 88 99 87 95 89 90 87 88 93 85 92 93 89 Tham 89 93 88 95 95 91 N Y Look up the average evaluation score earned by instructor Egan for the Emergency Care Georgia Medical Center course: 1 2 Classroom Locations a. In cell E14, begin to enter a formula using the HLOOKUP function. 3 Location Capacity Equipment? 4 Clarke 204 12 Y b. Use the instructor name in cell E12 as the value to look up. 5 Baldwin 100 15 N C. Use a structured reference to the entire Evaluations table as the table to search. 6 Baldwin 121 6 30 Y 7 Hart 220 12 d. Display the value in row 2 of the table. 8 Hart 252 15 9 Sheldon 102 12 Y e. Specify an exact match (FALSE) for the range lookup. 10 11 Online Courses Credits - Certification? Find the rank in popularity of a course listed in the Evaluations table as follows: 12 Preventing Falls 1 N a. In cell F14, begin to enter a formula using the MATCH function. 13 Diabetes Care 14 Allergies 1 b. Use the course name in cell F12 as the value to look up. 15 16 c. Use a structured reference to the Instructor column in the Evaluations table 17 (range E4:E9) as the column to search 18 d. Specify an exact match (0) for the match type. 19 20 erkbook should look like the Final Figures on the following pages. Save your changes, 21 e workbook, and then exit Excel. Follow the directions on the SAM website to submit your 22 23 ced project. 24 Instructor Egan Score #N/A Course Emergency Care Rank 1 Y Y 25 26