BIM EXCEL

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 vibe.

• Function

• Argument

• Function Name

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

• Excel Table

• Function

• Function Name

• Sort

The name given to one of Excel's predefined formulas.

• Function

• Function Name

• Volatile

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

• Expression

• Excel Table

• Table

Arrange the rows in a table or list of data in a new order according to the entries in one or more columns.

• Sort and Filter

• Sort

• Filter

A function that updates and displays a new result each time you open the workbook.

• Volatile

• Sort

• Expression

• Filter

An identifying label assigned to a group of cells. Also known as defined name.

• Function

• Range Name

• Function Name

• Argument

a sort of equation (such as B6>25) that returns a value, such as true or false. Excel uses expressions to identify cells to include in certain formulas.

• Range name

• expression

• SUMIF function

• concatenation

True or False:

You enter a SUMIF function as... =SUMIF(range, criteria, sum_range)

• True

• False

True or False: The range is the range of rows you want to review.

• True

• False

Answer explanation

It is the range of cells you want to review.