1	Start Excel. Download and open the file named e03_grader_h1.xlsx.	0
2	Insert Line sparklines in the range G4:G7, using the data for the five years in the range B4:F7.	10
3	Display the high and low points for the Sparklines.	4
4	For the range containing Sparklines, change the high point marker color to Green (under Standard Colors).	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.	10
6	Type 2014 Flight Arrivals as the chart title.	3
7	Apply the Style 12 chart style. Format the chart title with Blue font color (under Standard Colors).	6
8	Change the Legend Position to Top to position the legend between the chart title and the plot area.	4
9	Add data labels to the Best Fit position.	4
10	Apply 12-pt size and bold the 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%.	5
12	Select the range A10:F15 in the Arrivals worksheet and create a clustered column chart.	10
13	Type On-Time and Late Flight Arrivals for the chart title.	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.	6
15	Apply chart filters to remove the canceled, diverted, and 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.	8
17	Add a primary vertical axis title Number of Flights.	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.	4
19	Apply the Light Gradient Accent 3 fill to the chart area.	4
20	Close the workbook, and then exit Excel. Submit the workbook as directed.	0
	Total Points	100