00a1Trips_LastFirst (solution) Homework | Page 2

Open ​exploring _ ecap _ grader _ h1 _ Trips. xlsx and save the workbook as ​00a1Trips _ LastFirst​.
Make sure the Lookup Tables sheet is active.
2 Assign the range name ​rates ​to the base price and
2.000 commission range.
Assign the name range ​tours ​to the data for the package, tour description, departure, and base cost.
3 Click cell D13 on the Data sheet 4.000
Insert a VLOOKUP function that looks up the ​tour code, compares it to the ​tours table, and returns the description.
Copy the function down through cell D22.
4 Click cell E13 4.000