Deck 13: Excel: Customize, Analyze, and Summarize Query Data

Question 1

The plot area

A) contains graphical representation of values in data series.
B) is a vertical line that borders the plot area to provide a frame of reference for measurement.
C) is a horizontal line that borders the plot area to provide a frame of reference for measurement.
D) provides descriptive group names for subdividing the data series.

Answer 1

A

Question 2

The category axis

A) compares two or more sets of data in one chart.
B) compares values for one set of data.
C) displays descriptive group names or labels, such as college names or cities, to identify data.
D) displays incremental values to identify the values of the data series.

Answer 2

C

Question 3

The X-axis

A) displays incremental values to identify the values of the data series.
B) provides descriptive group names for subdividing the data series.
C) is a horizontal line that borders the plot area to provide a frame of reference for measurement.
D) is a vertical line that borders the plot area to provide a frame of reference for measurement.

Answer 3

C

Question 4

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 text that describes a collection of data points in a chart.

Question 5

The value axis

A) displays incremental values to identify the values of the data series.
B) groups or clusters similar data in columns to compare values across categories.
C) compares two or more sets of data in one chart.
D) compares values for one set of data.

Question 6

A multiple data series chart

A) groups or clusters similar data in columns to compare values across categories.
B) compares two or more sets of data in one chart.
C) is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
D) 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.

Question 7

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 8

A 100% stacked column chart

A) uses a line to connect data points in order to show trends over a period of time.
B) places (stacks) data in one column per category, with each column having the same height of 100%.
C) compares values across categories using horizontal bars.
D) adds a third dimension to each data series, creating a distorted perspective of the data.

Question 9

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 10

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 11

A single data series

A) compares values for one set of data.
B) groups or clusters similar data in columns to compare values across categories.
C) is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
D) compares two or more sets of data in one chart.

Question 12

A clustered column chart

A) is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.
B) 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.
C) places (stacks) data in one column per category, with each column having the same height of 100%.
D) groups or clusters similar data in columns to compare values across categories.

Question 13

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 14

A line chart

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

Question 15

A 3-D chart

A) uses a line to connect data points in order to show trends over a period of time.
B) shows each data point in proportion to the whole data series as a slice in a circular pie.
C) compares values across categories using horizontal bars.
D) adds a third dimension to each data series, creating a distorted perspective of the data.

Question 16

A legend

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) places (stacks) data in one column per category, with each column having the same height of 100%.
D) is a key that identifies the color, gradient, picture, texture, or pattern fill assigned to each data series in a chart.

Question 17

Chapter 3 Customize, Analyze, and Summarize Query Data

A) is a group of related data points.
B) is a visual representation of numerical data.
C) is a numeric value that describes a single value on a chart.
D) is text that describes a collection of data points in a chart.

Question 18

A data series

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

Question 19

The chart area

A) contains graphical representation of values in data series.
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 20

A column chart

A) displays data comparisons vertically in columns.
B) is a horizontal line that borders the plot area to provide a frame of reference for measurement.
C) contains graphical representation of values in data series.
D) contains the entire chart and all of its elements.

Question 21

A stock chart

A) shows relationships among three values by using bubbles.
B) shows values as percentages of the whole but may contain more than one data series.
C) displays trends using two dimensions on a continuous curve.
D) can show the open, high, low, and close prices for individual stocks over time.

Question 22

An axis title

A) is a line used to depict trends and forecast future data.
B) is the value or name of a data point.
C) is a label that describes either the category axis or the value axis.
D) is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

Question 23

An exploded pie chart

A) shows the high, low, and close prices for individual stocks over time.
B) emphasizes magnitude of changes over time by filling in the space between lines with a color.
C) shows a relationship between two variables.
D) separates one or more pie slices from the rest of the pie chart.

Question 24

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 25

An area chart

A) shows the high, low, and close prices for individual stocks over time.
B) trends using two dimensions on a continuous curve.
C) emphasizes magnitude of changes over time by filling in the space between lines with a color.
D) shows a relationship between two variables.

Question 26

A chart sheet

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

Question 27

After creating a chart you can change the chart type by using

A) Page Layout tab / Chart Options button.
B) Design tab / Change Chart Type button.
C) Data tab / Chart Changer tool.
D) You cannot change the chart.

Question 28

To change the data source of a chart

A) change the numbers in the spread sheet.
B) use the Select Data Source dialog box from the Select Data button.
C) use a different chart type.
D) click Switch Row / Column in the Data group.

Question 29

To reverse the Data Series of a chart

A) change the numbers in the spread sheet.
B) use a different chart type.
C) use the Select Data Source dialog box from the Select Data button.
D) click Switch Row / Column in the Data group.

Question 30

A trendline

A) is a line used to depict trends and forecast future data.
B) is text that describes a collection of data points in a chart.
C) is a group of related data points.
D) displays data comparisons vertically in columns.

Question 31

A surface chart

A) displays values as percentages of the whole but may contain more than one data series.
B) displays relationships among three values by using bubbles.
C) displays trends using two dimensions on a continuous curve.
D) contains a single chart and no spreadsheet data.

Question 32

A chart title

A) is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.
B) is a label that describes the chart.
C) is a label that describes either the category axis or the value axis.
D) is the value or name of a data point.

Question 33

A gridline

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

Question 34

An X Y (scatter) chart

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

Question 35

A data label

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

Question 36

A handle, indicated by faint dots on the outside border of a selected chart

A) enables you to adjust the size of the chart.
B) is a label that describes either the category axis or the value axis.
C) is a miniature chart contained in a single cell.
D) is a label that describes the chart.

Question 37

A doughnut chart displays

A) enables you to adjust the size of the chart remotely.
B) relationships among three values by using bubbles.
C) contains a single chart and no spreadsheet data.
D) values as percentages of the whole but may contain more than one data series.

Question 38

A sparkline is

A) is a label that describes either the category axis or the value axis.
B) a miniature chart contained in a single cell.
C) is the value or name of a data point.
D) is a label that describes the chart.

Question 39

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs:

A) Design, Layout, and Format
B) Home, Insert, and Page Layout
C) Chart, Type, and Formulas
D) Data, Review, and Data

Question 40

A bubble chart shows

A) a single chart and no spreadsheet data.
B) you how to adjust the size of the chart using the mouse.
C) a miniature chart contained in a single cell.
D) relationships among three values by using bubbles.

Question 41

A chart is a visual representation of numerical data.

Question 42

For less formal presentations, you might want to demonstrate your creativity by using images or a texture to fill the data series, chart area, or plot area instead of a solid fill color.

Question 43

A chart is composed of only the chart area and labels. You cannot change it, only re-do it after it is created.

Question 44

A resizing handle, indicated by faint dots on the outside border of a selected chart, enables you to adjust the size of the chart.

Question 45

When you select a chart, Excel displays a Chart Tools contextual tab with three specific tabs: Design, Layout, and Format.

Question 46

The Chart Tools Layout tab enables you to enhance your charts by selecting specific chart elements, inserting objects, displaying or removing chart elements, customizing the axes, formatting the background, and including analysis.

Question 47

To change the data source of a chart use the Select Source dialog box from the Dialog\Numbers button.

Question 48

A chart layout determines which chart elements appear in the chart area and how they are positioned within the chart area.

Question 49

A sparkline includes all the chart titles and axes labels just like a regular chart.

Question 50

The default chart sheet name is sheett1, sheet2, etc.

Question 51

To reverse the Data Series of a chart click Switch Row / Column in the Data group.

Question 52

After creating a chart you can change the chart type by using Format tab / Change Chart Type button.

Question 53

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

Question 54

A chart sheet contains a single chart and no spreadsheet data.

Question 55

A data point is a letter or word that describes a single value on a chart.

Question 56

A sparkline is a small line, column, or win / loss chart contained in a single cell.

Question 57

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

Question 58

Just like for printing any worksheet data, preview the chart in Backstage view before you print to check margins, spacing, and page breaks to ensure a balanced printout.

Question 59

The Chart Styles group contains predefined styles that control the range of the data and the numbers in the chart.

Question 60

Labels on charts are not necessary because you can always tell what the chart means by the colors.

Question 61

You can rename a chart sheet before you click OK in the ________ Chart dialog box.

Question 62

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

Question 63

Before creating the chart, you must first define the starting, incremental, and stopping values that display on the value axis.

Question 64

Preview the chart in ________ view before you print to ensure a balanced printout.

Question 65

A gridline is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

Question 66

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

Question 67

Axes titles are labels that describe the category and value axes. If the names on the category axis are not self-explanatory, you can add a label to describe it.

Question 68

The Chart Layouts group enables you to apply ________ layouts to a chart.

Question 69

When choosing a chart ________, make sure it complements the chart data and is easy to read.

Question 70

Creating a chart involves selecting the data ________ and choosing the chart type.

Question 71

Excel displays the row labels in the first column on the ________ axis.

Question 72

A column ________ displays data comparisons vertically in columns.

Question 73

You can use trendlines in unstacked column, bar, line, stock, scatter, and bubble charts.

Question 74

A data ________ is a group of related data points.

Question 75

The Chart Tools Design ________ tab contains options to modify the overall chart design.

Question 76

To save a chart as a template, select the chart, click the ________ tab, and then click Save as Template in the Type group.

Question 77

To reverse the data series, click ________ Row / Column in the Data group.

Question 78

If you ________ a chart on the same sheet as the data source, you need to decide if you want to print the data only, the data and the chart, or the chart only.

Question 79

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

Question 80

When creating a chart, be sure that each data series uses the same ________.