in cell E$14,$ begin to enter a formula using the HLOOKUP function.Use the instructor name in cell E$12$ 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$\mathrm{.}20.$ Find the rank in popularity of a course listed in the Evaluations table as follows:a$.$In cell F$14,$ begin to enter a formula using the MATCH function.b$.$Use the course name in cell F$12$ as the value to look up$.$Use a structured reference to the Instructor column in the Evaluations table $($range E$4$:$9)$ as the column to search.d$.$Specify an exact match $(0)$ for the match type.