Microsoft Office 2013 Ch. 7 Review
What chart type shows trends of values over time
Area chart
T/F A chart pasted as a picture will automatically change if the source worksheet changes.
False
T/F All bar charts created in Excel have vertical bars
False
T/F All charts contain the same objects.
False
T/F Column, bar, and line are the only types of charts that can be created in Excel.
False
T/F Pie charts data labels must be displayed as percentages.
False
T/F The category axis is vertical
False
In Excel, a vertical bar chart is called what
Column chart
T/F A bar chart can only include one series of data.
False
A visual representation of worksheet data is called what
A chart
A chart is moved by dragging what
A chart border
A chart is sized proportionally by dragging what
A corner handle
What type of chart is best for comparing the differences between values
Bar
What type of chart would best illustrate a comparison of the number of employees in each department of a store
Bar
What chart object identifies each value in a data seies
Data labels
What is the portion of the worksheet to be charted called
Data range
The chart title does what
Describes what is charted
T/F Pie charts have axes.
Fase
In Excel, bar charts can have what to types of bars
Horizontal and vertical
What type of chart is best for displaying the differences of data over time
Line
What type of chart would best illustrate price fluctuations over a period of time for three stocks
Line
What is printed if a chart that appears as an object in a worksheet is selected before printing
Only the chart on a single sheet of paper in landscape orientation
What paste options command is selected to paste a chart as a graphic in a word document
Paste as a picture
In what kind of chart is each value from the series represented as a slice
Pie
What is not a type of sparkline
Pie
What type of chart is best for charting data that is a percentage of a whole
Pie
What type of chart would best illustrate each department's sales as a percentage of the overall store sales
Pie
What chart object is the part of the chart that displays data
Plot Area
A selected chart is deleted by doing what
Pressing the Delete key
What chart type shows changes in values relative to a center point
Radar chart
What is the first step in creating a pie chart
Select the data to be charted
The entire chart and all of its elements is referred to as what
The chart area
T/F A chart can be placed on a separate sheet in a workbook.
True
T/F A chart illustrates the relationship between data.
True
T/F A chart simplifies the understanding of numerical data.
True
T/F A pie chart only includes only one series of data.
True
T/F An adjacent data series is added to a selected chart by dragging a handle of the outlined original data series.
True
T/F Chart layout is the placement of objects on a chart.
True
T/F Charts created in excel can be copied to a Word document.
True
T/F Each Excel chart type has several subtypes
True
T/F The data range of a chart can include non-adjacent cells.
True
What chart type compares pairs of values
XY chart