Online College Courses for Credit

+
EX16_XL_CH03_GRADER_ML1_HW - Airport Passenger Counts 1.3 (ANSWER KEY SOLUTIONS)

EX16_XL_CH03_GRADER_ML1_HW - Airport Passenger Counts 1.3 (ANSWER KEY SOLUTIONS)

Rating:
Rating
(0)
Author: l marshall
Description:

http://student.land/ex16_xl_ch03_grader_ml1_hw-airport-passenger-counts-1-3-answer-key-solutions/

EX16_XL_CH03_GRADER_ML1_HW - Airport Passenger Counts 1.3 (ANSWER KEY SOLUTIONS)

EX16_XL_CH03_GRADER_ML1_HW - Airport Passenger Counts 1.3
 
Project Description:
As an analyst for the airline industry, you track the number of passengers at the top five major U.S. airports. One worksheet you created lists the number of total yearly passengers at the top five airports for a six-year period. To prepare for an upcoming meeting, you need to create a chart to compare the number of passengers for each airport. In addition, you want to insert sparklines to visually represent trends in passengers at each airport.
 
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step

Instructions

Points Possible

1

Start Excel. Download and open the file namedexploring_e03_grader_h2.xlsx.

0.000

2

Select the range A4:G9 and create a clustered column chart.

8.000

3

Position the clustered column chart so that the upper-left corner is within cell A15 and the lower-right corner is within cell G34.

4.000

4

Swap the data on the category axis and in the legend.

4.000

5

Apply the Style 6 chart style. Select Color 12 in the Change Colors gallery. Note, the color name may be listed as Monochromatic Palette 8, depending on the version of Office being used.

6.000

6

Apply the Light Gradient – Accent 1 preset gradient fill to the chart area.

3.000

7

Change the fill color of the 2013 data series to Dark Blue.

3.000

8

Apply a Solid line Blue border around the legend.

3.000

9

Type Passengers by Top U.S. Airports as the chart title and change the font color to Blue.

5.000

10

Select the value axis, change the display units to Millions, and edit the axis title text to display MILLIONS OF PASSENGERS.

6.000

11

Display data labels above the columns for the 2013 data series only.

3.000

12

Select the ranges A5:A9 and G5:G9 and create a clustered bar chart.

5.000

13

Move the clustered bar chart to a chart sheet named Bar Chart.

5.000

14

Edit the clustered bar chart title to display Passengers at Top 5 U.S. Airports in 2013.

3.000

15

Apply the Style 3 chart style to the clustered bar chart.

3.000

16

Format the Atlanta data point with Dark Blue fill color in the clustered bar chart.

3.000

17

Display the Passenger worksheet, and insert Line sparklines in the range H5:H9 to illustrate the data in the range B5:G9.

10.000

18

Show the High Point and the Low Point in each sparkline.

8.000

19

Apply Black, Text 1 color to the high point marker in each sparkline, and apply Dark Red color the low point marker in each sparkline.

6.000

20

Answer the first question below the worksheet data. Change the fill color of the cell containing the correct answer (either cell B40 or B41) to Yellow.

3.000

21

Answer the second question below the worksheet data. Change the fill color of two cells containing the correct answer (cell B45, B46, B47, B48, B49) to Yellow.

3.000

22

Answer the third question below the worksheet data. Change the fill color of the cell containing the correct answer (either cell B53, B54, B55, B56, B57, or B58) to Yellow.

3.000

23

Answer the fourth question below the worksheet data. Change the fill color of the cell containing the correct answer (B62, B63, B64, B65, or B66) to Yellow.

3.000

24

Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0.000

Total Points

100.000

(more)
See More
Fast, Free College Credit

Developing Effective Teams

Let's Ride
*No strings attached. This college course is 100% free and is worth 1 semester credit.

37 Sophia partners guarantee credit transfer.

299 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 33 of Sophia’s online courses. Many different colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial