Deck 3: Determining Effective Data Display with Charts

Question 1

You must make changes to the content of data labels using buttons in the Format Data Labels task pane.

Answer 1

True

Question 2

Data series are points in a data set at which the x-axis and y-axis values intersect.

Answer 2

False

Question 3

The Description options on the Chart Elements menu control the display and placement of the chart legend.

Answer 3

False

Question 4

An X Y (Scatter) chart plots numeric values on both the x- and y-axes based on the value of the data.

Question 5

A line chart plots numeric values on one axis and category labels equidistantly on the other axis.

Question 6

In a line chart, values are indicated by the filled areas below the lines.

Question 7

The design of statistical graphics is the combined use of points, lines, numbers, words, shading, and color to present quantitative information.

Question 8

In business, charts are typically used to summarize information so that it can be used by one person making a decision.

Question 9

Tufte's first principle, "Above all else show the data," is a reminder to show as large a range of data as possible.

Question 10

Use a pie chart when it's most important to show relative percentages rather than values.

Question 11

The Alternative Data task pane, which is available from the shortcut menu for a selected chart, provides options for modifying the values used to generate a chart.

Question 12

A data series is composed of related data points that are plotted on a chart.

Question 13

Charts can successfully organize a large collection of numbers, make comparisons between different parts of the data, and tell a story.

Question 14

Microsoft Excel charts provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

Question 15

The Switch Row/Column button provides settings for swapping a data series between rows or columns.

Question 16

The values in a bubble chart type are indicated by the distance from a center point.

Question 17

As a general rule, you should place charts that are developed for presentation and printing on a chart sheet.

Question 18

To compare the contribution each value in a single data series makes to the whole, or 100%, use a pie chart.

Question 19

Bar and column charts are commonly used to compare values across categories.

Question 20

Use the Trendline options on the Chart Elements menu to specify whether the x- and y-axes are displayed.

Question 21

In a worksheet, you can add up the stock traded during the month by using the ADD function.
_________________________

Question 22

When tracking stock prices, the term crawling average is used because the average is calculated each day for the last 30 days-moving the average along the chart.
_________________________

Question 23

Microsoft Excel ____ provide a visual representation of quantitative information, giving the viewer an overall picture of a set of data.

A) charts
B) spreadsheets
C) tables
D) worksheets

Question 24

Any changes to the data label content must be made using the Format Data Labels task pane. _________________________

Question 25

Excel offers two pie chart sub-types, Pie of Pie and Bar of Bar, that can be used to combine many smaller segments of a pie chart into a separate smaller chart. ________________________

Question 26

Use the Label options on the Chart Elements menu to display a table of values for each data series in a grid below the chart. _________________________

Question 27

Bubble charts allow three-dimensional data to be plotted in three dimensions on two axes. _________________________

Question 28

____ identify the data values plotted on the y-axis.

A) Chart titles
B) Chart legends
C) Y-axis labels
D) X-axis labels

Question 29

Excel datalines are small, word-sized graphics placed within the images or words they represent. _________________________

Question 30

Radar charts are named for their resemblance to the plots on radar screens as they scan a 360-degree circle. _________________________

Question 31

The ____ is the vertical axis where data values are plotted.

A) chart title
B) chart legend
C) y-axis
D) x-axis

Question 32

Layered charts are known for doing a good job of illustrating the cumulative effects of data in categories. _________________________

Question 33

In a worksheet, the MAX and MIN functions can be used to take care of the highest and lowest stock price, respectively, for each month. _________________________

Question 34

The ____ is the descriptive text that identifies the chart's contents.

A) chart title
B) chart legend
C) x-axis label
D) y-axis label

Question 35

The ____ is the horizontal axis where categories are plotted.

A) chart title
B) chart legend
C) y-axis
D) x-axis

Question 36

Excel provides 10 standard chart types, with 53 sub-types that can be used to present
information graphically. _________________________

Question 37

Regresslines graphically illustrate trends in the data using a statistical technique known as regression. _________________________

Question 38

The chart title is the descriptive text that identifies the chart's contents.
_________________________

Question 39

A management console shows a visual summary of various performance data that a company's managers use on a regular basis. _________________________

Question 40

The Data Labels category found on the Chart Elements menu provides options for changing the information the label displays as well as the label position. _________________________

Question 41

____ are the related data points that are plotted on the chart.

A) Data series
B) Data points
C) Legends
D) Chart titles

Question 42

The purpose of formatting is to make a chart ____.

A) easier for the viewer to understand
B) compact
C) colorful
D) contain as much data as possible

Question 43

____ is a part of the chart that decorates more than informs.

A) Non-data-ink
B) Data-ink
C) Legend-ink
D) none of the above

Question 44

To create a chart in Excel, you first select the data you want to display in the chart, and then click the ____ tab on the ribbon.

A) VIEW
B) FORMULAS
C) DATA
D) INSERT

Question 45

According to Tufte, ____ can make charts difficult to read, use, and interpret.

A) data ink
B) chart legends
C) chart junk
D) chart labels

Question 46

____ are the points in a data series at which the x-axis and y-axis values intersect.

A) Data series
B) Data points
C) Legends
D) Chart titles

Question 47

Charts can be embedded as a(n) ____ on the same worksheet as the source data for the chart.

