Question 1

A ________ is a graphic component that is overlaid onto data in worksheet cells.

Accepted Answer

A)  sparkline 
B)  trendline 
C)  data bar 
D)  data point 
A)  sparkline 
B)  trendline 
C)  data bar 
D)  data point

Question 2

A chart is like a picture,where a picture is worth 1,000 words.

Accepted Answer

A) True 
 B)False

Question 3

If you only want to print the chart on a worksheet,select the chart first,then choose the ________ option.

Accepted Answer

Print Sele

Question 4

A ________ chart is similar to a column chart except the data is horizontal instead of vertical.

Accepted Answer

A)  bar 
B)  combination 
C)  area 
D)  pie 
A)  bar 
B)  combination 
C)  area 
D)  pie

Question 5

A(n)________ is a special worksheet that only contains chart objects.

Accepted Answer

The answer of A(n)________ is a special worksheet that only...

Question 6

When a chart is selected,a(n)________ border surrounds the data that represents the legend labels.

Accepted Answer

The answer of When a chart is selected,a(n)________ border surrounds...

Question 7

Businesses have three primary objectives in charting: data analysis,________ testing,and persuasion.

Accepted Answer

The answer of Businesses have three primary objectives in charting:...

Question 8

In Excel,the default is to display the ________.

Accepted Answer

A)  trendlines 
B)  minor gridlines 
C)  major gridlines 
D)  major and minor gridlines 
A)  trendlines 
B)  minor gridlines 
C)  major gridlines 
D)  major and minor gridlines

Question 9

A group of related data values to be charted is a data ________.

Accepted Answer

The answer of A group of related data values to...

Question 10

A ________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.

Accepted Answer

A)  combination 
B)  bar 
C)  area 
D)  column 
A)  combination 
B)  bar 
C)  area 
D)  column

Question 11

The Recommended Charts feature offers single-click access to formatting,charts,formulas,PivotTables,and sparklines.

Accepted Answer

A) True 
 B)False

Question 12

Any action that can be completed in the Chart Formatting Control can also be completed through the Chart Tools contextual tab.

Accepted Answer

A) True 
 B)False

Question 13

In Excel,there are ________ types of trendlines.

Accepted Answer

A)  5 
B)  2 
C)  4 
D)  6 
A)  5 
B)  2 
C)  4 
D)  6

Question 14

A chart sheet contains gridlines.

Accepted Answer

A) True 
 B)False

Question 15

A ________ chart is useful for comparing data sets that are categorized.

Accepted Answer

A)  combination 
B)  column 
C)  area 
D)  Scatter 
A)  combination 
B)  column 
C)  area 
D)  Scatter

Question 16

A sparkline is a type of conditional formatting.

Accepted Answer

A) True 
 B)False

Question 17

If a chart is selected,a(n)________ border represents the data series.

Accepted Answer

A)  orange 
B)  purple 
C)  blue 
D)  green 
A)  orange 
B)  purple 
C)  blue 
D)  green

Question 18

A legend is considered to be a chart index.

Accepted Answer

A) True 
 B)False

Question 19

You can resize a chart by clicking and dragging a sizing handle.

Accepted Answer

A) True 
 B)False

Question 20

You should use the ________ effect and rotation of a chart conservatively.

Accepted Answer

The answer of You should use the ________ effect and...

A ________ is a graphic component that is overlaid onto data in worksheet cells.

A chart is like a picture,where a picture is worth 1,000 words.

If you only want to print the chart on a worksheet,select the chart first,then choose the ________ option.

A ________ chart is similar to a column chart except the data is horizontal instead of vertical.

A(n)________ is a special worksheet that only contains chart objects.

When a chart is selected,a(n)________ border surrounds the data that represents the legend labels.

Businesses have three primary objectives in charting: data analysis,________ testing,and persuasion.

In Excel,the default is to display the ________.

A group of related data values to be charted is a data ________.

A ________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.

The Recommended Charts feature offers single-click access to formatting,charts,formulas,PivotTables,and sparklines.

Any action that can be completed in the Chart Formatting Control can also be completed through the Chart Tools contextual tab.

In Excel,there are ________ types of trendlines.

A chart sheet contains gridlines.

A ________ chart is useful for comparing data sets that are categorized.

A sparkline is a type of conditional formatting.

If a chart is selected,a(n)________ border represents the data series.

A legend is considered to be a chart index.

You can resize a chart by clicking and dragging a sizing handle.

You should use the ________ effect and rotation of a chart conservatively.

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 ________ is a graphic component that is overlaid onto data in worksheet cells.

A chart is like a picture,where a picture is worth 1,000 words.

If you only want to print the chart on a worksheet,select the chart first,then choose the ________ option.

A ________ chart is similar to a column chart except the data is horizontal instead of vertical.

A(n)________ is a special worksheet that only contains chart objects.

When a chart is selected,a(n)________ border surrounds the data that represents the legend labels.

Businesses have three primary objectives in charting: data analysis,________ testing,and persuasion.

In Excel,the default is to display the ________.

A group of related data values to be charted is a data ________.

A ________ chart is a variation of a stacked line chart that emphasizes the magnitude of change over time and visually depicts a trend.

The Recommended Charts feature offers single-click access to formatting,charts,formulas,PivotTables,and sparklines.

Any action that can be completed in the Chart Formatting Control can also be completed through the Chart Tools contextual tab.

In Excel,there are ________ types of trendlines.

A chart sheet contains gridlines.

A ________ chart is useful for comparing data sets that are categorized.

A sparkline is a type of conditional formatting.

If a chart is selected,a(n)________ border represents the data series.

A legend is considered to be a chart index.

You can resize a chart by clicking and dragging a sizing handle.

You should use the ________ effect and rotation of a chart conservatively.

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