Lesson 8 Final Lesson: Excel
Data Marker
A Symbol (such as a bar, line, dot, slice and so forth) that represents a single data point or value from the corresponding worksheet cell.
Pie
A ______ chart is represented by a circle divided into portions.
Chart Layout
A _________ specifies which elements are included in a chart and their locations
Column Chart
A __________ shows relationships between categories of data
Line Chart
A ____________ illustrates change over time.
Scatter Chart
A ____________ shows the relationship between two categories of data, creating data points that are unrelated to each other.
Embedded chart
A chart inserted in the center of the worksheet.
Scatter chart
A chart that shows the relationship between two categories of data; sometimes called XY chart.
Pie Chart
A chart that shows the relationship of a part of a whole.
Line Chat
A chart that uses points connected by a line to illustrate values in a worksheet.
Column Chart
A chart uses bars of varying heights to illustrate values in a worksheet.
Data table
A grid that displays the data plotted in the chart.
Data Series
A group of related information in a column or row of a worksheet that is plotted on the chart.
Axis
A horizontal or vertical line taht establishes the relationship between data in a chart
Legend
A list that identifies patterns, symbols or colors used in a chart.
Sparkline
A mini chart you can insert into a cell.
Exploded Pie Chart
A pie chart with one or more slices pulled away from the pie to distinguish them.
Chart sheet
A separate sheet in the workbook that stores a chart
True
A sparkline is a mini chart that is inserted within a cell.
Chart
A visual representation of numerical data which can be in the form of lines, bars, wedges in pies, or other graphics.
True
After you create a chart you can change the chart type or subtype.
Chart layout
An arrangement that specifies which elements are included in a chart and where they are placed.
Chart Style
Formatting applied to a chart based on the colors, fonts and effects associated with the workbook's theme.
Embedded Chart
In a _____________ the shows the patterns or symbols that identify the different types of data.
True
T or F An embedded chart can be moved and resized.
True
T or F: Charts are a graphical representation of data
Data Label
Text or numbers that provide additional information about a data marker.
Data source
The chart data stored in a range of cells in the worksheet.
Chart area
The entire chart and all other chart elements.
Plot area
The graphical representation of all of the data series.
False
When the data source changes, charts created from that data do not change.