A) function
B) icon
C) comment
D) object

Question 48

In a ____ chart, values are indicated by the size of the slices.

A) column
B) line
C) pie
D) radar

Question 49

Charts can be placed on a separate worksheet that is referred to as a ____.

A) chart sheet
B) cheat sheet
C) worksheet
D) chart page

Question 50

In a ____ chart, values are indicated by the distance from a center point.

A) column
B) line
C) pie
D) radar

Question 51

In a(n) ____ chart, values are indicated by the height of the columns.

A) column
B) area
C) pie
D) radar

Question 52

The ____ chart type displays stock price and volume trends over time.

A) finance
B) stock
C) Wall Street
D) trader

Question 53

____ identify the categories plotted on the x-axis.

A) Chart titles
B) Chart legends
C) Y-axis labels
D) X-axis labels

Question 54

In the ____ chart type, values are indicated by areas with colors or patterns on the surface of the chart.

A) pattern
B) surface
C) scatter
D) doughnut

Question 55

A ____ is a word-sized chart embedded in context with the data it represents.

A) chart sub-type
B) line chart
C) chart
D) sparkline

Question 56

A ____ is a box that identifies the patterns or colors assigned to the data series in a chart.

A) data series
B) data point
C) legend
D) chart title

Question 57

In a ____ chart, values are indicated by the height of the lines.

A) column
B) line
C) pie
D) radar

Question 58

You can modify the location of a chart at any time using the _____ dialog box.

A) Modify Chart
B) Move Chart
C) Chart Elements
D) Edit Chart

Question 59

If the source data is dynamic, seeing the effect of the changes in a chart can be very handy. In this case, the chart should be placed ____.

A) on the worksheet with its data
B) on a worksheet separate from its data
C) in a new file
D) in separate workbooks

Question 60

An Excel chart requires ____ numeric data series in one chart.

A) two or more
B) at least one
C) x and y
D) none of the above; the number of data series and data points that Excel requires in a chart is only limited by the available computer memory and capacity

Question 61

When a chart is selected, two contextual chart tools appear on the ribbon, and they do NOT include ____.

A) DESIGN
B) FORMAT
C) EDIT
D) neither b nor c

Question 62

The ____ option of splitting a pie data series into a second, smaller pie chart assigns a specific number of values to the second plot.

A) Position
B) Value
C) Percent Value
D) Custom

Question 63

____ of the chart types have 3-D options, but these should be used with caution.

A) Few
B) Most
C) Only one
D) All

Question 64

The Chart Elements menu allows you to control the appearance of the ____.

A) legend
B) data labels
C) chart title and axis titles
D) all of the above

Question 65

A(n) ____ chart combines the features of a line chart with a bar or column chart by filling in the area below the line.

A) area
B) stacked
C) contrast
D) radar

Question 66

The Format Axis task pane allows you to control ____.

A) axes
B) gridlines
C) both a and b
D) neither a nor b

Question 67

The sum of the value of the categories must total ____ to use a pie chart.

A) 50%
B) 75%
C) 95%
D) 100%

Question 68

A ____ chart displays trends in three dimensions, with values in colored or patterned areas on the surface of the chart.

A) column
B) radar
C) bubble
D) surface

Question 69

To create a forward forecast in Excel, adding a ____ to a chart may reveal trends in the data.

A) linear trendline
B) sparkline
C) stock volume
D) stock price

Question 70

Clicking ____ a chart selects the chart.

A) anywhere in
B) outside of
C) on the chart title only in
D) on the data series only in

Question 71

A(n) ____ chart plots numeric values on both the x- and y-axes based on the value of the data.

A) X Y (Scatter)
B) line
C) column
D) bar

Question 72

A 100% stacked chart is similar to a ____ chart except that the pieces are in a column.

A) pie
B) line
C) bar
D) radar

Question 73

Stacked charts do a good job of illustrating the ____ effects of data in categories.

A) cumulative
B) individual
C) long-term
D) short-term

Question 74

The column chart's default column chart sub-type is the _____ sub-type.

A) stacked
B) clustered
C) high-low
D) 3-D

Question 75

Excel offers many formatting and display options for changing the layout of chart elements that can be found on the ____ when a chart is selected.

A) Chart Elements menu
B) CHART LAYOUT tab
C) TOOLS LAYOUT tab
D) FORMATTING tab

Question 76

____ charts all have a stacked chart sub-type.

A) Line
B) Column
C) Area
D) all of the above

Question 77

The pie chart has two chart sub-types, ____ and Bar of Pie, which are smaller charts that are displayed next to the original chart.

A) Pie of Pie
B) Column of Pie
C) Line of Pie
D) Table of Pie

Question 78

In the Format Data Labels task pane, use the options in the ____ category to specify the alignment (horizontal or vertical), orientation, position, and direction of the data labels.

A) Alignment
B) Size & Properties
C) Label Options
D) Effects

Question 79

To change the chart sub-type, click the Change Chart Type button in the ____ group on the CHART TOOLS DESIGN tab.

A) Type
B) Chart
C) Design
D) Format

Question 80

To change the source data, click the Switch Row/Column button in the Data group on the CHART TOOLS ____ tab to open the Select Data Source dialog box.

A) LAYOUT
B) FORMAT
C) EDIT
D) DESIGN