Lesson 11 Getting Started with Functions

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

• function

• argument

• function name

• AutoCalculate

______ finds the highest value in a range of cells.

• =MAX( )

• =MIN( )

• =ROUND( )

• =SUM( )

To quickly calculate the AVERAGE, COUNT, MAX. MIN, or SUM for a cell range without entering a formula, use _____

• Function

• AutoCalculate

• Argument

• Function Name

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

• Table style

• sort

• Total row

• Filter

Using a column header menu, you can sort the table, or change the order of the rows according to the entries in the column header by which you are sorting.

• True

• False