Working with Advanced Functions

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.

If you edit a cell in a calculated column so it is no longer consistent with the other formulas in the column, a _____ appears in the upper-left corner of the cell.

The _____ function is a logical function that evaluates a condition and then returns one value if the condition is true and another value if the condition is false.

You could test two or more conditions and determine whether all conditions are true using the _____ function.

_____ references make it easier to create formulas that use portions or all of an Excel table because the names of headers are usually simpler to identify than cell addresses.

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

You can _____ IF functions to allow for three or more outcomes.

You can _____ IF functions to allow for three or more outcomes.

You can use a _____ function to return a value from a table that is based on an approximate match lookup.

An error value begins with a(n) _____ followed by an error name that indicates the type of error.

The _____ error value means that a value is not available to a function or formula.

You can edit existing conditional formatting rules from the Conditional Formatting _____ dialog box. Click the Edit Rule button and make the appropriate changes.

The _____ function calculates the number of cells in a range that match criteria you specify.

The _____ function adds the values in a range that match criteria you specify.

The COUNTIF function is sometimes referred to as a(n) _____ count.