Exam 7: Using Advanced Functions and Conditional Formatting

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Adds the values in a range that meet criteria you specify

The ____ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if all the logical conditions are FALSE.

When you want to reference an entire column of data in a table,you create a column ____.

An error value begins with a number sign followed by an error name,which indicates the type of error._________________________

The ____________________ error value means that a cell reference used in a formula or function is no longer valid.

A(n)____________________ table is a table that organizes data you want to retrieve into different categories.

The complete formula that corresponds to the flowchart in the accompanying figure is ____.

The ____ error value means that,for example,a function name is misspelled.

The ____ error value means that a formula or function requires two cell ranges to intersect but they do not.

The ____________________ error value means that the wrong type of argument is used in a function or formula.