+
Related Flashcards
Cards In This Set
| Front | Back |
|
Argument
|
The values and other inputs that a function uses to calculate the result. specify cell or range that holds the value for each
|
|
Autocalculate
|
A feature that temporarily performs the folliwing calculations on a range of cells without the user having to enter a formula: AVERAGE, COUNT, MIN, MAX, SUM
|
|
Formula autocomplete
|
A feaure that speeds up the manual entry of functions
|
|
Function
|
A predefined formula that perfomrs a specific calculation using the inputs
|
|
Function name
|
The name given to a formula
|
|
Nest
|
To use a function as an argument within another functuion
|
|
Column specifier
|
The structured referece to a table column whcih consists of the table header name in brackets
|
|
Criterion
|
A value text or expression that defines the type of content you see
|
|
Excel table
|
Data arranged in columns and specially formatted with column headers that contain commands that allow you to sort filter and perdform other functions in the table
|
|
Filter
|
Hide nonmatching rows in a table or list of data uib a bew order accorsing to the entries in one or more columns
|
|
Sort
|
Arrange the rows in a table or data list in a new order according to the entries in one or more columns
|
|
Structured references
|
Using the table name or table column header in a formula to refer to data in the entire table or column
|
|
Total row
|
A row you can display below a table to calculate data in the columns above using a funcation you choose
|
|
Name Box
|
The box at the far left end of the formula bar that yuo can use to create and navigate to anemd ranges
|
|
Range name
|
An identifying label assigned to a group
|
