Microsoft Office Excel Chapter 2

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.

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

• Function

• Argument

• Value

• AutoSum

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

• Function caption

• Function label

• Function name

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.

• Excel spreadsheet

• Excel table

• Excel sheet

• Excel document

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

• Filter

• Reorder

• List

• Sort

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

• Volatile

• Now

• LoadTile

• Function

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

• Range name

• Group name

• Range label

• Group label

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 such as IF and SUMIF.

• Function

• If/Or

• Expression

• True/False

Here is how you enter a SUMIF function:

• =SUMIF(range,criteria,range)

• =SUMIF(range,criteria,criteria)

• =SUMIF(range,criteria,sum_range)

• =SUMIF(criteria, range,sum_range)

The range of cells you want to review.

• range

• criteria

• optional sum_range