Deck 3: Charts

Question 1

Where does Excel display the Quick Analysis tool?

A)Bottom-right corner
B)Top-right corner
C)Bottom-left corner
D)Top-left corner

Answer 1

A

Question 2

Which chart type is not listed in the All Charts window?

A)Treemap
B)Sparkline
C)Histogram
D)Waterfall

Answer 2

B

Question 3

In the Insert Chart dialog box, after you pick a chart type where are the subtypes listed?

A)Bottom left
B)Bottom right
C)Top left
D)Top right

Answer 3

D

Question 4

Which chart type is best when you want to chart two unrelated data types?

A)Pie chart
B)Combo chart
C)Line chart
D)Radar chart

Question 5

What is not a purpose of using an effective chart?

A)Compares data
B)Reveals trends and patterns
C)Reveals even subtle errors in formulas
D)Aids in making informed decisions

Question 6

What is not true about an effective chart?

A)It always contains more than one series.
B)It is clear.
C)It is easy to understand.
D)It is useful.

Question 7

What should you not select when selecting data for a chart?

A)Column labels
B)Row labels
C)Data
D)Worksheet titles

Question 8

Which of the following is not a chart type?

A)Circle
B)Pie
C)Bar
D)Line

Question 9

What chart type represents data as spokes going from the center to the outer edge of the chart?

A)Surface
B)Area
C)Radar
D)Histogram

Question 10

Which of the following is not a chart element?

A)Chart area
B)Plot area
C)Legend
D)Data area

Question 11

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

A)Clustered column
B)Radar
C)Line
D)Pie

Question 12

Which axis in a chart displays the descriptive labels for the data points?

A)Category
B)Value
C)Data
D)Series

Question 13

Where does the primary axis display on a Combo chart?

A)Top
B)Bottom
C)Right side
D)Left side

Question 14

Which chart type is preferable when the category names are long?

A)Column
B)Bar
C)Pie
D)Stacked column

Question 15

What is a disadvantage of a stacked column chart?

A)Segments do not start at the same point.
B)Segments do not end at the same point.
C)There is a limit as to how many segments can be displayed.
D)This is only useful for one data series.

Question 16

Which axis in a chart displays incremental numbers for the data points?

A)Category
B)Value
C)Data
D)Series

Question 17

Which tab displays the tools for creating charts?

A)View
B)Chart
C)Insert
D)Data

Question 18

As a general rule, Pie charts should be limited to how many slices?

A)5
B)7
C)9
D)11

Question 19

How many variations of the stock chart does Excel have?

A)1
B)2
C)3
D)4

Question 20

Including what, distorts the effectiveness of charting data points?

A)Too many series
B)Too many data points
C)Too much variance in the values of the data
D)Aggregates

Question 21

In the task pane, what does a diagonal white triangle next to a chart category indicate?

A)All the category's options are displayed.
B)None of the category's options are displayed.
C)There are no options for this category.
D)Every option for this category have already been chosen.

Question 22

What group is not found on the Sparkline Tools Design tab?

A)Format
B)Type
C)Show
D)Style

Question 23

In the task pane, what does a diagonal black triangle next to a chart category indicate?

A)All the category's options are displayed.
B)None of the category's options are displayed.
C)There are no options for this category.
D)Every option for this category have already been chosen.

Question 24

Which chart type is a visual "dashboard" of your data?

A)Bar chart
B)Sparkline
C)Line chart
D)Column chart

Question 25

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

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

Question 26

Which chart type cannot be displayed as a sparkline?

A)Bar chart
B)Line chart
C)Column
D)Win/Loss

Question 27

What icon is not displayed when you select a chart?

A)Chart Elements
B)Chart Types
C)Chart Styles
D)Chart Filters

Question 28

Which chart type displays the data horizontally?

A)Pie
B)Radar
C)Bar
D)Column

Question 29

In a pie chart which of the following is a good reason for using category data labels rather than the legend?

A)They reveal more information.
B)They take up less space.
C)They are easier to format.
D)They are easier to read.

