Exam 8: Excel 4: Working With Advanced Functions

The ____________________ function calculates the difference between two dates and shows the result in months, days, or years.

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

_____ just above the header row of an Excel table to select the column data but not the header.

If all of the logical conditions are true, the AND function returns the logical value _____.

A formula that includes a structured reference can be fully qualified or unqualified.

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

You can calculate the number of cells in a range that match criteria you specify using the SUMIF function. _________________________

Lookup _____ allow you to use tables of data to "look up" values and insert them in another worksheet location.

_____ 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.

The _____ function searches vertically down the first column of the lookup table.

You can edit existing conditional formatting _____ from the Conditional Formatting Rules Manager dialog box.

The ____________________ function searches horizontally across a lookup table and is used when the compare values are stored in the first row of the lookup table.

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

The major difference between HLOOKUP and VLOOKUP functions is the way the lookup tables are _____.

To change the background fill color of duplicate values, in the _____ group on the Home tab, click the Conditional Formatting button, and then click Manage Rules.

Two common categories of formula errors in Excel are syntax errors and logic errors.

A(n)____________________ IF function is when one IF function is placed inside another IF function to test an additional condition.

The ORERROR function can determine if a cell contains an error value and then display the message you choose.

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

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.