Question: Click cell D13 on the Data sheet and Insert a VLOOKUP hat looks up the tour code, 3compares It to the tours table, and retums
Click cell D13 on the Data sheet and Insert a VLOOKUP hat looks up the tour code, 3compares It to the tours table, and retums the descripton. Copy the function down through cell D22. Click cel E13 and insert a lookup function that looks up the tour code, compares t to the tours table, and returns the departure date. Copy the function down through cell E22 Click cell F13 and insert a lookup function that looks up the tour code, compares it to the tours4 table, and returns the base cost of the trip. Copy the function down through cell F22. In cell G13, insert a formula that adds taxes and fees to the base cost of the trip (in cell F13) by using the percentage value in the input area. Use a mixed refere 20% in the input area above the data. Copy the formula down through cell G22. 6 tothe cell containing | 4.000 In cell H13, insert a PMT function to calculate the payments for students who want to pay for their trips in three instaliments. Use the interest rate and months in the input area above the data. Use appropriate relative, mixed, and/or absolute cell in the formula. Make cell H22 using the base cost of the trip and a Click cell 113 and calculate the agent VLOOKUP the rates lookup table. The function should then calculate the monetary value of the commission. Copy the function down through cell 122. that returns the commission rate based on the base cost of the trip using 4.000 Merge and center the main title on the first row over all data columns on the Data sheet. 9Apply bold and 18 pt font size. Merge and center the subtitle on the second row over all 4.000 10 Apply Currency number format to the monetary values in columns F, G, H, and I. Hide the Tour Code column
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
