Excel Chapter 3

Step

Instructions

Points Possible

1

Start Excel. Download and open the file named exploring_e03_grader_h2.xlsx.

0

2

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

8

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

4

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

4

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

6

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

3

7

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

3

8

Apply a Solid line Blue border around the legend.

3

9

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

5

10

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

6

11

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

3

12

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

5

13

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

5

14

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

3

15

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

3

16

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

3

17

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

10

18

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

8

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

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

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

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

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

24

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

0

Total Points

100