Question 1

A pie chart

Accepted Answer

A)   shows a relationship between two variables.
B)   separates one or more pie slices from the rest of the pie chart.
C)   emphasizes magnitude of changes over time by filling in the space between lines with a color.
D)   shows each data point in proportion to the whole data series as a slice in a circular pie.E) C) and D)
F) A) and C)

Question 2

When choosing a chart ________, make sure it complements the chart data and is easy to read.

Accepted Answer

The answer of When choosing a chart ________, make sure...

Question 3

Excel displays a ________ when you create a multiple series chart. By default it appears on the right side of the plot area.

Accepted Answer

The answer of Excel displays a ________ when you create...

Question 4

A gridline

Accepted Answer

A)   is a numeric value that describes a single value on a chart.
B)   is a line used to depict trends and forecast future data.
C)   is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.
D)   is a visual representation of numerical data.E) None of the above
F) A) and B)

Question 5

You can use trendlines in unstacked column, bar, line, stock, scatter, and bubble charts.

Accepted Answer

A) True 
 B)False

Question 6

A stacked column chart

Accepted Answer

A)   places stacks of data in segments on top of each other in one column, with each category in the data series represented by a different color.
B)   adds a third dimension to each data series, creating a distorted perspective of the data.
C)   compares values across categories using horizontal bars.
D)   places (stacks)  data in one column per category, with each column having the same height of 100%.E) None of the above
F) All of the above

Question 7

To reverse the data series, click ________ Row / Column in the Data group.

Accepted Answer

The answer of To reverse the data series, click ________...

Question 8

A sparkline is

Accepted Answer

A)   is a label that describes either the category axis or the value axis.
B)   a miniature chart contained in a single cell.
C)   is the value or name of a data point.
D)   is a label that describes the chart.E) A) and D)
F) A) and C)

Question 9

To change the data source of a chart use the Select Source dialog box from the Dialog\Numbers button.

Accepted Answer

A) True 
 B)False

Question 10

A column ________ displays data comparisons vertically in columns.

Accepted Answer

The answer of A column ________ displays data comparisons vertically...

Question 11

To change the data source of a chart

Accepted Answer

A)   change the numbers in the spread sheet.
B)   use the Select Data Source dialog box from the Select Data button.
C)   use a different chart type.
D)   click Switch Row / Column in the Data group.E) None of the above
F) A) and B)

Question 12

After creating a chart you can change the chart type by using

Accepted Answer

A)   Page Layout tab / Chart Options button.
B)   Design tab / Change Chart Type button.
C)   Data tab / Chart Changer tool.
D)   You cannot change the chart.E) A) and B)
F) A) and C)

Question 13

Charts help reveal ________, patterns, and other tendencies that are difficult to identify by just looking at values in a worksheet.

Accepted Answer

The answer of Charts help reveal ________, patterns, and other...

Question 14

The chart area

Accepted Answer

A)   contains graphical representation of values in data series.
B)   contains the entire chart and all of its elements.
C)   is a vertical line that borders the plot area to provide a frame of reference for measurement.
D)   is a horizontal line that borders the plot area to provide a frame of reference for measurement.E) B) and C)
F) All of the above

Question 15

A line chart

Accepted Answer

A)   separates one or more pie slices from the rest of the pie chart.
B)   shows each data point in proportion to the whole data series as a slice in a circular pie.
C)   emphasizes magnitude of changes over time by filling in the space between lines with a color.
D)   uses a line to connect data points in order to show trends over a period of time.E) A) and B)
F) A) and C)

Question 16

A chart sheet contains a single chart and no spreadsheet data.

Accepted Answer

A) True 
 B)False

Question 17

A sparkline is a small line, column, or win / loss chart contained in a single cell.

Accepted Answer

A) True 
 B)False

Question 18

An X Y (scatter)  chart

Accepted Answer

A)   shows values as percentages of the whole but may contain more than one data series.
B)   shows the high, low, and close prices for individual stocks over time.
C)   shows trends using two dimensions on a continuous curve.
D)   shows a relationship between two variables.E) B) and C)
F) A) and D)

Question 19

A ________ is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

Accepted Answer

The answer of A ________ is a horizontal or vertical...

Question 20

A chart is a visual representation of numerical data.

Accepted Answer

A) True 
 B)False

Exam 13: Excel: Customize, Analyze, and Summarize Query Data

A stacked column chart

Correct AnswerverifiedShow Answer

A line chart

Correct AnswerverifiedShow Answer

After creating a chart you can change the chart type by using

Correct AnswerverifiedShow Answer

A pie chart

Correct AnswerverifiedShow Answer

To reverse the data series, click ________ Row / Column in the Data group.

Correct AnswerverifiedShow Answer

A ________ is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

Correct AnswerverifiedShow Answer

A sparkline is a small line, column, or win / loss chart contained in a single cell.

Correct AnswerverifiedShow Answer

To change the data source of a chart use the Select Source dialog box from the Dialog\Numbers button.

Correct AnswerverifiedShow Answer

A chart is a visual representation of numerical data.

Correct AnswerverifiedShow Answer

To change the data source of a chart

Correct AnswerverifiedShow Answer

A gridline

Correct AnswerverifiedShow Answer

A column ________ displays data comparisons vertically in columns.

Correct AnswerverifiedShow Answer

Charts help reveal ________, patterns, and other tendencies that are difficult to identify by just looking at values in a worksheet.

Correct AnswerverifiedShow Answer

Excel displays a ________ when you create a multiple series chart. By default it appears on the right side of the plot area.

Correct AnswerverifiedShow Answer

A chart sheet contains a single chart and no spreadsheet data.

Correct AnswerverifiedShow Answer

You can use trendlines in unstacked column, bar, line, stock, scatter, and bubble charts.

Correct AnswerverifiedShow Answer

When choosing a chart ________, make sure it complements the chart data and is easy to read.

Correct AnswerverifiedShow Answer

An X Y (scatter) chart

Correct AnswerverifiedShow Answer

A sparkline is

Correct AnswerverifiedShow Answer

The chart area

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified