Front | Back |
Argument
|
The values and other inputs that a function uses to calculate the result. You specify the cell or range that holds the value(s) for each argument or input a particular value.
|
AutoCalculate
|
A feature that temporarily performs the following calculations on a range of cells without the user having to enter a formula: average, count, min, max, or sum.
|
Formula AutoComplete
|
A feature that speeds up the manual entry of functions.
|
Function
|
A predefined formula that performs a specific calculation using the inputs you specify.
|
Function name
|
The name given to one of Excel's predefined formulas.
|
Nest
|
To use a function as an argument within another funtion.
|
Column specifier
|
The structured reference to a table column, which consists of the table column header name in square brackets.
|
Criterion
|
A value, some text, or an expression that defines the type of content you want to see.
|
Excel table
|
Data arranged in columns and specially formatted with column headers that contain commands that allow you to sort, filter, and perform other functions on the table.
|
Filter
|
Hide nonmatching rows in a table or list of data according to the criterion or criteria you specify.
|
Sort
|
Arrange the rows in a table or list of data in a new order according to the entries in one or more columns.
|
Structured references
|
Using the table name or a table column header in a formula to refer to data in the entire table or specified column.
|
Total row
|
A row you can display below a table to calculate data in the columns above using a function you choose.
|
Name Box
|
The box at the far-left end of the formula bar that you can use to create and navigate to named ranges.
|
Range name
|
An identifying label assigned to a group of cells. Also known as defined name.
|