Question 1

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

Question 2

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

Question 3

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 4

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

Question 5

A chart is a visual representation of numerical data.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

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 8

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

Question 9

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

Question 10

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

A column ________ displays data comparisons vertically in columns.

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Question 15

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

Question 16

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 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

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

A line chart

To change the data source of a chart

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

An X Y (scatter) chart

A chart is a visual representation of numerical data.

The chart area

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

A stacked column chart

A pie chart

A gridline

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

A column ________ displays data comparisons vertically in columns.

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

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

A sparkline is

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

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

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

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

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

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

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

A line chart

To change the data source of a chart

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

An X Y (scatter) chart

A chart is a visual representation of numerical data.

The chart area

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

A stacked column chart

A pie chart

A gridline

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

A column ________ displays data comparisons vertically in columns.

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

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

A sparkline is

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

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

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

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

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

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters