BIM EXCEL -Chap 2 11-15

The values and other inputs that a function uses to calculate the result

• function name

• auto calculate

• argument

• nest

A feature that temporarily performs the following calculations on a range of cells without the user having to enter a formula

• auto calculate

• argument

• nest

• function

A feature that speeds up the manual entry of functions

• argument

• function autocomplete

• nesting

• filter

A predefined formula that performs a specific calculation using the inputs you specify

• nesting

• filter

• auto complete

• function

The name given to one of Excel's predefined formulas is a function name

• True

• False

To use a function as an argument within another function

• nest

• filter

• auto calculate

• criterion

A value, some text, or an expression that defines the type of content you want to see

• formula

• criterion

• filter

• column specifier

The structured reference to a table column, which consists of the table column header name in square brackets

• function

• criterion

• column specifier

• filter

Data arranged in columns and specifically formatted with column headers that contain commands that allow you to sort, filter, and perform other functions on the table

• filter

• criterion

• column specifier

• excel table

Hide nonmatching rows in a table or list of data according to the criterion or criteria you specify

• filter

• criterion

• column specifier

• banded rows