A cell reference that does not change when the formula is copied or moved to a new location. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A selected cell. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
Sorts alphabetically from A to Z and numerically from the lowest to the highest number. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
The box in a worksheet or table created by the intersection of row and column boundary lines. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
Identifies the column letter and row number (for example, A1 or B4). Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
Sorts alphabetically from Z to A and numerically from the highest to the lowest number. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A small square in the bottom right corner of an active cell in a worksheet. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
Equation used to calculate values in a spreadsheet cell. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A special formula that names a function instead of using operators to calculate a result. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
Labels at the top of columns in a worksheet. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
Combine multiple cells into a single cell. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A cell reference that contains both relative and absolute cell refernences. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A number or cell reference in a spreadsheet formula. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A symbol that tells Excel what mathematical operation to perform in a spreadsheet formula. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
The sequence used to calculate the value of a complex formula. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A selected group of cells. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A cell reference that is adjusted when the formula is copied or moved to a new location. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A grid of rows and columns containing numbers, text, and formulas. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet
A spreadsheet. Vocabulary Words
Order of Evaluation
Merge
Header Row
Absolute Cell References
Mixed Cell References
Operator
Function Formula
Relative Cell References
Operand
Worksheet
Range
Ascending Order
Active Cell
Descending Order
Formula
Cell Reference
Fill Handle
Cell
Spreadsheet