+
Excel Project EXP ECH12 H3 - Jackson Municipal Airport 1.2

Excel Project EXP ECH12 H3 - Jackson Municipal Airport 1.2

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/excel-project-exp-ech12-h3-jackson-municipal-airport-1-2/

EXP ECH12 H3 - Jackson Municipal Airport 1.2
 
Project Description:
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.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Start Excel. Open exploring_e12_grader_h3_Airport.xlsx and save the workbook asexploring_e12_grader_h3_Airport_LastFirst.

0.000

2

On the Arrivals worksheet, create a Web query in cell A8 to the arrival schedule table athttp://www.pearsonhighered.com/exploring/chapter12data.

15.000

3

On the Departures worksheet, create a Web query in cell A8 to the departure schedule table athttp://www.pearsonhighered.com/exploring/chapter12data.

15.000

4

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.

15.000

5

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.

15.000

6

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.

15.000

7

Click Refresh the List on the Departure worksheet to ensure that it works.

15.000

8

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.

10.000

9

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.

0.000

Total Points

100.000


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial