Exam 7: Excel: Using Advanced Functions Conditional Formatting and Filtering

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.

Click the Home tab on the Ribbon and then in the ____ group click the Conditional Formatting button to open the Conditional Formatting dialog box.

You can enter a column header in a formula by starting to type the name of the column header until it is highlighted in the list and then pressing the ____ key.

The categories for a lookup table called _________________________ values are located in the table's first column or row.

The COUNTIFS function counts the number of cells within a range that meet multiple criteria.

If any logical condition listed in the function is true the AND function returns a TRUE value.

The ____ function returns the number of cells containing numbers that meet specified criteria.

You can type a(n)____ to the left of the = sign in a formula to convert it to text.

A(n)_________________________ specifies the type of condition the type of formatting when that condition occurs and the cell or range the formatting is applied to.

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

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.

In the Edit Formatting Rule dialog box click the ____ button to open the Format Cells dialog box.

The _________________________ function searches vertically down a lookup table and is used when the compare values are stored in the first column of the lookup table.

Given the flowchart in the accompanying figure the Pay Grade of ____ yields a Bonus value of 7500.

The ____ qualifier references the header row in the table.