Category 1
Category 2
Category 3
Category 4
Category 5
100
Cell value remains static when copied to other locations.
What is Absolute?
100
Used to fill a column or row with consecutive data.
What is Fill Series?
100
Cells formatted as labels.
What is Left Justification?
100
Alphabetical or chronological order.
What is Sort?
100
A4
What is Cell Address?
200
Format applied to titles and column headings.
What is Center Justification?
200
Parentheses
What is First Order of Operations?
200
Used to combine two or more cells.
What is Merge?
200
Spreadsheet linked to Target.
What is Source?
200
/
What is Division
300
Tell the function how to calculate the results and what data to be used.
What is Conditions or Criteria?
300
Begins with = and is used in mathematical calculations.
What is Formula?
300
How calculations are performed.
What is Order of operations?
300
Multiplication and Division (from left to right)
What is Third Order of Operations?
300
-
What is Subtraction?
400
Altering Column, Rows, and cell data.
What is Editing?
400
Allows user to work in multiple areas of a large spreadsheet and focus on specific cell ranges.
What is Freeze Panes?
400
Controls the Order of Operations.
What is Parentheses?
400
Word Processing Document.
What is Target?
400
*
What is Multiplication?
500
Spreadsheets that is converted into a graphic image when paced in a target.
What is Embedded?
500
Addition and subtraction (from left to right).
What is Fourth Order of Operations?
500
Exponents.
What is Second Order of Operations?
500
+
What is Addition?
500
Format applied to cell data to emphasize subcategories.
What is Indent?
M
e
n
u