Question 1

Excel normally uses all the selected data in creating a chart.

Accepted Answer

A) True 
 B)False

Question 2

In a bar chart, which axis displays the categories?

Accepted Answer

A)   Horizontal
B)   Vertical
C)   X
D)   ZE) A) and B)
F) All of the above

Question 3

A stacked column chart displays multiple columns for each category.

Accepted Answer

A) True 
 B)False

Question 4

Match the following terms with their description:
i. Chart element
II. Chart filter
III. Chart sheet
IV. Chart style
v. Chart title

Accepted Answer

A)   Decides what is hidden or displayed in a chart
B)   Sets the formatting of the chart
C)   Contains no spreadsheet data
D)   Describes the entire chart
E)   This helps make a chart clearer.F) C) and E)
G) B) and C)

Question 5

The ________ is the visual key to a chart.

Accepted Answer

The answer of The ________ is the visual key to...

Question 6

Match the following terms with their description:
i. Radar
II. Histogram
III. Area
IV. X Y (scatter)  chart
v. Combo chart

Accepted Answer

A)   Often used in educational, scientific, and medical experiments
B)   Similar to a column chart
C)   Used for two different but related data types
D)   Spokes radiate from the center to the outer edges
E)   Similar to a line chartF) A) and D)
G) C) and E)

Question 7

Picking a chart ________ will allow you to change several formatting elements at the same time.

Accepted Answer

The answer of Picking a chart ________ will allow you...

Question 8

Where does the primary axis display on a Combo chart?

Accepted Answer

A)   Top
B)   Bottom
C)   Right side
D)   Left sideE) A) and B)
F) B) and C)

Question 9

Effective charts never overwhelm an audience.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is not true about trendlines?

Accepted Answer

A)   They help forecast future data.
B)   They can be added to all chart types.
C)   The line indicates possible future values.
D)   They are added to existing charts.E) None of the above
F) All of the above

Question 11

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

Accepted Answer

A) True 
 B)False

Question 12

What can you not do from the Select Data Source dialog box?

Accepted Answer

A)   Change chart data range
B)   Delete a data series
C)   Change chart type
D)   Add chart data seriesE) B) and C)
F) A) and B)

Question 13

Which axis displays incremental numbers to identify the approximate values of data points?

Accepted Answer

A)   x-axis
B)   z-axis
C)   category axis
D)   value axisE) All of the above
F) A) and B)

Question 14

What chart type can display two different chart types at the same time?

Accepted Answer

A)   Combo
B)   Combination
C)   Mixed
D)   MultipleE) C) and D)
F) B) and C)

Question 15

In a column chart the horizontal axis displays the ________.

Accepted Answer

The answer of In a column chart the horizontal axis...

Question 16

If you wanted to show trends over set periods of time, you probably want to use a(n) ________ chart.

Accepted Answer

The answer of If you wanted to show trends over...

Question 17

A 100% stacked column chart is similar to which other chart in that it converts values to percentages?

Accepted Answer

A)   Clustered column
B)   Radar
C)   Line
D)   PieE) All of the above
F) None of the above

Question 18

Match the following terms with their description:
i. Line chart
II. Pie chart
III. Bar chart
IV. Column chart
v. Sparkline

Accepted Answer

A)   Uses horizontal bars
B)   Chart resides in one cell
C)   Line connect data points
D)   Uses slices to display data points
E)   Uses vertical barsF) A) and B)
G) C) and D)

Question 19

Even after selecting a data source for a chart you can still apply various filters on one or more series.

Accepted Answer

A) True 
 B)False

Question 20

When you want to chart two related types of data, the Combo chart is perfect.

Accepted Answer

A) True 
 B)False

Exam 8: Excell: Charts

Which axis displays incremental numbers to identify the approximate values of data points?

Correct AnswerverifiedShow Answer

Even after selecting a data source for a chart you can still apply various filters on one or more series.

Correct AnswerverifiedShow Answer

As long as you pick the correct chart you can mix numeric value systems, such as dollars and number of units sold.

Correct AnswerverifiedShow Answer

Excel normally uses all the selected data in creating a chart.

Correct AnswerverifiedShow Answer

Effective charts never overwhelm an audience.

Correct AnswerverifiedShow Answer

What can you not do from the Select Data Source dialog box?

Correct AnswerverifiedShow Answer

A stacked column chart displays multiple columns for each category.

Correct AnswerverifiedShow Answer

In a column chart the horizontal axis displays the ________.

Correct AnswerverifiedShow Answer

Where does the primary axis display on a Combo chart?

Correct AnswerverifiedShow Answer

Match the following terms with their description: i. Radar II. Histogram III. Area IV. X Y (scatter) chart v. Combo chart

Correct AnswerverifiedShow Answer

What chart type can display two different chart types at the same time?

Correct AnswerverifiedShow Answer

In a bar chart, which axis displays the categories?

Correct AnswerverifiedShow Answer

The ________ is the visual key to a chart.

Correct AnswerverifiedShow Answer

When you want to chart two related types of data, the Combo chart is perfect.

Correct AnswerverifiedShow Answer

Match the following terms with their description: i. Chart element II. Chart filter III. Chart sheet IV. Chart style v. Chart title

Correct AnswerverifiedShow Answer

Match the following terms with their description: i. Line chart II. Pie chart III. Bar chart IV. Column chart v. Sparkline

Correct AnswerverifiedShow Answer

A 100% stacked column chart is similar to which other chart in that it converts values to percentages?

Correct AnswerverifiedShow Answer

Picking a chart ________ will allow you to change several formatting elements at the same time.

Correct AnswerverifiedShow Answer

If you wanted to show trends over set periods of time, you probably want to use a(n) ________ chart.

Correct AnswerverifiedShow Answer

Which of the following is not true about trendlines?

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified