CIS-110 - Chapter 16 Definitions
How do you update a chart after editing the chart data?
A chart is automatically updated when its data source is edited.
What is a column chart, and how is a bar chart different?
A column chart displays values in different categories as columns; the height of each column is based on its value. A bar chart is a column chart turned on its side so that the length of each bar is based on its value.
You can add or remove a chart title using the _____.
Chart Elements button
Which of the following is an advantage of overlaying chart elements?
It makes more space for the plot area.
Which of the following is a disadvantage of an embedded chart?
It might cover worksheet cells that hide data and formulas.
What are major units and minor units?
Major units identify the main intervals on a chart axis. Minor units identify smaller intervals between the major units.
What does it mean to overlay a chart title or legend?
Overlaying a chart title or legend means they are placed on top of the chart in the chart area.
When does the Chart Tools tab appear?
When you create a graph
Which of the following is a true statement about charts in Excel?
You can create custom chart types based on the built-in charts.
In what two locations can you place a chart?
You can place a chart in a worksheet as an embedded chart or you can place a chart into a chart sheet, which contains only the chart and no worksheet cells.
When should you use a line chart instead of a column chart?
You should use a line chart instead of a column chart when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals, as with historical data in which the data values are recorded periodically such as monthly, quarterly, or yearly.
Why would you change the scale of a chart axis?
You would change the scale of a chart axis to make the chart easier to read.
pie chart
a chart in the shape of a circle divided into slices like a pie that shows the data values as a percentage of the whole
combination chart
a chart that combines two or more chart types in a single graph, such as a column chart and a line chart
column chart
a chart that displays values in different categories as columns so that the height of each column is based on its value
line chart
a chart that displays values using a connected line rather than columns or bars
embedded chart
a chart that is an object in a worksheet
chart (graph)
a visual representation of a set of data values
chart element
an individual part of a chart
data marker
an object in a chart that represents a value in a data series, such as a pie slice or column
chart layout
an option for displaying and arranging chart elements
Which of the following is a function of chart layouts?
They specify which chart elements are displayed and how they are formatted.
How do you add a data series to an already existing chart?
To add a data series to an existing chart, select the chart, click the Select Data button in the Data group on the Chart Tools Design tab, click the Add button in the Select Data Source dialog box, click in the Series name box in the Edit Series dialog box, select the range with the new data series. Click OK in each dialog box.
data bar
conditional formatting that adds a horizontal bar to a cell's background that is proportional
Which of the following is an accurate statement about overlaying chart elements?
It allows you to drag a chart element to a new location.
In Microsoft Excel, which of the following is true of a chart legend?
It identifies each data series in a chart.
Identify a true statement about data source of pie charts.
It should not include the row or column totals.
Column and bar charts differ from pie charts in that bar charts:
apply to a wider range of data.
In Microsoft Excel 2016, charts are used to:
illustrate numbers.
data label
text for an individual data marker
plot area
the part of the chart that contains the graphical representation of the data series
scale
the range of values along an axis
data source
the range that contains the data to display in a chart
category values
the row or column of a data source that provides the descriptive labels for each data series
What is a combination chart? Describe how to create a combination chart.
A combination chart combines two or more chart types in a single graph, such as a column chart and a line chart. To create a combination chart, first select the data series in an existing chart that you want to appear as another chart type. Then, on the Chart Tools Design tab, in the Type group, click the Change Chart Type button, click the chart type you want to apply to the selected series, and then click OK.
What are data bars?
A data bar is conditional formatting that adds a horizontal bar to the background of a cell containing a number.
If a data series contains values divided into 10 categories, would this data be better displayed as a pie chart or a column chart? Why?
A data series that contains values divided into 10 categories would be better displayed as a column chart because a pie chart is more effective with six or fewer categories.
What is the difference between a data source and a data series?
A data source is the range that contains the data being displayed in a chart. A data source is a collection of one or more data series, which is a range of values that is plotted as a single unit on a chart.
What are sparklines? Describe the three types of sparklines.
A sparkline is a graph that is displayed within a cell. The three types of sparklines are line sparklines, column sparklines, and win/loss sparklines.
Which of the following is a method to move a chart from one worksheet to another in a Microsoft Excel workbook?
Cutting and pasting a chart to a new location in the workbook
How do data bars differ from sparklines?
Data bars differ from sparklines in that the bars are always placed in the cells containing the value they represent and each cell represents only a single bar from the bar chart. By contrast, a column sparkline can be inserted anywhere within the workbook and can represent data from several rows or columns.
Which of the following is a true statement about chart elements in Microsoft Excel?
Excel allows you to edit or replace the default chart title.
Which of the following describes a pie chart?
It compares relative values of different categories to the whole.
Which of the following describes a line chart?
It compares values from different categories.
Which of the following is true of a plot area in the chart?
It decreases its size to make room for the chart title when the chart area is small.
What is the difference between the chart area and the plot area?
The chart area contains the chart and all of the other chart elements. The plot area is the part of the chart that contains the graphical representation of the data series.
sparkline
a graph that is displayed entirely within a cell
In Microsoft Excel charts, which of the following is a function of leader lines?
They connect each data label to its corresponding data marker.
Which of the following is a difference between column charts and pie charts?
Unlike pie charts, column charts can represent more than one data series.
bar chart
a column chart that is turned on its side so that the length of each bar is based on its value
chart title
a descriptive label or name for the chart
exploded pie chart
a pie-chart where one slice is moved away from the pie
legend
a rectangular area that identifies the data markers associated with the data series
data series
a set of values represented in a chart
category
a set of values that represent data for one item in a chart
chart sheet
a sheet in a workbook that contains only a chart and no worksheet cells
chart style
a style that formats an entire chart at one time
gridlines
in a chart, lines that extend the values of the major or minor units across the plot area of a chart
In a pie chart, each pie slice always represents _____.
one data series value
data series values
the actual numbers plotted on a chart
chart area
the area that contains the chart and all of the other chart elements
horizontal (category) axis
the axis along the bottom of the chart that shows the category values from each data series
vertical (value) axis
the axis along the side of the chart that shows the range of values from all of the data series plotted on the chart