Deck 20: Excel : Charts: Depicting Data Visually

Question 1

Which of the following charts displays lines connecting data points to show trends over equal time periods?

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

Answer 1

C

Question 2

How can you identify sizing handles when you click a chart?

A)A Sizing Handles button displays on the Design tab.
B)A Sizing Handles button displays next to the chart.
C)They display as small,black triangles located on the corners of a selected chart.
D)They display as small,white-filled squares.

Answer 2

D

Question 3

Gridlines on a chart in Excel 2013 are:

A)numeric values that describe a single value on a chart.
B)lines used to depict trends and forecast future data.
C)horizontal or vertical lines that span across the chart.
D)a visual representation of numerical data.

Answer 3

C

Question 4

Which of the following is NOT one of most commonly used chart types?

A)X Y chart
B)Bar chart
C)Line chart
D)Pie chart

Question 5

A chart sheet:

A)is a label that describes the chart.
B)enables you to adjust the size of a chart.
C)contains a single chart and no spreadsheet data.
D)is a miniature chart contained in a single cell.

Question 6

A chart is:

A)a group of related data points in an Excel window.
B)a visual depiction of numerical data.
C)a set of numeric values shown on a worksheet.
D)text that describes a group of data points.

Question 7

The Y-axis:

A)is text that describes a collection of data points in a chart.
B)is a vertical line that borders the plot area to provide a frame of reference for measurement.
C)compares values for one set of data.
D)is a horizontal line that borders the plot area to provide a frame of reference for measurement.

Question 8

The chart area in Excel 2013:

A)is always a fill of a picture or a texture.
B)contains the entire chart and all of its elements.
C)is a vertical line that borders the plot area to provide a frame of reference for measurement.
D)is a horizontal line that borders the plot area to provide a frame of reference for measurement.

Question 9

A data label is:

A)a visual representation of numerical data.
B)the value or name of a data point.
C)a line used to depict trends and forecast future data.
D)a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

Question 10

A data point:

A)is a numeric value that describes a single value on a chart.
B)is a group of related data points.
C)displays data comparisons vertically in columns.
D)is a numeric value within a range of data.

Question 11

What is a data series in Excel 2013?

A)Data grouped into vertical columns
B)A group of related data points
C)Text that describes a group of data points in a chart
D)An entire chart and all of its elements on a Chart worksheet

Question 12

A category label:

A)contains the entire chart and all of its elements.
B)is text that describes a collection of data points in a chart.
C)displays data comparisons vertically in columns.
D)contains graphical representation of values in data series.

Question 13

An X Y (scatter)chart shows:

A)values as percentages of the whole but may contain more than one data series.
B)the high and low close prices for individual stocks over equal amounts of time.
C)the trend of two variables using a minimum of two dimensions on a continuous line.
D)a relationship between two variables.

Question 14

A(n)________ is a key that identifies the color,gradient,picture,texture,or pattern of each data series in a chart.

A)label
B)trendline
C)legend
D)axis

Question 15

Which of the following describes a line chart?

A)A line chart separates one or more pie slices from the rest of the pie chart.
B)A line chart shows each data point in proportion to the whole data series as a slice in a circular pie.
C)A line chart emphasizes magnitude of changes over time by filling in the space between lines with a color.
D)A line chart uses a line to connect data points in order to show trends over a period of time.

Question 16

A stacked column chart:

A)places stacks of data in segments on top of each other in one column,with each category in the data series represented by a different color.
B)adds a third dimension to each data series,creating a distorted perspective of the data.
C)compares values across categories using horizontal bars.
D)places (stacks)data in one column per category,with each column having the same height of 100%.

Question 17

A bar chart:

A)uses a line to connect data points in order to show trends over a period of time.
B)compares values across categories using horizontal bars.
C)shows each data point in proportion to the whole data series as a slice in a circular pie.
D)separates one or more pie slices from the rest of the pie chart.

Question 18

Axes titles are:

A)display on the X-axis by default.
B)the value or name of a data point on the X-axis.
C)not displayed by default.
D)descriptive labels that show exact values or name of a data point.

Question 19

To create a chart in Excel 2013,select the data and click the:

A)Chart tab.
B)Chart Elements button.
C)Quick Analysis button.
D)Chart Styles button.

Question 20

A pie chart:

A)shows a relationship between two variables.
B)separates one or more pie slices from the rest of the pie chart.
C)emphasizes magnitude of changes over time by filling in the space between lines with a color.
D)shows each data point in proportion to the whole data series as a slice in a circular pie.

Question 21

To begin creating sparklines on a worksheet,click the ________ tab.

A)Insert
B)Design
C)Chart Tools Design
D)Format

Question 22

By default,Excel inserts a chart on its own chart sheet.

Question 23

The ________ group on the Design tab is useful for adjusting the data source of a chart.

A)Chart Styles
B)Current Selection
C)Data
D)Chart Layouts

Question 24

Before you create a chart,you should delete any blank rows or columns in the primary data set from which you will create a chart.

Question 25

Excel 2013 automatically assigns a different pattern to each column of a clustered column chart.

Question 26

A chart filter in Excel 2013:

