Step

Instructions

Points Possible

1

Start Excel. Download and open the file named e03_grader_h1.xlsx.Rename the file asLastNameFirst_Assignment6__ AirlineAnalysis.xlsx

0

2

Insert Line sparklines in the range G4:G7, using the data for the five years in the range B4:F7. Hint: -Insert sparklines in range G4:G7-Use data for five years in range B4:F7-Sparkline use correct data-Correct results from Sparklines

10

3

Display the high and low points for the Sparklines.Hint: -High points for Sparkline displayed-Low point for Sparkline displayed

4

4

For the range containing Sparklines, change the high point marker color to Green (under Standard Colors).Hint: -Sparklines high point marker color changed to Green-This is applied to range containing Sparklines

4

5

Select the range A4:A7 and the range F4:F7. Create a pie chart and move it to a chart sheet named Pie Chart.Hint: -Range A4:A7 selected and used-Range F4:F7 selected and used-Pie chart created from selected range-Pie chart moved to a chart sheet- created on a new sheet-Chart sheet name Pie Chart-Chart created correctly as expected

10

6

Type 2014 Flight Arrivals as the chart title. Hint: -Chart has a title-Chart title is 2014 Flight Arrivals with no spelling errors

3

7

Apply the Style 12 chart style. Format the chart title with Blue font color (under Standard Colors).Hint: -Style 12 chart style applied correctly to chart-Chart title formatted with Blue font

6

8

Change the Legend Position to Top to position the legend between the chart title and the plot area.Hint: -Legend position to Top -Legend positioned between the chart title and the plot area

4

9

Add data labels to the Best Fit position. Hint: -Data labels added-Data labels added to Best Fit position

4

10

Apply 12-pt size and bold the data labels.Hint: -12-pt size applied to data labels-Bold applied to data labels

4

11

Format the Canceled data point with Dark Red fill color. Format the Late Arrival data point in Green. Explode the Late Arrival data point by 5%.Hint: -Canceled data point formatted with Dark Red fill color-Late Arrival data point formatted in Green-Late Arrival data point exploded by 5%

5

12

Select the range A10:F15 in the Arrivals worksheet and create a clustered column chart. Hint: -Arrivals worksheet used-Range A10:F15 selected-Clustered column chart created with selected range-Clustered chart created correctly

10

13

Type On-Time and Late Flight Arrivals for the chart title.Hint: -Chart has a title-Chart title is On-Time and Late Flight Arrivals with no spelling errors

3

14

Position the clustered column chart so that the top-left corner is in cell A20. Change the chart width to 5.75 inches and the height to 3.5 inches.Hint: -Make sure Excel units are in inches-Top-left corner of clustered chart is in cell A20-Chart width changed to 5.75 inches-Chart height changed to 3.5 inches

6

15

Apply chart filters to remove the canceled, diverted, and total operations data.Hint: -Chart filters applied to remove-Canceled data-Diverted data-Total operations data

6

16

Select the value axis, set 500000 for the Major unit, display the axis units in Millions, select category Number format with 1 decimal place.Hint: -Value axis selected -Major unit set to 500000-Displays axis units in millions-Category Number format with 1 decimal place selected

8

17

Add a primary vertical axis title Number of Flights.Hint: -Primary vertical axis added-Primary vertical axis titled Number of Flights with no spelling errors

5

18

Apply the Color 2 chart color to the chart.Note, depending on the version of Office used, the color name may be Colorful Palette 2.Hint: -Color applied to chart-Color 2 chart color applied to chart

4

19

Apply the Light Gradient – Accent 3 fill to the chart area.Hint: -Applied Gradient to chart area -Light Gradient – Accent 3 fill applied to chart area

4

20

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

0

Total Points

100