Question 1

Although 3-D charts are visually attractive,they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.

Accepted Answer

A) True 
 B)False

Question 2

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

Accepted Answer

A)   Insert New
B)   Tab
C)   Move Chart
D)   Change ChartE) A) and B)
F) None of the above

Question 3

To revise the title of a chart rather than replacing it,you can ____________________ the chart title to place the insertion point in the text,and then edit the text as needed.

Accepted Answer

double-cli...

Question 4

To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the Sparkline Tools ____ tab.

Accepted Answer

A)   Create
B)   View
C)   Layout
D)   DesignE) B) and C)
F) All of the above

Question 5

To fill a column with a blend of colors in a column chart,you would choose ____ from the Fill options.

Accepted Answer

A)   picture fill
B)   solid fill
C)   no fill
D)   gradient fillE) B) and D)
F) All of the above

Question 6

To display a large number of categories whose values are close to one another,you should create a ____ chart.

Accepted Answer

A)   column
B)   bar
C)   pie
D)   either a.or b.E) All of the above
F) C) and D)

Question 7

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

Accepted Answer

A)   espionage
B)   clutter
C)   confusion
D)   junkE) A) and C)
F) C) and D)

Question 8

The series name has only one data series._________________________

Accepted Answer

A) True 
 B)False

Question 9

Since each slice of a pie represents a different value in the series,you ____.

Accepted Answer

A)   must format each slice separately
B)   can format the entire data series
C)   can format multiple slices at once
D)   cannot format any single sliceE) A) and C)
F) A) and B)

Question 10

To move or resize an embedded chart,____.

Accepted Answer

A)   select the chart and drag the selection box
B)   drag the sizing handle on the selection box
C)   select the chart and press Tab
D)   both a and bE) A) and D)
F) A) and C)

Question 11

The Label Position option in the Format Data Labels dialog box includes ____.

Accepted Answer

A)   Center
B)   Inside End
C)   Outside End
D)   all of the aboveE) C) and D)
F) None of the above

Question 12

It's difficult to read the exact scale on some of Andy's data.Adding ____ would make it easier to read.

Accepted Answer

A)   a legend
B)   major tick marks
C)   colors
D)   more numbersE) B) and D)
F) A) and D)

Question 13

The words Information,Services,an Manufacturing shown in Column A are the ____.

Accepted Answer

A)   data series
B)   data source
C)   series value
D)   series sourceE) A) and B)
F) B) and D)

Question 14

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Compares a collection of values from several different data sets

Accepted Answer

A)  Bubble
B)  Column
C)  XY
D)  Line
E)  RadarF) PieG) DoughnutH) BarI) SurfaceJ) AreaK) StockL) ScatterM) B) and C)
N) D) and I)

Question 15

By default,Excel inserts a chart as an embedded chart._________________________

Accepted Answer

A) True 
 B)False

Question 16

To work with a title or other individual element of a chart,select the ____ tab.

Accepted Answer

A)   Design
B)   Layout
C)   Format
D)   PrintE) C) and D)
F) All of the above

Question 17

A chart or ____________________ is a visual representation of a set of data.

Accepted Answer

The answer of A chart or ____________________ is a visual...

Question 18

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

Accepted Answer

A)   Change Chart Type
B)   New Chart
C)   Alter Existing Chart
D)   Modify ChartE) None of the above
F) A) and B)

Question 19

Excel allows you to overlay a legend on a chart as a space-saving option.

Accepted Answer

A) True 
 B)False

Question 20

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent and each cell represents only a single bar from the bar chart.

Accepted Answer

A) True 
 B)False

Exam 4: Enhancing a Workbook With Charts and Graphs

It's difficult to read the exact scale on some of Andy's data.Adding ____ would make it easier to read.

Correct AnswerverifiedShow Answer

By default,Excel inserts a chart as an embedded chart._________________________

Correct AnswerverifiedShow Answer

You already created a line chart,but now decide that you want to change this chart to a pie chart.To do this,you click ____ from the Type group in the Chart Tools Design tab.

Correct AnswerverifiedShow Answer

A chart or ____________________ is a visual representation of a set of data.

Correct AnswerverifiedShow Answer

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Compares a collection of values from several different data sets

Correct AnswerverifiedShow Answer

The words Information,Services,an Manufacturing shown in Column A are the ____.

Correct AnswerverifiedShow Answer

To fill a column with a blend of colors in a column chart,you would choose ____ from the Fill options.

Correct AnswerverifiedShow Answer

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent and each cell represents only a single bar from the bar chart.

Correct AnswerverifiedShow Answer

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

Correct AnswerverifiedShow Answer

Excel allows you to overlay a legend on a chart as a space-saving option.

Correct AnswerverifiedShow Answer

To format an individual sparkline,select the sparkline you want to format,and then click the Ungroup button in the Group group on the Sparkline Tools ____ tab.

Correct AnswerverifiedShow Answer

To revise the title of a chart rather than replacing it,you can ____________________ the chart title to place the insertion point in the text,and then edit the text as needed.

Correct Answerverifieddouble-cli...View AnswerShow Answer

To display a large number of categories whose values are close to one another,you should create a ____ chart.

Correct AnswerverifiedShow Answer

To move or resize an embedded chart,____.

Correct AnswerverifiedShow Answer

Although 3-D charts are visually attractive,they can obscure the relationship between the values in the chart by making it difficult to see which slice is larger.

Correct AnswerverifiedShow Answer

The series name has only one data series._________________________

Correct AnswerverifiedShow Answer

Since each slice of a pie represents a different value in the series,you ____.

Correct AnswerverifiedShow Answer

To work with a title or other individual element of a chart,select the ____ tab.

Correct AnswerverifiedShow Answer

The Label Position option in the Format Data Labels dialog box includes ____.

Correct AnswerverifiedShow Answer

Edward Tufte was concerned with what he termed as "chart ____," in which a proliferation of chart elements-chosen because they look "nice"-confuse and distract the reader.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
double-cli...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified