Question 1

A common method used to emphasize a(n)________ chart is to explode a slice.

Accepted Answer

The answer of A common method used to emphasize a(n)________...

Question 2

When creating a chart,best practices indicate that you first consider ________.

Accepted Answer

A)  the basic design of the chart 
B)  the data 
C)  who will be viewing the chart 
D)  how quickly it needs to be created 
A)  the basic design of the chart 
B)  the data 
C)  who will be viewing the chart 
D)  how quickly it needs to be created

Question 3

Chart styles are located in the ________ tab.

Accepted Answer

A)  Chart Formats group on the Chart Design 
B)  Chart Styles group on the Chart Design 
C)  Chart Formats group on the Chart Tools Design 
D)  Chart Styles group on the Chart Tools Design 
A)  Chart Formats group on the Chart Design 
B)  Chart Styles group on the Chart Design 
C)  Chart Formats group on the Chart Tools Design 
D)  Chart Styles group on the Chart Tools Design

Question 4

A line chart is used to display a percent to a whole.

Accepted Answer

A) True 
 B)False

Question 5

When you click an existing chart,you initially activate the legend.

Accepted Answer

A) True 
 B)False

Question 6

A ________ chart is used to communicate trends over time.

Accepted Answer

A)  line 
B)  column 
C)  pie 
D)  stacked column 
A)  line 
B)  column 
C)  pie 
D)  stacked column

Question 7

Which of the following is NOT a common readability issue that should be avoided when creating a chart?

Accepted Answer

A)  Check the color scheme to ensure that the text is readable. 
B)  Add a chart title that conveys context of time and scope. 
C)  Move data labels, and remove excess information. 
D)  Information or labeling is misleading. 
A)  Check the color scheme to ensure that the text is readable. 
B)  Add a chart title that conveys context of time and scope. 
C)  Move data labels, and remove excess information. 
D)  Information or labeling is misleading.

Question 8

A(n)________ chart represents a percent to a whole.

Accepted Answer

The answer of A(n)________ chart represents a percent to a...

Question 9

Which of the following is NOT true about modifying axes?

Accepted Answer

A)  Excel knows best in regard to formatting the axes; thus, if it seems to crowded, it probably is not. 
B)  The Format Axis task pane can be used to manually set the axis options. 
C)  The default Excel scale minimum and maximum values are set automatically on the basis of the data. 
D)  The x-axis and y-axis scales are automatically created through a mathematical algorithm within Excel. 
A)  Excel knows best in regard to formatting the axes; thus, if it seems to crowded, it probably is not. 
B)  The Format Axis task pane can be used to manually set the axis options. 
C)  The default Excel scale minimum and maximum values are set automatically on the basis of the data. 
D)  The x-axis and y-axis scales are automatically created through a mathematical algorithm within Excel.

Question 10

A(n)________ chart is displayed vertically and is useful for comparing categorized data sets.

Accepted Answer

The answer of A(n)________ chart is displayed vertically and is...

Question 11

________ are lines that help determine the size of the bars,columns,or data lines.

Accepted Answer

The answer of ________ are lines that help determine the...

Question 12

Match between columns
                        Premises: Bar chart
Line chart
Recommended charts
Quick Analysis
Pie chart

Accepted Answer

The Answer of A feature that quickly analyzes a selection is...

Question 13

Small charts that are inserted into a cell are called ________.

Accepted Answer

The answer of Small charts that are inserted into a...

Question 14

The ________ tool is a contextual tool that provides single-click access to charts and PivotTables.

Accepted Answer

The answer of The ________ tool is a contextual tool...

Question 15

A data ________ is an individual value in a data series.

Accepted Answer

The answer of A data ________ is an individual value...

Question 16

If a chart is placed on a special worksheet that is dedicated to displaying chart objects,it is ________.

Accepted Answer

A)  on a chart sheet 
B)  integrated 
C)  embedded 
D)  an external object. 
A)  on a chart sheet 
B)  integrated 
C)  embedded 
D)  an external object.

Question 17

Charts are a critical component of data visualization.

Accepted Answer

A) True 
 B)False

Question 18

In a chart,the ________ is an index that identifies the data.

Accepted Answer

The answer of In a chart,the ________ is an index...

Question 19

The ________ tool is a contextual tool that appears when you select data in a worksheet.

Accepted Answer

A)  Quick Analysis 
B)  Sparklines 
C)  Quick Chart 
D)  Insert Charts 
A)  Quick Analysis 
B)  Sparklines 
C)  Quick Chart 
D)  Insert Charts

Question 20

A chart sheet is a special worksheet that is dedicated to displaying chart objects.

Accepted Answer

A) True 
 B)False

A common method used to emphasize a(n)________ chart is to explode a slice.

When creating a chart,best practices indicate that you first consider ________.

Chart styles are located in the ________ tab.

A line chart is used to display a percent to a whole.

When you click an existing chart,you initially activate the legend.

A ________ chart is used to communicate trends over time.

Which of the following is NOT a common readability issue that should be avoided when creating a chart?

A(n)________ chart represents a percent to a whole.

Which of the following is NOT true about modifying axes?

A(n)________ chart is displayed vertically and is useful for comparing categorized data sets.

________ are lines that help determine the size of the bars,columns,or data lines.

Small charts that are inserted into a cell are called ________.

The ________ tool is a contextual tool that provides single-click access to charts and PivotTables.

A data ________ is an individual value in a data series.

If a chart is placed on a special worksheet that is dedicated to displaying chart objects,it is ________.

Charts are a critical component of data visualization.

In a chart,the ________ is an index that identifies the data.

The ________ tool is a contextual tool that appears when you select data in a worksheet.

A chart sheet is a special worksheet that is dedicated to displaying chart objects.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 10: Effective Charts

A common method used to emphasize a(n)________ chart is to explode a slice.

When creating a chart,best practices indicate that you first consider ________.

Chart styles are located in the ________ tab.

A line chart is used to display a percent to a whole.

When you click an existing chart,you initially activate the legend.

A ________ chart is used to communicate trends over time.

Which of the following is NOT a common readability issue that should be avoided when creating a chart?

A(n)________ chart represents a percent to a whole.

Which of the following is NOT true about modifying axes?

A(n)________ chart is displayed vertically and is useful for comparing categorized data sets.

________ are lines that help determine the size of the bars,columns,or data lines.

Small charts that are inserted into a cell are called ________.

The ________ tool is a contextual tool that provides single-click access to charts and PivotTables.

A data ________ is an individual value in a data series.

If a chart is placed on a special worksheet that is dedicated to displaying chart objects,it is ________.

Charts are a critical component of data visualization.

In a chart,the ________ is an index that identifies the data.

The ________ tool is a contextual tool that appears when you select data in a worksheet.

A chart sheet is a special worksheet that is dedicated to displaying chart objects.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Formats, Functions, and Formulas

Cell References, Named Ranges, and Functions

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters