Which of the following chart elements is used to identify data series by color patterns?

The title is a text box you can place anywhere on the chart.

The plot is the area on the chart that displays the data in the chart type you choose.

A data point is one piece of data appearing on the chart. For most chart types, each data point shows the value of the contents of one cell in the data range linked to the chart.

A chart's legend shows what kind of data is represented in the chart. By default, the text that appears in the legend is taken from the chart's data range.

Series are sets of related data. A chart can have one or more series. Each chart type displays series differently. Often (but not always), series correspond to rows of data in the data range.

Categories are "bins" into which the data from each series is sorted. Often (but not always), categories correspond to columns of data in the data range.

For information on series and categories, see Headings in the Data Range and How Each Chart Type Displays Series and Categories.

The Y axis is vertical on most charts (except for bar charts, where the Y axis is horizontal). Because it displays values, the Y axis is also called the value axis. On XY and bubble charts, both the X and Y axes are value axes.

The X axis is horizontal on most charts (except for bar charts, where the X axis is vertical). On most charts, the X axis is called the category axis because it displays category names.

Axis labels are words or numbers that mark the different portions of the axis. Value axis labels are computed based on the data displayed in the chart. Category axis labels are taken from the category headings entered in the chart's data range.

Axis titles are words or phrases that describe the entire axis.

Markers identify data points. You can put markers on all data points in a series or on only selected data points.

Grid lines are horizontal or vertical lines that extend from the axis ticks.

Drop lines are lines leading from a data point to the category axis. On large or complex charts, drop lines help show which category a data point belongs to. Drop lines are only available on line chart types.

Data labels identify individual data points. Data labels are a good way to emphasize or explain a particular piece of data on the chart. Data labels can display the data point's category, its value, or text you enter yourself.

Ticks are short lines that mark off an axis into segments of equal size. On value axes, axis labels are displayed on ticks. On category axes, axis labels are displayed between ticks.

Label lines are lines leading from a data point to its data label.

High-low lines are used on stock charts to show the range of prices the stock commanded over a period of time. High-low lines are available only on line chart types.

Open-close bars are used on stock charts to show the stock's price at market opening and closing. You can color the bars differently to show whether the stock gained or lost.

Studies are sub-charts that display below the main chart in the same plot area. Studies share the same X axis and usually show similar data on a different scale. Stock charts frequently display studies that show the volume of stocks traded. You can display one or more studies on any chart that has axes.

A chart

is a visual representation of worksheet data

A chart object

is a selectable item or element in a worksheet

A chart sheet

is an Excel chart on its own tab in the workbook

Source data

the cells with values and labels used to build a chart

Which of the following is a requirement or condition that identifies which data is shown and which is hidden?

filter

A tick mark is a small line or marker on an axis to guide in reading values.

TRUE

Which of the following is a horizontal or vertical line that extends across the plot area to help in identifying values?

GRIDLINE

In a pie chart, a data series is a slice of a pie, T/F?

False; In a pie chart, a data point is a slice of a pie.

Which of the following displays averages in your data and can be used to forecast data?

trendline

Once you have selected the appropriate data, which of the following keyboard shortcuts creates a default chart object?

Alt+F1

Which of the following chart types displays the distribution of data with minimum, mean, maximum, and outlier values?

Box and Whisker

Which of the following is a rectangular area bounded by the horizontal and vertical axes?

Plot area

Clicking a chart element opens its Format pane, T/F?

False; Double-clicking a chart element opens its Format pane.

Which of the following is a small line or marker on an axis to guide in reading values?

Tick mark

The Funnel chart type plots each element in a running total and displays negative and positive effects of each on the total, T/F?

False; The Funnel chart plots values that progressively decrease from one stage or process to the next.

What can pie charts graph?

a single data series

Which of the following statements is not True?

a. In a combination chart, you can display two sets of values, two vertical axes.

b. You can create a combination chart from the Home tab.

c. The axis on the left is the primary axis; the one on the right is secondary.

d. Some chart types cannot be combined.

b. You can create a combination chart from the Home tab.

**You can create a combination chart from the Charts group on the Insert tab.

Which of the following is not a True statement?

a. The outline for a shape is the border that surrounds or encircles it.

b. Not all chart elements are suited to an outline.

c. Elements such as the chart or plot area do not usually benefit from the use of an outline.

d. When you add an outline to a chart element, you can select a weight for the line.

C. Elements such as the chart or plot area do not usually benefit from the use of an outline.

Elements such as the chart or plot area often benefit from the use of an outline.

Which of the following can you apply after you select a chart element?

a. fill color
b. outline width
c. special effect
d. all of the above

d. all of the above

Which of the following charts displays relationships among numeric values in two or more data series?

XY charts display relationships among numeric values in two or more data series.

