Deck 16: Using Advanced Chart Features

Question 1

Select the data totals when selecting the data for creating a chart.

Answer 1

False

Question 2

A(n) legend can appear as numbers or text next to each data marker in the data series.

Answer 2

False

Question 3

The Switch Row/Column button is found on the ____ tab.

A) Design
B) Layout
C) Format
D) Graph

Answer 3

A

Question 4

A ____ is a list that shows the colors and symbols used in a chart.

A) data table
B) data marker
C) table of contents
D) legend

Question 5

The data table used to create a chart appears above the chart.

Question 6

Charts are easy to make but difficult to format.

Question 7

You can create a sparkline for each row or column of data within a worksheet.

Question 8

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

Question 9

The type of chart you choose determines how the data in the rows and columns will appear in the chart.

Question 10

A(n) data table displays the data used to create a chart.

Question 11

The horizontal axis of a chart is called the ____.

A) a-axis
B) b-axis
C) x-axis
D) y-axis

Question 12

To delete the legend from a chart, click the legend and then press Delete.

Question 13

The vertical axis of a chart is called the ____.

A) a-axis
B) b-axis
C) x-axis
D) y-axis

Question 14

Chart templates are saved in the same default location as the preformatted chart templates.

Question 15

Each line of data in a line chart is a(n) ____.

A) data marker
B) data series
C) data label
D) data axis

Question 16

The Charts group, which allows you to create a chart, is found on the Insert tab on the Ribbon.

Question 17

Adding data labels allows you to see the value for each data marker in the chart.

Question 18

On the Format tab in the Labels group, click Chart Title, and then click Above Chart to add a chart title above the chart.

Question 19

Once you create a chart, it cannot be changed to another type of chart.

Question 20

The y-axis on the left side of a combination chart is called the secondary axis.

Question 21

Case EX 10-2 George is managing the fundraising efforts of a non-profit organization that provides services to the homeless. George is very proud of his performance because he has been able to make great progress in meeting the organization's fundraising goals. He can use a ____ chart to showcase the amount of progress accomplished so far.

A) combination
B) comparison
C) gauge
D) tracking

Question 22

The Format Painter button is found on the Clipboard group on the ____ tab.

A) Home
B) Insert
C) Page Layout
D) View

Question 23

When you press F11, Excel generates a chart with ____ data series.

A) primary
B) secondary
C) linear
D) column

Question 24

You can copy and paste formats from one label to another using the Format ____ feature.

A) Duplicator
B) Painter
C) Replicator
D) Copier

Question 25

To instantly create a chart in its own chart sheet, simply select the range of data you want in the chart and press ____.

A) F3
B) F5
C) F7
D) F11

Question 26

The Save As Template command is found on the ____ tab.

A) Home
B) Design
C) Layout
D) Format

Question 27

Case EX 10-2 George is managing the fundraising efforts of a non-profit organization that provides services to the homeless. George does not want any lines showing within the chart that he creates. He needs to remove the horizontal and vertical ____.

A) sparklines
B) markers
C) axes
D) gridlines

Question 28

Excel has three types of sparklines: Line, Win/Loss, and ____.

A) Pie
B) Cylinder
C) Progress
D) Column

Question 29

If you select the ____ feature, all data points on the sparklines will be highlighted.

A) Highlight
B) Show
C) Labels
D) Markers

Question 30

____ represent where the actual data would be in the chart.

A) Data lines
B) Data markers
C) Chart metas
D) Chart legends

Question 31

A gauge chart is also called a ____ chart.

A) progress
B) combinational
C) sparkline
D) pie

Question 32

A chart that shows data on two y-axes for the purpose of showing different data is called a ____ chart.

A) combination
B) compound
C) sparkline
D) gauge

Question 33

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. If Stephanie wants to display a miniature chart next to each row of her worksheet that will reflect the net profit or loss, she can create ____.

A) legends
B) data sheets
C) data markers
D) sparklines

Question 34

Sparklines are displayed ____.

A) above the chart
B) below the chart
C) next to the data they represent
D) in the middle of the chart

Question 35

A(n) ____________________ lets you quickly view the worksheet data while looking at the chart data series.

Question 36

FIGURE EX 10-1 In Figure EX 10-1 above, item 2 points to the ____.

A) sparklines
B) gauge table
C) data table
D) data series

Question 37

A ____ is a miniature chart that can be displayed in a single row or column of data.

A) legend
B) data marker
C) sparkline
D) chart meta

Question 38

When making a chart with two y-axes, you will need to use a ____ data series.

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

Question 39

FIGURE EX 10-1 In Figure EX 10-1 above, item 1 points to the ____.

A) legend
B) data markers
C) data table
D) data series

Question 40

Case EX 10-1 Stephanie is the owner of a boutique store in downtown Chicago. She has been using Excel to keep track of the sales and costs for each month for her store. Stephanie has created a line chart from her data. If she wants to add the actual data values to the chart, she can insert ____.

A) sparklines
B) data labels
C) data series
D) data table

Question 41

Discuss the situations in which you would choose a combination chart and the situations in which you would choose a gauge chart.

Question 42

A(n) ____________________ chart shows the amount of progress accomplished toward a goal.

Question 43

The horizontal lines within a chart are called the horizontal ____________________.

Question 44

The ____________________ is the foundation, or base, of a 3-D chart.

Question 46

You can have the high, low, first, and last points on a sparkline display with ____________________.