Question 1

To reverse the Data Series of a chart click Switch Row / Column in the Data group.

Accepted Answer

A) True 
 B)False

Question 2

A trendline

Accepted Answer

A)  is a line used to depict trends and forecast future data. 
B)  is text that describes a collection of data points in a chart. 
C)  is a group of related data points. 
D)  displays data comparisons vertically in columns. 
A)  is a line used to depict trends and forecast future data. 
B)  is text that describes a collection of data points in a chart. 
C)  is a group of related data points. 
D)  displays data comparisons vertically in columns.

Question 3

As you customize a chart, remember that its purpose is to ________ a message to your audience.

Accepted Answer

The answer of As you customize a chart, remember that...

Question 4

The plot area

Accepted Answer

A)  contains graphical representation of values in data series. 
B)  is a vertical line that borders the plot area to provide a frame of reference for measurement. 
C)  is a horizontal line that borders the plot area to provide a frame of reference for measurement. 
D)  provides descriptive group names for subdividing the data series. 
A)  contains graphical representation of values in data series. 
B)  is a vertical line that borders the plot area to provide a frame of reference for measurement. 
C)  is a horizontal line that borders the plot area to provide a frame of reference for measurement. 
D)  provides descriptive group names for subdividing the data series.

Question 5

A legend

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)  places (stacks) data in one column per category, with each column having the same height of 100%. 
D)  is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart. 
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)  places (stacks) data in one column per category, with each column having the same height of 100%. 
D)  is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.

Question 6

To change the ________ representation on the axes and gridlines, click Axes in the Axes group, and then point to Primary Vertical Axis.

Accepted Answer

The answer of To change the ________ representation on the...

Question 7

The Y-axis

Accepted Answer

A)  is text that describes a collection of data points in a chart. 
B)  is a vertical line that borders the plot area to provide a frame of reference for measurement. 
C)  compares values for one set of data. 
D)  is a horizontal line that borders the plot area to provide a frame of reference for measurement. 
A)  is text that describes a collection of data points in a chart. 
B)  is a vertical line that borders the plot area to provide a frame of reference for measurement. 
C)  compares values for one set of data. 
D)  is a horizontal line that borders the plot area to provide a frame of reference for measurement.

Question 8

You can rename a chart sheet before you click OK in the ________ Chart dialog box.

Accepted Answer

The answer of You can rename a chart sheet before...

Question 9

A sparkline includes all the chart titles and axes labels just like a regular chart.

Accepted Answer

A) True 
 B)False

Question 10

A resizing handle, indicated by faint dots on the outside border of a selected chart, enables you to adjust the size of the chart.

Accepted Answer

A) True 
 B)False

To reverse the Data Series of a chart click Switch Row / Column in the Data group.

A trendline

As you customize a chart, remember that its purpose is to ________ a message to your audience.

The plot area

A legend

To change the ________ representation on the axes and gridlines, click Axes in the Axes group, and then point to Primary Vertical Axis.

The Y-axis

You can rename a chart sheet before you click OK in the ________ Chart dialog box.

A sparkline includes all the chart titles and axes labels just like a regular chart.

A resizing handle, indicated by faint dots on the outside border of a selected chart, enables you to adjust the size of the 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

To reverse the Data Series of a chart click Switch Row / Column in the Data group.

A trendline

As you customize a chart, remember that its purpose is to ________ a message to your audience.

The plot area

A legend

To change the ________ representation on the axes and gridlines, click Axes in the Axes group, and then point to Primary Vertical Axis.

The Y-axis

You can rename a chart sheet before you click OK in the ________ Chart dialog box.

A sparkline includes all the chart titles and axes labels just like a regular chart.

A resizing handle, indicated by faint dots on the outside border of a selected chart, enables you to adjust the size of the 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