Excel Functions and Formulas P4,5,6Quiz

Sorting is defined as:

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

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

• Arranging data in columns with column headers

• Applying cell color, border, shading, and other formatting to data

Which of these functions is a logical function?

• COUNT

• IF

• AVERAGE

• NOW

If you need to search for a function, click the Insert Function button on the formula bar.

• True

• False

You can type another function as an argument for the current function.

• True

• False

You can control which function results appear on the Status bar.

• True

• False

You CAN use the Subtotal feature with an Excel table.

• True

• False

Excel inserts a subtotal line whenever it detects a change in the value of the chosen field.

• True

• False

Sorting data Z to A sorts it lowest to highest, or least recent to most recent.

• True

• False

Use a range name to reference a cell or range of cells by name rather than by cell address(es).

• True

• False

It's appropriate to begin a range name with a number.

• True

• False