Exam 3: Determining Effective Data Display with Charts

Charts can be either embedded as an object on the same worksheet as the data, or placed on a separate worksheet referred to as a(n) ____________________.

Microsoft Excel ____ provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

Excel provides 10 standard chart types, with 53 sub-types that can be used to present information graphically. _________________________

Bubble charts can be problematic to work with since the source data must be selected without including ____.

Name and briefly describe five of the eleven chart types listed in the chapter.

One available chart option is to create a 100% ____________________ chart, in which the plotted values are converted into percentages of the total amount within each category.

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. -Looking at the column chart, which category/categories is/are decreasing in sales each year?

In a worksheet, the MAX and MIN functions can be used to take care of the highest and lowest stock price, respectively, for each month. _________________________

____ are the related data points that are plotted on the chart.

A data series is composed of related data points that are plotted on a chart.

In a ____ chart, values are indicated by the size of the slices.

Identify the letter of the choice that best matches the phrase or definition. -Line chart type

Excel offers many formatting and display options for changing the layout of chart elements that can be found on the ____ when a chart is selected.

The Data Labels category found on the Chart Elements menu provides options for changing the information the label displays as well as the label position. _________________________

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

The ____________________ chart type displays stock price and volume trends over time. Plotted values can include volume, opening price, highest price, lowest price, and closing price.

The Chart Elements menu allows you to control the appearance of the ____.

The sum of the value of the categories must total ____ to use a pie chart.

____ identify the data values plotted on the y-axis.

Briefly describe the eight common areas of a chart: chart title, y-axis, y-axis labels, x-axis, x-axis labels, data series, data points, and legend.