I attached the excel file if you can open the instructions are on it

Save your file using the following naming convention: LastName_Excel_Assignment.xlsx In this assignment you will be working with the FLIGHT_DATA data set. The data subset is for the month of January 2017, limited to the three New York city airports: Kennedy (JFK), LaGuardia (LGA) and Newark (EWR). Prepare the data: – Format the data range on the Flight_Data worksheet as a table. Give the table the same name as the worksheet. – Add the CARRIER_NAME column to the right of UNIQUE_CARRIER. Populate the column using a VLOOKUP function that references the table array on the UNIQUE_CARRIERS worksheet. – Add the DEST_AIRPORT column to the right of DEST. On the AIRPORTS worksheet, use a combination of Text-to-Columns and the TRIM function to create an Airport column that contains only airport names. Once completed, populate the DEST_AIRPORT column on Flight-Data worksheet using a VLOOKUP function that references the table array on the AIRPORTS worksheet. – Add the ACTUAL_DELAY column, to the right of the ARR_DELAY column in the FLIGHT_DATA where ACTUAL_DELAY is defined as any ARR_DELAY > 0. – Assign Range Names to the following columns in FLIGHT_DATA: FL_DATE, ORIGIN, ACTUAL_DELAY, UNIQUE_CARRIER The dashboard you’ll create is intended to help travelers make their flight decision based on published flight delay information. Submit your workbook to the Assignment 1 Dropbox on D2L. Do not delete or hide any worksheets provided in the starter file prior to submission.

Need Help Writing an Essay?

Tell us about your assignment and we will find the best writer for your paper.

Write My Essay For Me

“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”