Could someone please provide the formulas I enter here? Im so confused on how to do all instructions under 2. insert functions and formulas at DATA worksheet

Please tell me exactly what to do for all instructions on question 2

v e w) Design Layout References Mailings Review Lab Two Instructions a Share raw Chart and Lookup Table wborsheets Dowaload and Open the Excel file Lab Two of BUS 340, brie able, and Data) and then save the workbook as (your true) your LastnameFirstmame Lab2 fly view the 3 worksheets (Chart, Lookup lete the Task 1, Column chart and the Task 2, pie chart at the Chart worksheet by instructions on the page. Click the Loopun Table worksheet, Assign the range name tours t leparture, and base cost (Cell B1 :E9) by "Define Name menu. the data for the packages,tour description, 2. Insert Functions and Formulas at DATA worksheet a. Click cell D10 on the Data sheet, and then insert a VLOOKUP function that looks up the tour code (Col. C) using table tours as the Table aax, and returns the tour description. b. Same as step a, Click cell E10, and using VLOOKUP function to get the departure date c. Same as step a, Click cell F10, and using VLOOKUP function to get the base cost of the trip. d. Click cell G10, and then insert a formula that adds taxes and fees to the base cost of the trip (in cell F10) by using the percentage value in the Input area, cell H4. Use an absolute cell reference when you need. e. Click eell H10, 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. f. Hide the Tour Code column. 3. Final Page Setup & Project Submission a. Insert a footer for each worksheet with your full name on the left side, the file name in the center, and the Date on the right side. b. Submit your Lab Two Excel file, LastnameFirstname Lab 2, at "Submit Project Here" of Blackboard before the 11:59 PM Pacific Time of the due date. 329 words up. English (United States) Focus Package Tour Description Departure Base Cost 10 Adventures in Canada 20 Check Out the Czech Republic! 30 Croatian Wonders 40 Hong Kong, China 60 Live it Up London 70 Parisian Pleasures 80 Roaming Rome 90 Viva Espaa 6/11/19 $1,699.00 6/4/19 $1,799.00 6/11/19 $1,899.00 6/18/19 $1,949.00 6/18/19$%1,699.00 6/25/19 $1,749.00 6/4/19 $1,849.00 6/25/17|-$1,799.00 7 10 12 13 14 15 16 17 18