Exam 3: Determining Effective Data Display with Charts

To change the thickness of a pie slice, change the value of the degree in the ____________________ box in the Format Chart Area task pane.

Case 3-2 By Columns By Rows Ross always looks at data in more than one way. He discovered a feature in Excel that allows him to display the chart By Column and By Rows, as shown in the above figure. -To create the comparison shown in the above figure, Ross used the Switch Row/Column button in the ____ group.

A(n) ____ chart plots numeric values on both the x- and y-axes based on the value of the data.

____ got their name because they display performance indicators in a fashion similar to the instrument panel in a car's dashboard.

Radar charts are like area charts-but whereas area charts emphasize the amount of the contribution, radar charts emphasize ____.

One of the features of 100% stacked charts is that they show ____ percentages.

When the chart is plotted by rows, what information does it emphasize?

The column chart's default column chart sub-type is the _____ sub-type.

A management console shows a visual summary of various performance data that a company's managers use on a regular basis. _________________________

An X Y (____________________) chart plots numeric values on both the x- and y-axes based on the value of the data.

Charts can be embedded as a(n) ____ on the same worksheet as the source data for the chart.

Regresslines graphically illustrate trends in the data using a statistical technique known as regression. _________________________

To change the chart sub-type, click the Change Chart Type button in the ____ group on the CHART TOOLS DESIGN tab.

The ____ option of splitting a pie data series into a second, smaller pie chart assigns a specific number of values to the second plot.

Bar and column charts are commonly used to compare values across categories.

If Sarah wanted to focus on and display the percentage contribution that each category makes to the whole, which chart type would work best?

With the ____ sub-type, the data to be plotted must be placed by column in this order: high stock value for the day, low stock value, and, finally, closing stock value.

To change the chart sub-type, click the chart to display the CHART TOOLS contextual tabs on the ribbon, click the CHART TOOLS ___________ tab, and then click the Change Chart Type button in the Type group.

____ charts all have a stacked chart sub-type.

Case-Based Critical Thinking Questions Case 3-1 Column Chart Area Chart Sarah has put together the same information in two different charts, shown in the figure above, to present to her boss. She is thinking through the pros and cons of each chart type. -Which chart does a better job of illustrating the collective sales trend in the Equipment, Footwear, and Apparel categories over the eight years?