$1.$ Creating Named Ranges will make it easier to refer to tables of data when using LOOKUP functions to retrieve information.

$2.$ On the MovieTables worksheet, assign a MovieTitles named range to the range A$2$:B$37$ and assign a MovieRatings named range to the range D$2$:E$37.$

Tables are an easy way to format a data set and explore using the built in filters.

$3.$ On the Movies worksheet, create a table with headers using the range A$5$:K$32$ and apply the Light Blue, Table Style Medium $23.$

Use the Create from Selection named range tool to create a named range for each column, using the Top row of the table for the names.