The Chart Tools Design tab includes commands for selecting a chart layout, choosing a chart style, and changing the color scheme, T/F?

True

Which of the following chart elements provides a vertical background for a 3D chart?

Chart Wall

A chart object is a selectable item surrounded by a square border that is separate from worksheet data, T/F?

TRUE

Elements such as the chart or plot area rarely benefit from the use of an outline, True/False?

False;

Which of the following could you add to a chart to predict future values?

You can add a trendline to a chart to help predict future values.

Which of the following chart types displays comparisons among individual items or values at a specific period of time?

Bar chart

Data tables are located just below a chart, T/F?

True

Exploding a pie slice emphasizes that slice, because it moves the slice away from the rest of the pie, T/F?

TRUE

Which of the following enables you to begin editing a chart title?

To edit the chart title, triple-click the Chart Title placeholder, type the title, and click the chart background to deselect the element.

Which of the following chart types displays the frequency of mutiple data series relative to a center point?

The Radar chart type displays the frequency of multiple data series relative to a center point.

Which of the following chart types displays a hierarchical view of data with different sized and colored rectangles and sub-rectangles to compare the sizes of groups?

The TreeMap chart type displays a hierarchical view of data with different sized and colored rectangles and sub-rectangles to compare the sizes of groups.

Which of the following chart types illustrates data changes over a period of time or shows comparisons among items?

Column charts illustrate data changes over a period of time or show comparisons among items.

The cells used to build a chart are its source data, T/F?

TRUE

Which of the following is a text box with a preset font style, fill, and text effect?

WordArt is a text box with a preset font style, fill, and text effect.

The Chart Tools Design tab includes commands for selecting a chart layout, choosing a chart style, and changing the color scheme, T/F?

TRUE

Which of the following terms refers to a group of data points or values?

data series

If the cell range you want to use in a chart contains non-adjacent cells, hold down the Alt key to select each range, T/F?

If the cell range you want to use in a chart contains non-adjacent cells, hold down the Ctrl key to select each range.

A combination chart includes?

at least two chart types such as a line chart and a column chart

Which of the following charts displays relationships among numeric values in two or more data series?

XY

Which of the following is not a True statement?

a. Exploding a pie slice emphasizes that slice.

b. Exploding a pie slice moves the slice away from the rest of the pie.

c. You set explosion as a percentage.

d. Pie charts do not have Quick Layouts and Quick Styles.

d. Pie charts do not have Quick Layouts and Quick Styles.

A marker for a sparkline is the data point value, T/F?

TRUE

Which of the following charts displays three series of data to show fluctuations in stock prices from high to low to close?

Stock Chart

Which of the following lets you select a chart element?

None of the above; To select a chart element, simply click on it.

What is the thickness of an outline measured in?

points

What do trendlines demonstrate?

averages

Which of the following shapes can you use to highlight important parts of a chart?

circle

Which of the following are miniature charts displayed in a cell or cell range with your data?

Sparklines

Which of the following is another word for a variegated blend of color?

gradient

Which of the following encompasses all of the other items?

A shape style is a predesigned set of borders, fill colors, and effects for a chart element.

You can easily create a default chart object by selecting the appropriate data and pressing F1.

FALSE

It is possible to replace a chart title box with WordArt.?

T; It is possible to replace a chart title box with WordArt.

There are two sparkline types: pie and area?

False; There are three sparkline types: Line, Column, and Win/Loss.

In a chart, which of the following can you fill with pictures?

bars, Columns, pie slices

Which of the following terms refers to the text label that describes each data series?

category label

Which of the following statements is not True?

a. it is possible to change chart type.

b. It is possible to change some bar charts into column charts, but not all.

c. It is possible to change a 3-D pie chart into a 2-D pie chart.

d. Excel 3-D charts add the perception of depth to a chart.

b. It is possible to change some bar charts into column charts, but not all.

**It is possible to change bar charts into column charts.

What would you call a table added to the bottom of your chart that contains the values of each data series?

data table

Each group of data points or values used in a graph is a data series, T/F?

TRUE

Each group of data points or values used in a graph is a data series.

TRUE

Which of the following is True about data tables?

a. By default, Excel adds a data table to the right side of column and bar charts.

b. By default, Excel adds a data table to the bottom of line charts.

c. By default, Excel adds a data table to the right of all charts.

d. By default, Excel does not include data tables with charts.

d. By default, Excel does not include data tables with charts.

A chart object is a selectable item surrounded by a square border that is separate from worksheet data.

TRUE

Which of the following chart element is used to identify data series by its color patterns chart title legend marker data labels?

What element of chart identifies which data series color on the chart represents?

Which of the following data element is used to show the data series by its color patterns?

What is used to identify the data series on the chart?