Click cell D$10$ on the Data sheet, and then insert a VLOOKUP function that looks up the tour code $($Col$.$ C$),$ using table tours as the

Table$\_$array, and returns the tour description.

Same as step a$,$ Click cell E$10,$ and using VLOOKUP function to get the departure date.

Same as step a$,$ Click cell F$10,$ and using VLOOKUP function to get the base cost of the trip.

Click cell G$10,$ and then insert a formula that adds taxes and fees to the base cost of the trip $($in cell F$10)$ by using the percentage value

in the Input area, cell H$4.$ Use an absolute cell reference when you need.

Click cell H$10,$ and then insert the PMT function to calculate the payments for students who want to pay for their trips in three $(3)$

installments. Use the interest rate and months in the input area. Use appropriate relative, mixed, and$/$or absolute cell references in the

formula.

Hide the Tour Code column.

Final Page Setup & Project Submission