A)controls which charts are printed and which are visible on the screen of a workbook.
B)controls which data series and categories are visible in a chart.
C)displays a list of all charts in a workbook in order to select which charts you want to print.
D)displays all chart types and filters that are available for the data you want to present.

Question 27

Where does a sparkline display?

A)In a single cell
B)On a separate worksheet from the data
C)In a range below the data
D)Always to the right of the data

Question 28

Which of the following is NOT a task pane in Excel 2013 used to format a chart?

A)Format Chart Area
B)Format Plot Area
C)Format Data Series
D)Format Titles and Axes

Question 29

Which of the following is NOT controlled by choosing a chart style?

A)Color of the chart area
B)Sparklines
C)Plot area
D)Data series

Question 30

Which of the following is NOT a type of sparkline?

A)Bar
B)Line
C)Column
D)Win/loss

Question 31

A bar chart is one of the most common types of charts used in Excel.

Question 32

Which of the following is NOT a style that affects the look of a data series?

A)Flat
B)Stacked
C)3-D
D)Beveled

Question 33

Default chart sheet names include sheet1,sheet2,etc.

Question 34

When you update data in a worksheet,you must press F9 to update the data in the associated chart.

Question 35

A disadvantage of a stacked column chart is that the segments within each column do not start at the same point.

Question 36

The Chart Styles button is:

A)located on the right side of a chart.
B)located on the left side of a chart.
C)is accessed from the Insert tab.
D)on the Format tab.

Question 37

A column chart is most effective with four to eight categories that display.

Question 38

Which of the following is FALSE about sparklines?

A)Sparklines do not include an axis label.
B)Sparklines display in a single cell.
C)Sparklines include an automatically-created chart title.
D)Sparklines present a condensed,simple visual illustration of data.

Question 39

Sizing handles display as small,black-filled circles to resize a chart.

Question 40

Excel creates a chart on the same worksheet as the original data,but you can move the chart to its own chart sheet in the workbook.

Question 41

Axes,chart titles,and data tables are examples of chart elements.

Question 42

When you create a pie chart,Excel does not create a legend.

Question 43

A column sparkline could compare averages of prices or averages of test scores.

Question 44

A chart can be resized from the Format tab.

Question 45

The purpose of a sparkline is to present a complex chart on a full chart sheet.

Question 46

Excel automatically determines the starting,incremental,and stopping values on a chart based on the data selected.

Question 47

A(n)________ label is text that describes a collection of data points in a chart.

Question 48

If you embedded a chart on the same sheet as the data source,you cannot print the chart only.

Question 49

A gridline is a line used to depict trends and forecast future data.

Question 50

Excel includes the placeholder text Chart Title below a chart when you create the chart.

Question 51

In Excel 2013,Excel displays the ________ button in the bottom-right corner of a highlighted range.

Question 52

The ________ of a chart is a key that identifies each data series of the chart.

Question 53

The ________ of a chart is the region containing the graphical representation of the values in a data series.

Question 54

Displaying too much label content in a chart can clutter the chart.

Question 55

A specific chart style controls the color of the chart area as well as the plot area.

Question 56

The ________ of a chart is a horizontal border that provides a frame of reference for measuring data horizontally.

Question 57

A chart filter controls which data series and categories are visible on a chart in Excel.

Question 58

Pie charts often include percentage data labels.

Question 59

You can switch data used in a chart to create the horizontal axis and the legend.

Question 60

You can change the color scheme of a chart by clicking the Chart Styles button.

Question 61

A(n)________ is a grid that contains the data source values and labels.

Question 62

A(n)________ chart displays a proportion of individual data points to the sum of all points.

Question 63

A(n)________ is a line used to depict trends and forecast future data.

Question 64

A chart ________ is the label that describes the entire chart;it should reflect the purpose of the chart.

Question 65

The ________ group on the Sparkline Tools Design tab allows you to change the selected sparkline type.

Question 66

________ are small white-filled squares that display when a chart is selected.

Question 67

Sparklines can be created by clicking the ________ tab.

Question 68

A(n)________ column chart compares groups of columns set side by side for easy display.

Question 69

To print only a chart,select the chart,click the ________ tab,and click Print.

Question 70

A(n)________ chart displays values vertically where the height represents the value.

Question 71

A(n)________ is a worksheet that contains only a chart.

Question 72

A default chart sheet is named ________.

Question 73

When you hover the mouse pointer over a chart,Excel 2013 display a(n)________ with the name of that chart element.

Question 74

A chart ________ controls which data series and categories are visible in a chart.

Question 75

Applying a chart ________ allows you to change any number of formatting options such as the color of the chart area,the data,series,and the plot area.

Question 76

Excel creates charts on the same worksheet as the original data set,but you can ________ the chart to its own chart sheet.

Question 77

A(n)________ is a key that identifies the color,gradient,picture,texture,or pattern assigned to each data series.

Question 78

________ Styles add artistic style,text fill,and text effects to an object.

Question 79

A(n)________ chart is a derivative of a scatter chart in which both axes are value axes.

Question 80

To move a chart from one sheet to another,click the ________ tab and click Move Chart.