|
Term
|
Definition
|
|
Active Cell
|
The ONE cell that is currently selected in the worksheet
|
|
Adjacent Range
|
A single rectangular block of cells
|
|
Arithmetic Operators
|
Symbols that indicate the type of calculation (arithmetic operation) to perform
|
|
AutoComplete
|
A feature in Excel that tries to anticipate the text you are typing and, if recognized, completes the word
|
|
AutoSum
|
A feature that quickly and conveniently enters the SUM function
|
|
Cell
|
The intersection of a column and row in a spreadsheet
|
|
Cell Range (range)
|
A group of worksheet cells which can be adjacent or nonadjacent
|
|
Cell Reference
|
The address of a cell which indicates its column and row
|
|
Column
|
Vertical blocks of cells in a worksheet
|
|
Documentation Sheet
|
A worksheet that provides information about the content and purpose of the workbook
|
|
Edit Mode
|
When a cell is double-clicked and is ready to be edited
|
|
Formula
|
An expression used to calculate a value
|
|
Formula view
|
A view where the formulas are displayed in the worksheet rather than the values
|
|
Formula Bar
|
The portion of the Workbook window that displays the formula in a cell
|
|
Function
|
A predefined formula that performs calculations using specific values
|
|
Landscape Orientation
|
Where the page is wider than it is tall
|
|
Name Box
|
The portion of the workbook window that displays the cell name
|
|
Nonadjacent Range
|
Two or more separate adjacent ranges
|
|
Order of Precedence
|
A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second, and so forth
|
|
Portrait Orientation
|
Where the page is taller than it is wide
|
|
Range reference
|
Indicates the location and size of a cell range
|
|
Rows
|
Horizontal blocks of cells in a worksheet
|
|
Spell Checker
|
A feature that checks the words in the workbook against the program’s internal dictionary
|
|
Spreadsheet
|
A business tool that helps you analyze and report data
|
|
SUM function
|
A function you enter in a worksheet to calculate the sum of value in a cell range
|
|
Values
|
Numbers that represent a quantity of some type
|
|
What-if analysis
|
A process whereby you change one or more of the values in the worksheet and then examine the recalculated values to determine the effect of the change
|
|
Workbook window
|
The document window that contains workbooks and is inside the program window
|
|
Workbooks
|
Documents that contain electronic spreadsheets
|
|
Worksheets
|
A single spreadsheet within a workbook
|