Question 30

How many sizing handle are found on embedded charts?

A)4
B)6
C)8
D)10

Question 31

Which group on the Design tab would you select if you wanted to change the source information in the chart?

A)Series
B)Data
C)Format
D)Insert

Question 32

Which chart element cannot be chosen from the Chart Elements dialog box?

A)Axis Titles
B)Chart Title
C)Format Back Wall
D)Error Bars

Question 33

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

A)Combo
B)Combination
C)Mixed
D)Multiple

Question 34

What is not found on the Chart Elements List?

A)Chart Type
B)Data Table
C)Gridlines
D)Legend

Question 35

Which of the following is not a chart element?

A)Chart foreground
B)Chart title
C)Axis title
D)Gridlines

Question 36

What does Excel not determine about the value axis when you create a chart?

A)Incremental value
B)Start value
C)End value
D)Average value

Question 37

Which chart type displays the data vertically?

A)Pie
B)Radar
C)Bar
D)Column

Question 38

Which group on the Sparkline Tools Design tab would you choose if you wanted to change the data source of the sparkline?

A)Sparkline
B)Type
C)Show
D)Style

Question 39

In a bar chart, which axis displays the categories?

A)Horizontal
B)Vertical
C)X
D)Z

Question 40

What font color does Excel use by default for many of its elements?

A)Black, Text 1
B)Black, Text 1, Darker 35%
C)Black, Text 1, Lighter 35%
D)Black, Text 1, Lighter 50%

Question 41

A bar chart uses ________ bars.

Question 42

A group of data points used in a graph become a data ________.

Question 43

The ________ is the visual key to a chart.

Question 44

A(n)________ is a cell that contains a value used in a chart.

Question 45

When you point to a chart element Excel displays a(n)________ with the name of the element.

Question 46

To select nonadjacent ranges press and hold the ________ key while selecting the nonadjacent ranges.

Question 47

In a(n)________ column chart data appears as side by side columns.

Question 48

A(n)________ column chart displays the relationship of data points to the whole category.

Question 49

The ________ axis helps measure data from top to bottom in a chart.

Question 50

________ charts are often used to represent data in educational, scientific, and medical experiments.

Question 51

Column charts are the most effective when they have ________ or fewer categories.

Question 52

In a stacked column chart the data must be ________.

Question 53

A data ________ is a group of related data points.

Question 54

The ________ axis is the vertical axis.

Question 55

The ________ axis helps measure data from left to right in a graph.

Question 56

Do not use data ________ and individual values in a chart.

Question 57

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

Question 58

If you are not sure which chart type to pick, it may be helpful to click ________ Charts in the Chart group.

Question 59

In a column chart the horizontal axis displays the ________.

Question 60

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

Question 61

You might want to avoid using 3-D charts because they can distort the appearance of the data.

Question 62

Effective charts never overwhelm an audience.

Question 63

In a Chart Filter Excel uses a(n)________ to indicate which chart categories are displayed in a chart.

Question 64

A(n)________ is a type of chart which fits in one cell.

Question 65

When you create a chart Excel automatically creates the chart on its own sheet and labels it Chart1.

Question 66

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

Question 67

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

Question 68

A parallel range is one that consists of the same starting point of another range, but can have a different end point.

Question 69

A chart sheet can hold, at most, two charts.

Question 70

If your chart is intended for presentation, as opposed to printing, you should use a(n)________ background.

Question 71

Including the column and row labels in a chart makes the chart harder to understand.

Question 72

To switch to a different chart type after the chart has been created you use the Switch Chart Type tool.

Question 73

In rare cases you can chart text entries.

Question 74

A stacked column chart displays multiple columns for each category.

Question 75

It is important to select parallel ranges.

Question 76

You cannot enter data or formulas on a chart sheet.

Question 77

When you want to create a chart you first need to select a data ________.

Question 78

Excel uses ________ to determine what categories are visible in a chart.

Question 79

It is good practice to delete any blank rows or columns before creating a chart.

Question 80

Pie charts can only display one data series.