Excel Chapter 2 Ls. 11-15

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

• Table

• Sort

• Filter

• Criterion

When these symbols are written like this <> it means what?

Using a function as an argument withing another function.

• Round

• Nesting

• Expression

• Criteria

When you need a date and time that automatically updates on the worksheet, insert the ____ function

A Statistical function that uses a condition to return the average of all cells in a range that meet specific criteria.

• COUNTIF

• AVERAGEIF

• SUMIF

• ROUND

The _____ function will convert all letters (only) to lowercase text.

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

• Expression

• Range Name

• Name Box

• Volatile

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

A combination of cell color, border, shading, and other formatting attributes applied to a table.

• Table Style

• Structured Reference

• Excel Table

• Banded Rows or Columns

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

• Filter

• Criterion

• Sort

• Structured Reference