This site is 100% ad supported. Please add an exception to adblock for this site.

Excel Vocab 1

Terms

undefined, object
copy deck
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

Deck Info

18

permalink