EXP ECH12 H3 - Jackson Municipal Airport 1.2
Hulett Enterprises is located in Jackson, Mississippi. In the past, you have created Web queries to find departure and arrival information for your supervisors, Denise Petrillo and Omar Vincent. Because of your Excel experience, other managers are interested in having you develop a workbook with this information they can use. You decide to create macros to update the Web queries, adjust formatting of the imported data, and then print the worksheets. Finally, you will assign the macros to macro buttons.
For the purpose of grading the project you are required to perform the following tasks:
Start Excel. Open exploring_e12_grader_h3_Airport.xlsx and save the workbook asexploring_e12_grader_h3_Airport_LastFirst.
On the Arrivals worksheet, create a Web query in cell A8 to the arrival schedule table athttp://www.pearsonhighered.com/exploring/chapter12data.
On the Departures worksheet, create a Web query in cell A8 to the departure schedule table athttp://www.pearsonhighered.com/exploring/chapter12data.
Apply conditional formatting to the Status column (the range D8:D24) to highlight Delayed flights with Light Red Fill with Dark Red Text formatting on both worksheets.
Display the Arrivals worksheet and record a macro namedUpdate to do the following:* Refresh all Web queries* Bold the column labels on row 8* Set cell A1 as the active cellOpen the VB window, copy the code for the macro, and paste it beginning in cell A1 of the Code worksheet.
Create a button on the Arrivals and Departures worksheets in the range A4:C6 that is assigned to the Update macro and displays Refresh the List on the button.
Click Refresh the List on the Departure worksheet to ensure that it works.
Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on each worksheet.
Save the file as an Excel Workbook, not macro-enabled. Ensure that the following worksheets are present (in this order): Arrivals, Departures, Code. Close the workbook, and then submit the file as directed.