Deck 7: Excel : Charts

Question 1

Which of the following is not a chart type?

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

Answer 1

A

Question 2

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

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

Answer 2

A

Question 3

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

Answer 3

C

Question 4

Where does Excel display the Quick Analysis tool?

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

Question 5

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 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

Which of the following is not a chart element?

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

Question 8

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 9

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 10

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

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

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 tab displays the tools for creating charts?

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

Question 13

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

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

Question 14

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 15

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 16

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

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

Question 17

How many variations of the stock chart does Excel have?

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

Question 18

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

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

Question 19

Which of the following is not a chart element?

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

Question 20

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 21

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 22

Where does the primary axis display on a Combo chart?

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

Question 23

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

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

Question 24

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

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

Question 25

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 26

In a bar chart, which axis displays the categories?

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

Question 27

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 28

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

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

Question 29

Which chart type displays the data vertically?

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

Question 30

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

Question 31

Which chart type displays the data horizontally?

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

Question 32

What icon is not displayed when you select a chart?

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

Question 33

What is not found on the Chart Elements List?

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

Question 34

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

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

Question 35

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 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

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 38

Which chart type cannot be displayed as a sparkline?

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

Question 39

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 40

How many sizing handle are found on embedded charts?

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

Question 41

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

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

The ________ is the visual key to a chart.

Question 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

A bar chart uses ________ bars.

Question 56

In a column chart the horizontal axis displays the ________.

Question 57

The ________ axis is the vertical axis.

Question 58

A data ________ is a group of related data points.

Question 59

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

Question 60

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

Question 61

In rare cases you can chart text entries.

Question 62

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

Question 63

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

Question 64

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 65

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

Question 66

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

Question 67

In a stacked column chart the data must be ________.

Question 68

You cannot enter data or formulas on a chart sheet.

Question 69

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

Question 70

Sparklines do not include the normal chart labels.

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

Pie charts can only display one data series.

Question 80

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