Sorts
Freeze,Fill, and Print
Charts & Graphs
Charts & Graphs
Charts & Graphs
100
Used to arrange data in alphabetical or chronological order. Data can be sorted in ascending or descending order.
What is a sort?
100
Allows the user to work in multiple areas of a large spreadsheet and focus the view on specific cell ranges.
What is a freezing pane?
100
Used in business to communicate and clarify spreadsheet information.
What is graph and charts?
100
Emphasize and categorize spreadsheet information into a format that can be quickly and easily analyzed.
What is graphs and charts?
100
Used in a chart. Includes plot area, grid lines, and values.
What is a graph?
200
Indicates the next sort in a range of data in a spreadsheet. Also known as a multiple sort.
What is a secondary sort?
200
Used to create the continuation of a data series.
What is a fill handle?
200
The total package that includes: titles, values, axis labels, legend information, color, and adds meaning to the graph.
What is a chart?
200
Emphasizes and categories the spreadsheet information into a format that can be quickly and easily analyzed.
What is a chart?
200
Y-axis, X-axis, Data markers, Data series, Gridline, Plot area, Tick mark. These are the components of a ______.
What is the components of a graph?
300
Indicates the first sort range of data. Also known as a single sort.
What is a primary sort?
300
When the paper is taller than it is wide.
What is portrait style?
300
Is the left vertical side of the graph. It contains the numerical data.
What is the Y-axis?
300
Used in a graph to indicate data values.
What is a data marker?
300
Is the bottom horizontal side of the graph. It contains the category information
What is the X-axis?
400
Alphabetical Order = A-Z Numerical Order = 1-10
What is ascending order?
400
Used to fill a column or row with consecutive data.
What is a fill series?
400
Is a collection of related values, such as one row or one column from a spreadsheet.
What is a data series?
400
Is a horizontal or vertical line that extends across the plot area of the graph for the purpose of adding clarification to the data.
What is a grid line?
400
Is the background portion of a graph. It is the rectangular area bound by the category (X) and values (Y) axes.
What is the plot area?
500
Numerical Order = 10-1 Alphabetical Order = Z-A
What is descending order?
500
When the paper is wider than it is tall.
What is landscape style?
500
Is used in a graph to clarify the data categories or values.
What is a tick mark?
500
Is an object that explains the symbols, colors, or patterns used to differentiate the data
What is a legend?
500
Is a single value or text explanation used to explain the data in a series. It is a piece of data from the data series.
What is a data label?
M
e
n
u