Excel - Ch.3

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.

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 comparisons among individual items or values at a specific period of time?

Bar chart

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 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 chart elements provides a vertical background for a 3D chart?

Chart Wall

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.

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

FALSE

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

False;

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

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

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.

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.

There are two sparkline types: pie and area?

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

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

GRIDLINE

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.

Which of the following lets you select a chart element?

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

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

Plot area

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

Sparklines

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

Stock Chart

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

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

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

TRUE

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

TRUE

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

TRUE

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

TRUE

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

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

TRUE

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

TRUE

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

TRUE

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 is a small line or marker on an axis to guide in reading values?

Tick mark

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.

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

True

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 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.

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

XY

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.

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.

What can pie charts graph?

a single data series

A combination chart includes?

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

What do trendlines demonstrate?

averages

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.

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.

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 shapes can you use to highlight important parts of a chart?

circle

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.

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.

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 terms refers to a group of data points or values?

data series

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

data table

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

filter

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

gradient

A chart object

is a selectable item or element in a worksheet

A chart

is a visual representation of worksheet data

A chart sheet

is an Excel chart on its own tab in the workbook

What is the thickness of an outline measured in?

points

Source data

the cells with values and labels used to build a chart

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

trendline