Click cell F13 and insert a lookup function that looks up the tour code

# Click cell f13 and insert a lookup function that

• Homework Help
• 3

This preview shows page 1 - 2 out of 3 pages.

Click cell F13 and insert a lookup function that looks up the tour code, compares it to the tours table, and returns the base cost of the trip. Copy the function down through cell F22.4.0006In cell G13, insert a formula that adds taxes and fees to the base cost of the trip (incell F13) by using the percentage value in the input area. Use a mixed reference tothe cell containing 20% in the input area above the data. Copy the formula down through cell G22.4.0007In cell H13, insert a PMT function to calculate the payments for students who want to pay for their trips in three installments. Use the interest rate and months in the input area above the data. Use appropriate relative, mixed, and/or absolute cell references in the formula. Make sure the result is a positive value. Copy the function down through cell H22.4.0008Click cell I13 and calculate the agent commission using the base cost of the trip and a VLOOKUP function that returns the commission rate based on the base cost of the trip using the rates lookup table. The function should then calculate the monetary value of the commission. Copy the function down through cell I22.4.000Merge and center the main title on the first row over all data columns on the Data sheet. Apply bold and 18 pt font size. Merge and center the subtitle on the second row over all data columns. 9