Deck 8: Excell: Charts

Question 1

Which of the following is not a chart element?

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

Answer 1

D

Question 2

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.

Answer 2

A

Question 3

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

Answer 3

C

Question 4

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

A) x-axis
B) z-axis
C) category axis
D) value axis

Question 5

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

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

Question 6

Which of the following is not true about trendlines?

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.

Question 7

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

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

Question 8

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

A) category axis
B) value axis
C) z-axis
D) y-axis

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 true about sizing handles?

A) They appear as circles.
B) There are 8 of them for any object.
C) They allow you to make objects larger or smaller.
D) They always maintain the proper aspect ratio for the object.

Question 11

Which of the following, when included, 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 12

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

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

Question 13

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 14

Which of the following is not a chart type?

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

Question 15

Where does the primary axis display on a Combo chart?

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

Question 16

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

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

Question 17

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

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

Question 18

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 19

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

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

Question 20

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

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

Question 21

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

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

Question 22

Which chart type cannot be displayed as a sparkline?

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

Question 23

Which of the following is not a chart element?

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

Question 24

What icon is not displayed when you select a chart?

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

Question 25

How many sizing handles are found on embedded charts?

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

Question 26

In a bar chart, which axis displays the categories?

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

Question 27

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 has already been chosen.

Question 28

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 29

In rare cases you can chart text entries.

Question 30

What is not found on the Chart Elements List?

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

Question 31

The plot area is surrounded by how many axes?

A) 1
B) 2
C) 3
D) It depends on the chart type selected.

Question 32

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 33

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 has already been chosen.

Question 34

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 35

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

Question 36

Which chart type displays the data vertically?

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

Question 37

Which chart type displays the data horizontally?

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

Question 38

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 39

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

Question 40

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

Question 41

Pie charts can only display one data series.

Question 42

A chart style effects the formatting of the chart itself, but not the chart data.

Question 43

Effective charts never overwhelm an audience.

Question 44

The Chart Styles gallery displays style options for the selected chart only.

Question 45

You can link to a cell as the title of a chart.

Question 46

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

Question 47

Once a data source is selected for a chart, the only way to change the data source is to start over creating the chart.

Question 48

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

Question 49

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

Question 50

You can enter data or formulas on a chart sheet.

Question 51

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

Question 52

The range used for a sparkline can include more than one row.

Question 53

You can switch the rows and columns in a chart to communicate a different perspective on your data.

Question 54

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

Question 55

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

Question 56

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

Question 57

A stacked column chart displays multiple columns for each category.

Question 58

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

Question 59

When you are creating a chart, it is important to select parallel ranges.

Question 60

To understand a chart, you need to include the chart data.

Question 61

In a ________ column chart the data must be additive.

Question 62

In a column chart the horizontal axis displays the ________.

Question 63

A bar chart uses ________ bars.

Question 64

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

Question 65

A data ________ is a group of related data points.

Question 66

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

Question 67

Sparklines do not include the normal chart labels.

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

Do not include data ________ (such as totals or averages) and individual values in the same chart.

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

The ________ is the visual key to a chart.

Question 79

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

Question 80

The ________ axis is the vertical axis.