Operations
Basics
Advancements
Components
Formatting
100
A sort is used to arrange data in alphabetical or chronological order.
What is a sort?
100
A workbook is a file that contains one or more spreadsheets.
What is a workbook?
100
Used in business to communicate and clarify information.
What is a chart and a graph used for?
100
Charts and graphs are used in businesses to communicate and clarify spreadsheet information.
What is the purpose of charts and graphs?
100
Formatting is applied to spreadsheet components for the purpose of organizing and classifying information.
What is formatting?
200
a primary sort indicates the primary sort range of data.
What is a primary sort?
200
A spreadsheet is an arrangement of cells in columns or rows used to organize, analyze,calculate,and report information,usually in numerical form.
What is a spreadsheet?
200
Represents different departments of a store.
What is a sales trend?
200
It it to represent trends within different departments of a store.
What is an example of a chart graph?
200
Justification is used to format cell data for the purpose of clarifying and organizing information.
What is justification?
300
A secondary sort is a sort that indicates the next sort range of data.
What is a secondary sort?
300
A cell is an individual location on a spreadsheet.
What is a cell?
300
Used in a graph to indicate data values.
What is a data marker?
300
Graph -The y-axis is: -The x-axis is: -Data markers are: etc.
What is a component of a chart and graph?
300
Values should be formatted uniformly, such as, using two decimal places for all like data, or using currency for total amounts.
What is a value?
400
Freezing Panes allow users to work in multiple areas in a large spreadsheet and focus the view on specific cell ranges.
What is a freezing pane?
400
A specific location. -It is the column letter and row number. -the cell address is also called the cell reference.
What is a cell address?
400
A collection of related values, such as one row or one column form a spreadsheet.
What is a data series?
400
Chart -A legend is: -A data label is: -A chart title is: etc.
What is a component of a graph?
400
To add identifying information to a spreadsheet.
What is a header and a footer used for?
500
Fill series are used to fill a column row with consecutive data.
What is a fill series?
500
A group of adjacent cells. -A range is a group/block of cells.
What is a cell range?
500
An object the explains the symbol, colors, or patterns used to differentiate the data.
What is a legend?
500
1.A column chart is used to make: 2.A stacked bar chart is used to make: etc.
What is a common chart used in a business?
500
To clarify information by adding emphasis to titles, column headings, and grand totals, etc. Can also change the font type and color.
What is a font size and style used for?
M
e
n
u