Question 1

The vertical axis provides values, not categories.

Accepted Answer

A) True 
 B)False

Question 2

On the CHART TOOLS FORMAT tab, click the More button in the ______________ Styles gallery to add a shape style to your chart element.

Accepted Answer

The answer of On the CHART TOOLS FORMAT tab, click...

Question 3

Compare a chart layout to a chart style.

Accepted Answer

A chart layout is a predefined...

Question 4

To change fill colors, textures and fonts for your chart, click the Chart ____ button.

Accepted Answer

A)   Styles
B)   Layout
C)   Gallery
D)   ThemesE) B) and C)
F) All of the above

Question 5

A chart layout is a predefined set of chart colors and fills.

Accepted Answer

A) True 
 B)False

Question 6

To select nonadjacent ranges, hold the ____ key.

Accepted Answer

A)   [Tab]
B)   [Enter]
C)   [Ctrl]]
D)   [Shift]E) A) and B)
F) A) and C)

Question 7

If you want to modify the formatting or alignment of a chart element, you can do so  in the ____ pane.

Accepted Answer

A)   Modify
B)   Chart Changes
C)   Format
D)   DesignE) A) and B)
F) None of the above

Question 8

Tiny charts that fit into one cell and show a trend are known as ____.

Accepted Answer

A)   mini charts
B)   micro charts
C)   sparklines
D)   scatterlinesE) A) and D)
F) C) and D)

Question 9

The Switch Row/Column button is in the ____ group on the CHART TOOLS DESIGN tab.

Accepted Answer

A)   Chart
B)   Data
C)   Tools
D)   NumberE) A) and B)
F) None of the above

Question 10

A column sparkline is a miniature line chart that includes a bar for each cell in a selected ____.

Accepted Answer

A)   chart
B)   range
C)   line graph
D)   worksheetE) A) and B)
F) A) and C)

Question 11

The chart background is an example of  a chart object .

Accepted Answer

A) True 
 B)False

Question 12

The ____ is the horizontal line at the base of the chart that shows categories.

Accepted Answer

A)   title axis
B)   z-axis
C)   x-axis
D)   y-axisE) A) and B)
F) None of the above

Question 13

The Move Chart button is in the ____ group on the CHART TOOLS DESIGN tab.

Accepted Answer

A)   Location
B)   Move
C)   Copy/Move
D)   Copy/PasteE) None of the above
F) All of the above

Question 14

Explain what a data table is.

Accepted Answer

A data table in a chart is a grid contai...

Question 15

A ____ sheet does not include any worksheet cells.

Accepted Answer

A)   spread
B)   backup
C)   data
D)   chartE) B) and C)
F) A) and D)

Question 16

Clustered Column is a type of Column chart

Accepted Answer

A) True 
 B)False

Question 17

The ____ identifies what each data series represents.

Accepted Answer

A)   legend
B)   data marker
C)   data title
D)   gridlineE) A) and B)
F) B) and C)

Question 18

You can add _____ to a sparkline to indicate values for each cell in the selected range.

Accepted Answer

A)   color
B)   weight
C)   stars
D)   markersE) A) and C)
F) B) and D)

Question 19

Describe how to print a chart without printing the worksheet data.

Accepted Answer

If your worksheet contains both a chart ...

Question 20

In the accompanying figure, in each category, there are ____ data series.

Accepted Answer

A)   two
B)   three
C)   four
D)   fiveE) C) and D)
F) B) and D)

Exam 9: Working With Charts

Compare a chart layout to a chart style.

Correct AnswerverifiedA chart layout is a predefined...View AnswerShow Answer

Describe how to print a chart without printing the worksheet data.

Correct AnswerverifiedIf your worksheet contains both a chart ...View AnswerShow Answer

The ____ identifies what each data series represents.

Correct AnswerverifiedShow Answer

To select nonadjacent ranges, hold the ____ key.

Correct AnswerverifiedShow Answer

A chart layout is a predefined set of chart colors and fills.

Correct AnswerverifiedShow Answer

The chart background is an example of a chart object .

Correct AnswerverifiedShow Answer

A ____ sheet does not include any worksheet cells.

Correct AnswerverifiedShow Answer

Explain what a data table is.

Correct AnswerverifiedA data table in a chart is a grid contai...View AnswerShow Answer

The Switch Row/Column button is in the ____ group on the CHART TOOLS DESIGN tab.

Correct AnswerverifiedShow Answer

On the CHART TOOLS FORMAT tab, click the More button in the ______________ Styles gallery to add a shape style to your chart element.

Correct AnswerverifiedShow Answer

The ____ is the horizontal line at the base of the chart that shows categories.

Correct AnswerverifiedShow Answer

Clustered Column is a type of Column chart

Correct AnswerverifiedShow Answer

In the accompanying figure, in each category, there are ____ data series.

Correct AnswerverifiedShow Answer

The vertical axis provides values, not categories.

Correct AnswerverifiedShow Answer

A column sparkline is a miniature line chart that includes a bar for each cell in a selected ____.

Correct AnswerverifiedShow Answer

Tiny charts that fit into one cell and show a trend are known as ____.

Correct AnswerverifiedShow Answer

You can add _____ to a sparkline to indicate values for each cell in the selected range.

Correct AnswerverifiedShow Answer

To change fill colors, textures and fonts for your chart, click the Chart ____ button.

Correct AnswerverifiedShow Answer

The Move Chart button is in the ____ group on the CHART TOOLS DESIGN tab.

Correct AnswerverifiedShow Answer

If you want to modify the formatting or alignment of a chart element, you can do so in the ____ pane.

Correct AnswerverifiedShow Answer

Correct Answer
verified
A chart layout is a predefined...
View Answer

Correct Answer
verified
If your worksheet contains both a chart ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data table in a chart is a grid contai...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified