Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
18 Cards in this Set
- Front
- Back
|
Name box
|
Displays the address of the active cell. Located on the left end of the Formula bar.
|
|
|
Natural Language Formula
|
A formula that refers to column or row labels instead of the cell reference or range.
|
|
|
Numeric Label
|
A number entered in a cell as a label, not as a value.
|
|
|
Paste Function
|
A toolbar button that displays functions by category so you can enter arguments in the Formula Palette.
|
|
|
Range
|
A block of cells in an Excel worksheet.
|
|
|
Range Name
|
Identification assigned to a cell or a group of cells.
|
|
|
Value
|
A number entered in a cell
|
|
|
Worksheet
|
The work area for calculating data, made up of columns and rows separated by gridlines.
|
|
|
Active cell
|
The cell in which the cursor is currently located. (Marked with a dark outline)
|
|
|
Auto Sum
|
A toolbar button that automatically generates a formula that computes a sum of the nearest range of cell.
|
|
|
Cell
|
The intersection of a column and a row.
|
|
|
Cell reference
|
The location of a cell in a worksheet, identified by the column letter and the row number.
|
|
|
Comment
|
A text note attached to a worksheet cell.
|
|
|
Fill Handle
|
The small square located in the lower-right corner of the active cell. Can be used to copy formulas.
|
|
|
Formula
|
An instruction Excel uses to calculate a result.
|
|
|
Formula Bar
|
Provides an area for entering and changing cell data and reviewing cell formulas. It is located above the worksheet frame.
|
|
|
Label
|
A text entry in a cell.
|
|
|
Function
|
A predefined formula that performs calculations by using specific values
|
