chapter 9 skill test

Answer the following questions by executing the required skills on the starter file listed above. Answer each question in the order it appears. Questions that are preceded with the letters KO indicate you must only use your keyboard and not your mouse to execute the required skill.

Create a pie chart using the data in the Market Share worksheet. The pie chart should show the percent to total for only the year 2010. Use the 3-D Pie format.

Move the upper left corner of the chart to the center of cell E2.

Resize the chart so the left side is locked to the left side of column E, the right side is locked to the right side of column L, the top is locked to the top of row 2, and the bottom is locked to the bottom of row 17.

Remove the legend.

Change the chart title to the following: Market Share for the Year 2010.

Add the Category Name and Percentage data labels to the outside end of each section of the pie chart.

Bold the data labels and change the font style to Arial.

Create a 100% stacked column chart using the data in the Market Share worksheet. The X axis should show stacks for the year 2010 and 2020. There should only be two stacks, or columns, in the plot area showing the percent to total for each company.

Move the 100% stacked column chart to a separate chart sheet. The tab name for the chart sheet should read: Market Share Chart.

Remove the legend on the stacked column chart and add a data table with legend keys below the X axis.

Add a title above the chart that reads: 10 Year Change in Market Share.

Format the chart title using the Subtle Effect Red, Accent 2 preset shape style. Change the font style to Arial and the font size to 20 points.

Add a Y axis title that reads: Market Share.

Format the Y axis title using the Subtle Effect Red, Accent 2 preset shape style. Change the font style to Arial and the font size to 16 points.

Format the X and Y axes by changing the font style to Arial, bold font, and font size to 14 points.

Change the fill color of the chart area to Tan, Background 2.

Change the color of the plot area to White.

Add series lines that connect each section of the two stacks in the plot area.

Create a column chart showing just the Company Sales in the Sales Data worksheet. The chart should show the Company Sales in the range B3:B13 along the Y axis. The years in the range A3:A13 should appear on the X axis. Use the basic 2-D Clustered Column format. The series name should be Gross Sales.

Move the column chart to a separate chart sheet. The tab name for the chart sheet should read Company Sales Chart.

Format the X and Y axes by changing the font style to Arial, bold font, and font size to 14 points.

Reduce the height of the plot area by approximately 1 inch. There should be about 1 inch of space between the bottom of the Chart Title and the top of the plot area.

Add an annotation above the Y axis that reads Sales in Millions. Format the annotation with an Arial font style, bold font, italics font, and font size of 12 points.

Change the color of the bars in the plot area to dark red.

Create a line chart comparing the change in sales for the company and overall industry in the Sales Data worksheet. Construct the chart as follows:

The Y axis should show the growth percentages for the company in the range C3:C13 and the growth percentages for the industry in the range E3:E13.

The series name for the company growth percentages should be Company.

The series name for the industry growth percentages should be Industry.

The years in the range A3:A13 should appear on the X axis.

Use the Line with Markers format.

Move the chart so the upper left corner is in the center of cell G2.

Resize the chart so the left side is locked to the left side of column G, the right side is locked to the right side of column M, the top is locked to the top of row 2, and the bottom is locked to the bottom of row 18.

Adjust the scale of the Y axis so the maximum value is set to .20.

Add a legend to the bottom of the chart.

Save and close your workbook.