Show:
Spreadsheet Vocab 1
Spreadsheet Charting Vocab
Spreadsheet Vocab 2
Spreadsheet Charting Vocab 2
100
allows you to display only those rows that meet the criteria you specify for a column of data.
What is a filter?
100
a visual display of data in a spreadsheet, also known as a graph
What is a chart?
100
The cell ready for data entry.
What is an active cell?
100
Horizontal or vertical line that extends across the plot area of the chart to make it easier to read or understand.
What is a gridline?
200
Text, symbol, date, or number not used in calculations.
What is a label?
200
The object that explains the symbols, colors, or patterns used to differentiate the series in the chart.
What is a legend?
200
a program that allows you to use rows and columns of data to manage, predict, and present information.
What is a spreadsheet?
200
chart that only shows one data series and is used to compare sizes of each part of the whole or percentage.
What is a pie chart?
300
To arrange data in a column in a particular order (ascending/descending)
What is sort?
300
category axis that describes what is shown in the chart.
What is the x-axis?
300
Equations with symbols for mathematical operations, usually begins with equal signs. Ex =B6+B7
What is a formula?
300
object that represents the individual values; marker can be on a bar, column, etc.
What is a data marker?
400
A number entered into a spreadsheet cell that will be used for calculations.
What is value?
400
single value or piece of data from the data series.
What is a data point?
400
Identified by numbers on the left side of the spreadsheet. (horizontal)
What is a row?
400
the value axis that shows the range of values (or scale) of the chart
What is the y-axis?
500
Intersection of row and a column and identified by a cell reference
What is a cell?
500
The rectangular area bound by the category and values axes.
What is the plot area?
500
Identified by letters that appear at the top of the spreadsheet. (Vertical)
What is a column?
500
Small line or marker on the x-axis and y-axis to help in reading the values
What is a tick mark?