Whisenhunt Enterprises Notes

  • Whisenhunt Enterprises is located in a metropolitan area. Denis Petrillo and Omar Vincent travel frequently for business. To help plan for flight delays, you will create

    http://assignment.store/whisenhunt-enterprises-is-located-in-a-metropolitan-area-denis-petrillo-and-omar-vincent-travel-frequently-for-business-to-help-plan-for-flight-delays-you-will-create/\n\nProject Description:\n\nWhisenhunt Enterprises is located in a metropolitan area. Denis Petrillo and Omar Vincent travel frequently for business. To help plan for flight delays, you will create a workbook that provides airline data with up-to-date arrival and departure information from the Tri-State Metropolitan Airport.\n\nInstructions:\n\nFor the purpose of grading the project you are required to perform the following tasks:\n\nStep\n\nInstructions\n\nPoints Possible\n\n1\n\nStart Excel. Download the text file exploring\\_e10\\_grader\\_h1.txt, the XML file exploring\\_e10\\_grader\\_h1.xml, and the Excel file exploring\\_e10\\_grader\\_h1.xlsx. Open the workbook.\n\n0\n\n2\n\nIn the Airlines Codes sheet, click cell A2 and create a link to the tab-delimited text file you downloaded. Select the option that the text file has headers. Accept all other defaults.\n\n10\n\n3\n\nOpen Notepad, edit the e10\\_grader\\_h1.txt tab-delimited file. At the end of the last line, press ENTER, type Unified, press TAB, type UNA. Save and close the text file. In Excel, refresh the connection to the text file.\n\n5\n\n4\n\nIn the Departures sheet, in cell A1, create a Web query to the departures table on this Web page: http://media.pearsoncmg.com/ph/bp/bp\\_myitlab/departure\\_schedule\\_files/departure\\_schedule.htm. Maintain full HTML formatting before importing the table.\n\n10\n\n5\n\nIn the Filtered List sheet, create a table with headers using the range A1:E29.\n\n5\n\n6\n\nIn the Filtered List sheet, click cell A2. Insert a VLOOKUP function to lookup the airline in the Departures sheet, compare it to the airline table in the Airline Codes sheet, and return the code for that airline. For example, Unified will display as UNA. (The function should copy to the range A3:A29 automatically.)\n\n10\n\n7\n\nIn the Filtered List sheet, click cell B2. Use a text function to combine the airline code from the previous step with a space and the flight number on the respective row in the Departures sheet. (The function should copy to the range B3:B29 automatically.)\n\n10\n\n8\n\nIn the Filtered List sheet, click cell C2. Use a text function to display the cities from the Departures sheet where the first letter is capitalized but the remaining letters are lowercase, such as Houston. (The function should copy to the range C3:C29 automatically.)\n\n5\n\n9\n\nIn the Filtered List sheet, click cell D2. Enter a formula to repeat the time from the Departures sheet. Format the range D2:D29 with the Time format, such as 1:30 PM.\n\n5\n\n10\n\nIn the Filtered List sheet, click cell E2. Enter a text function that returns the status in title case, such as On Time. (The function should copy to the range E3:E29 automatically.)\n\n5\n\n11\n\nIn the Filtered List sheet, set a filter for both Houston airports with a status of On Time.\n\n10\n\n12\n\nIn cell A1 of the Airports sheet, create a connection to the exploring\\_e10\\_grader\\_h1.xml file.\n\n10\n\n13\n\nOpen exploring\\_e10\\_grader\\_h1.xml in Notepad. Copy the first Airport element and paste the copy above the original first airport element. Edit the data by typing Atlanta and ATL within the proper tags. Change the Chicago airport code to ORD. Save and close the XML file. Refresh the XML connection only."},{"left":"","right":""},{"left":"","right":""},{"left":"","right":""}]


Sign Up Free