Chart Terms
Chart Types
Misc. Chart Features
Table Terms
Table Features
100
A graphic or visual representation of data.
What is a chart?
100
A chart with a horizontal orientation that compares categories; useful when categorical labels are long.
What is a Bar chart?
100
A chart that separates one or more slices of the pie for emphasis.
What is an exploded pie chart.
100
Facts about a specific record or sets of records.
What is data?
100
Setting up a condition that displays a subset of data meeting your specifications.
What is a filter?
200
A numeric value that describes a single item on a chart.
What is data point?
200
A chart that uses a line to connect data points in order to show trends over a long period of time.
What is a Line chart?
200
A chart subtype that portrays the chart on an angle which adds an additional axis.
What is 3D?
200
An item referring to an individual item in a record.
What is a field?
200
The action that arranges records in a table by the value of one or more fields within a table.
What is Sorting?
300
A group of related data points that appear in row(s) or column(s) in the worksheet.
What is a data series?
300
A chart that is the most effective way to display proportional relationships.
What is a Pie chart?
300
The name of the location of a chart inserted as an object in a worksheet.
What is an embedded chart?
300
A collection of fields referring to a student, client, etc.
What is a record?
300
The process of making rows, columns, and sheets invisible.
What is hiding?
400
The area containing the graphical representation of the values in a data series.
What is a Plot area?
400
A chart that shows a relationship between two variables.
What is Scatter (XY) chart?
400
A chart that appears in a separate sheet from the worksheet data.
What is a chart sheet?
400
Data that have been arranged or processed to view in some usable form.
What is information?
400
The command that shows you where page breaks currently occur and gives you the opportunity to change where the page breaks occur when a worksheet is printed.
What is Page Break Preview?
500
The axis that depicts categorical labels.
What is an X or horizontal axis?
500
A chart that shows the high, low, and close prices for individual stocks over a period of time.
What is a Stock chart?
500
A chart that places (stacks) data in with each data series a different color for each category.
What is a stacked column chart?
500
An area in a worksheet that contains rows and columns of similar or related information.
What is a Table?
500
The process of displaying column labels at the top of the 2nd printed page.
What is Rows to repeat at the top
M
e
n
u