Show:
Category 1
Category 2
Category 3
Category 4
Category 5
100
A file which contains one or more spreadsheets.
What is Workbook?
100
An arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.
What is Spreadsheet?
100
Cell A4 refers to one specific location.
What is Cell Address?
100
A4:A16 refers to a group of adjacent cells.
What is Cell Range?
100
All the contents in a vertical range of cells in Column A.
What is Column?
200
Row 3 refers to all of the contents in a horizontal range of cells on Row 3.
What is Row?
200
Cells that contain text or for numbers that will not be used in calculations?
What is Label?
200
Classification indicates that the data has the potential to be used in calculations.
What is Value?
200
Instructs the software to perform a calculation.
What is Formula?
200
Formulas begin with an
What is Equal Sign?
300
Calculations are performed according to the
What is Order of Operations?
300
A shortcut for a formula.
What is Basic Function?
300
Indicates a cell's location and provides instructions for how cell data is copied or used in calculations.
What is Cell Reference?
300
Cell value changes as the formula is copied.
What is Relative?
300
Cell value remains static when copied to other locations.
What is Absolute?
400
Combination of an absolute and a relative cell.
What is Mixed?
400
Control the Order of Operations.
What is Parentheses?
400
Tell the function how to calculate the results and what data to use.
What is Conditions?
400
Adds the range of cells from C4 through C18.
What is Sum?
400
Determines the average of the range of cells from C4 through C18.
What is Average?
500
Finds the highest number in the range of cells.
What is Maximum?
500
Finds the lowest number in the range of cells.
What is Minimum?
500
Organizing and clarifying information.
What is Formatting?
500
Can be used to apply global formats.
What is Format Painter?
500
By default, cells formatted as labels are _____ justified.
What is Left?