Excel - Ch.3

A chart

A chart object

A chart sheet

Source data

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

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

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

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

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

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

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

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

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

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

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

What can pie charts graph?

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.

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.

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

Which of the following charts displays 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?

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

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

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

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

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

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

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

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

Which of the following chart types displays the frequency of mutiple 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?

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

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

Which of the following 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?

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

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?

A combination chart includes?

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

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.

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

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

Which of the following lets you select a chart element?

What is the thickness of an outline measured in?

What do trendlines demonstrate?

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

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

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

Which of the following encompasses all of the other items?

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

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

There are two sparkline types: pie and area?

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

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

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.

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

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

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

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.

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