Question 1

A data ________ is a group of related data points.

Accepted Answer

series

Question 2

The Chart Styles group contains predefined styles that control the range of the data and the numbers in the chart.

Accepted Answer

A) True 
 B)False  False

Question 3

A chart title

Accepted Answer

A)  is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area. 
B)  is a label that describes the chart. 
C)  is a label that describes either the category axis or the value axis. 
D)  is the value or name of a data point. 
A)  is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area. 
B)  is a label that describes the chart. 
C)  is a label that describes either the category axis or the value axis. 
D)  is the value or name of a data point. B

Question 4

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: Design, Layout, and Format.

Accepted Answer

A) True 
 B)False

Question 5

If you ________ a chart on the same sheet as the data source, you need to decide if you want to print the data only, the data and the chart, or the chart only.

Accepted Answer

The answer of If you ________ a chart on the...

Question 6

A chart ________ is the label that describes the entire chart; it should reflect the purpose of the chart.

Accepted Answer

The answer of A chart ________ is the label that...

Question 7

When creating a chart, be sure that each data series uses the same ________.

Accepted Answer

The answer of When creating a chart, be sure that...

Question 8

A doughnut chart displays

Accepted Answer

A)  enables you to adjust the size of the chart remotely. 
B)  relationships among three values by using bubbles. 
C)  contains a single chart and no spreadsheet data. 
D)  values as percentages of the whole but may contain more than one data series. 
A)  enables you to adjust the size of the chart remotely. 
B)  relationships among three values by using bubbles. 
C)  contains a single chart and no spreadsheet data. 
D)  values as percentages of the whole but may contain more than one data series.

Question 9

Before creating a sparkline, identify what ________ you want to depict and where you want to place it.

Accepted Answer

The answer of Before creating a sparkline, identify what ________...

Question 10

A data series

Accepted Answer

A)  displays data comparisons vertically in columns. 
B)  is a group of related data points. 
C)  is text that describes a collection of data points in a chart. 
D)  contains the entire chart and all of its elements. 
A)  displays data comparisons vertically in columns. 
B)  is a group of related data points. 
C)  is text that describes a collection of data points in a chart. 
D)  contains the entire chart and all of its elements.

Question 11

A 100% stacked column chart

Accepted Answer

A)  uses a line to connect data points in order to show trends over a period of time. 
B)  places (stacks) data in one column per category, with each column having the same height of 100%. 
C)  compares values across categories using horizontal bars. 
D)  adds a third dimension to each data series, creating a distorted perspective of the data. 
A)  uses a line to connect data points in order to show trends over a period of time. 
B)  places (stacks) data in one column per category, with each column having the same height of 100%. 
C)  compares values across categories using horizontal bars. 
D)  adds a third dimension to each data series, creating a distorted perspective of the data.

Question 12

An exploded pie chart

Accepted Answer

A)  shows the high, low, and close prices for individual stocks over time. 
B)  emphasizes magnitude of changes over time by filling in the space between lines with a color. 
C)  shows a relationship between two variables. 
D)  separates one or more pie slices from the rest of the pie chart. 
A)  shows the high, low, and close prices for individual stocks over time. 
B)  emphasizes magnitude of changes over time by filling in the space between lines with a color. 
C)  shows a relationship between two variables. 
D)  separates one or more pie slices from the rest of the pie chart.

Question 13

A handle, indicated by faint dots on the outside border of a selected chart

Accepted Answer

A)  enables you to adjust the size of the chart. 
B)  is a label that describes either the category axis or the value axis. 
C)  is a miniature chart contained in a single cell. 
D)  is a label that describes the chart. 
A)  enables you to adjust the size of the chart. 
B)  is a label that describes either the category axis or the value axis. 
C)  is a miniature chart contained in a single cell. 
D)  is a label that describes the chart.

Question 14

A 3-D chart

Accepted Answer

A)  uses a line to connect data points in order to show trends over a period of time. 
B)  shows each data point in proportion to the whole data series as a slice in a circular pie. 
C)  compares values across categories using horizontal bars. 
D)  adds a third dimension to each data series, creating a distorted perspective of the data. 
A)  uses a line to connect data points in order to show trends over a period of time. 
B)  shows each data point in proportion to the whole data series as a slice in a circular pie. 
C)  compares values across categories using horizontal bars. 
D)  adds a third dimension to each data series, creating a distorted perspective of the data.

Question 15

A gridline is a line used to depict trends and forecast future data.

Accepted Answer

A) True 
 B)False

Question 16

A ________ is a line used to depict trends and forecast future data.

Accepted Answer

The answer of A ________ is a line used to...

Question 17

To save a chart as a template, select the chart, click the ________ tab, and then click Save as Template in the Type group.

Accepted Answer

The answer of To save a chart as a template,...

Question 18

A bubble chart shows

Accepted Answer

A)  a single chart and no spreadsheet data. 
B)  you how to adjust the size of the chart using the mouse. 
C)  a miniature chart contained in a single cell. 
D)  relationships among three values by using bubbles. 
A)  a single chart and no spreadsheet data. 
B)  you how to adjust the size of the chart using the mouse. 
C)  a miniature chart contained in a single cell. 
D)  relationships among three values by using bubbles.

Question 19

A chart layout determines which chart elements appear in the chart area and how they are positioned within the chart area.

Accepted Answer

A) True 
 B)False

Question 20

To reverse the Data Series of a chart

Accepted Answer

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

A data ________ is a group of related data points.

The Chart Styles group contains predefined styles that control the range of the data and the numbers in the chart.

A chart title

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: Design, Layout, and Format.

If you ________ a chart on the same sheet as the data source, you need to decide if you want to print the data only, the data and the chart, or the chart only.

A chart ________ is the label that describes the entire chart; it should reflect the purpose of the chart.

When creating a chart, be sure that each data series uses the same ________.

A doughnut chart displays

Before creating a sparkline, identify what ________ you want to depict and where you want to place it.

A data series

A 100% stacked column chart

An exploded pie chart

A handle, indicated by faint dots on the outside border of a selected chart

A 3-D chart

A gridline is a line used to depict trends and forecast future data.

A ________ is a line used to depict trends and forecast future data.

To save a chart as a template, select the chart, click the ________ tab, and then click Save as Template in the Type group.

A bubble chart shows

A chart layout determines which chart elements appear in the chart area and how they are positioned within the chart area.

To reverse the Data Series of a chart

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 data ________ is a group of related data points.

The Chart Styles group contains predefined styles that control the range of the data and the numbers in the chart.

A chart title

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: Design, Layout, and Format.

If you ________ a chart on the same sheet as the data source, you need to decide if you want to print the data only, the data and the chart, or the chart only.

A chart ________ is the label that describes the entire chart; it should reflect the purpose of the chart.

When creating a chart, be sure that each data series uses the same ________.

A doughnut chart displays

Before creating a sparkline, identify what ________ you want to depict and where you want to place it.

A data series

A 100% stacked column chart

An exploded pie chart

A handle, indicated by faint dots on the outside border of a selected chart

A 3-D chart

A gridline is a line used to depict trends and forecast future data.

A ________ is a line used to depict trends and forecast future data.

To save a chart as a template, select the chart, click the ________ tab, and then click Save as Template in the Type group.

A bubble chart shows

A chart layout determines which chart elements appear in the chart area and how they are positioned within the chart area.

To reverse the Data Series of a chart

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