Question

2 Select the range A4:G9 and create a clustered column chart Position the clustered column chart so that the upper-left cormer is within cell A15 and the lower-right corner is within cell G34 4 Swap the data on the category axis and in the legend 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 Apply the Light Gradient - Accent 1 preset gradient fill to the chart area. 7 Change the fill color of the 2013 data series to Solid fill Dark Blue. 7 8 Apply a Solid line Blue border around the legend. 9 Type Passengers by Top U.S. Airports as the chart title and change the font color to Blue. 10 Select the value axis, change the display units to Millions, and edit the axis title text to display 11Display data labels above the columns for the 2013 data series only. 12 Select the ranges A5:A9 and G5:G9 and create a clustered bar chart 13 Move the clustered bar chart to a chart sheet named Bar Chart 14 Edit the clustered bar chart title to display Passengers at Top 5 U.S. Airports in 2013. 15 Apply the Style 3 chart style to the clustered bar chart MILLIONS OF PASSENGERS 16 Format the Atlanta data point with Dark Blue fill color in the clustered bar chart

Answer 1

1	All the top five airports experience _____ in the number of passengers in 2010 when compared to the
	number of passengers in 2009.
		a decrease
		an increase
2	In the six year period, which two airports had their highest number of passengers in 2013?
		Atlanta
		Chicago
		Los Angeles
		Dallas- Fort Worth
		Denver
3	what year did Chicago experience highest number of passengers?
		2008
		2009
		2010
		2011
		2012
		2013
4	what year did all five airport experience a decrease compared to the previous year?
		2009
		2010
		2011
		2012
		2013