Question 1

Using a(n)________ pie chart,you can emphasize a slice by moving it out away from the other slices.

Accepted Answer

The answer of Using a(n)________ pie chart,you can emphasize a...

Question 2

In the worksheet above,the red arrow is pointing at a(n)________

Accepted Answer

data bar

Question 3

An enhanced pie chart is a chart in which a slice is pulled outward away from the other slices.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Pie
Scatter
Column
Line
Bar

Accepted Answer

The Answer of Shows changes within a data series and is...

Question 5

Gridlines can be customized by using the Format ________ Gridlines task pane.

Accepted Answer

Major

Question 6

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

Accepted Answer

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

Question 7

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 8

You can display data bars as a one-color solid fill or a gradient fill from left to right as the numerical value increases.

Accepted Answer

A) True 
 B)False

Question 9

When creating a chart from data in a worksheet,the legend data is indicated by ________.

Accepted Answer

A)  shading the data with a light purple background
B)  surrounding the data with a purple border
C)  changing font color of the data to red
D)  surrounding the data with a red dashed border

Question 10

A common use for ________ charts is for project management.

Accepted Answer

Gantt

Question 11

Match between columns
                        Premises: Trendline
Combination
Gantt
Data point
Sparkline

Accepted Answer

The Answer of Small chart embedding in a worksheet cell is...

Question 12

________ are small charts that are embedded into the cells in a worksheet to help with trend analysis.

Accepted Answer

A)  Minicharts
B)  Microcharts
C)  Sparklines
D)  Data bars

Question 13

To see possible types of graph to use,you can click Recommended Charts in the ________.

Accepted Answer

A)  Illustrations group on the INSERT tab.
B)  Charts group on the INSERT tab.
C)  Illustrations group on the VIEW tab.
D)  Charts group on the VIEW tab.

Question 14

To move a chart,you double-click its border and drag the chart to a new location.

Accepted Answer

A) True 
 B)False

Question 15

The chart shown above depicts a line chart.

Accepted Answer

A) True 
 B)False

Question 16

Match between columns
                        Premises: Chart Sheet
Data visualization
Data series
Quick Analysis
Data bar

Accepted Answer

The Answer of Tool allowing single-click access to formatting,,charts,and formulas is...

Question 17

A bar chart is displayed horizontally and is useful for comparing categorized data sets.

Accepted Answer

A) True 
 B)False

Question 18

To change the color of a chart ,you click Change Colors in the ________.

Accepted Answer

A)  Chart Layouts group on the CHART TOOLS DESIGN tab
B)  Chart Styles group on the CHART TOOLS DESIGN tab
C)  Chart Layouts group on the CHART TOOLS FORMAT tab
D)  Chart Styles group on the CHART TOOLS FORMAT tab

Question 19

Match between columns Premises:

Accepted Answer

The Answer of Chart Elements and Chart Filters and Size is...

Question 20

To illustrate the relationship of the parts to the whole,you would use a(n) ________ chart.

Accepted Answer

A)  Line
B)  Pie
C)  Scatter
D)  Area

Exam 4: Effective Charts

Using a(n)________ pie chart,you can emphasize a slice by moving it out away from the other slices.

Correct Answer
verified

In the worksheet above,the red arrow is pointing at a(n)________

Correct Answer
verified
data bar

An enhanced pie chart is a chart in which a slice is pulled outward away from the other slices.

Correct Answer
verified

Match the following chart types to their application.

Gridlines can be customized by using the Format ________ Gridlines task pane.

Correct Answer
verified
Major

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

Correct Answer
verified

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

Correct Answer
verified

You can display data bars as a one-color solid fill or a gradient fill from left to right as the numerical value increases.

Correct Answer
verified

When creating a chart from data in a worksheet,the legend data is indicated by ________.

Correct Answer
verified

A common use for ________ charts is for project management.

Correct Answer
verified
Gantt

Match the following terms to their definition.

________ are small charts that are embedded into the cells in a worksheet to help with trend analysis.

Correct Answer
verified

To see possible types of graph to use,you can click Recommended Charts in the ________.

Correct Answer
verified

To move a chart,you double-click its border and drag the chart to a new location.

Correct Answer
verified

The chart shown above depicts a line chart.

Correct Answer
verified

Match the following terms to their definition.

A bar chart is displayed horizontally and is useful for comparing categorized data sets.

Correct Answer
verified

To change the color of a chart ,you click Change Colors in the ________.

Correct Answer
verified

Match the following buttons to their action.

To illustrate the relationship of the parts to the whole,you would use a(n) ________ chart.

Correct Answer
verified

Exam 4: Effective Charts

Using a(n)________ pie chart,you can emphasize a slice by moving it out away from the other slices.

Correct AnswerverifiedShow Answer

In the worksheet above,the red arrow is pointing at a(n)________

Correct Answerverifieddata bar

An enhanced pie chart is a chart in which a slice is pulled outward away from the other slices.

Correct AnswerverifiedShow Answer

Match the following chart types to their application.

Gridlines can be customized by using the Format ________ Gridlines task pane.

Correct AnswerverifiedMajor

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You can display data bars as a one-color solid fill or a gradient fill from left to right as the numerical value increases.

Correct AnswerverifiedShow Answer

When creating a chart from data in a worksheet,the legend data is indicated by ________.

Correct AnswerverifiedShow Answer

A common use for ________ charts is for project management.

Correct AnswerverifiedGantt

Match the following terms to their definition.

________ are small charts that are embedded into the cells in a worksheet to help with trend analysis.

Correct AnswerverifiedShow Answer

To see possible types of graph to use,you can click Recommended Charts in the ________.

Correct AnswerverifiedShow Answer

To move a chart,you double-click its border and drag the chart to a new location.

Correct AnswerverifiedShow Answer

The chart shown above depicts a line chart.

Correct AnswerverifiedShow Answer

Match the following terms to their definition.

A bar chart is displayed horizontally and is useful for comparing categorized data sets.

Correct AnswerverifiedShow Answer

To change the color of a chart ,you click Change Colors in the ________.

Correct AnswerverifiedShow Answer

Match the following buttons to their action.

To illustrate the relationship of the parts to the whole,you would use a(n) ________ chart.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
data bar

Correct Answer
verified

Correct Answer
verified
Major

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Gantt

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified