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

To retrieve a particular value from a lookup table a(n)_________________________ needs to match the compare values.

To sort records by color click the filter arrow to open the Filter menu and then click _________________________.

The ____ qualifier references the Total row in the table.

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 1650.

You can insert a selected function from the list of valid function names by pressing the ____ key.

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

Duplicate value highlighting helps to verify that columns of data have unique entries.

With the ____ function you can specify only one condition to summarize the data.

Given the flowchart in the accompanying figure a Health Plan value of ____ yields a Health Plan Cost of 0.

When you retrieve a particular value from a lookup table the ____ value is the value you are trying to find.

The conditions H2="Y" and H2="y" return different values.

In a fully qualified structured reference the table name follows the column qualifier.

After a calculated column contains an inconsistency any other edits you make to that column are no longer automatically applied to the rest of the cells in that column because Excel does not overwrite ____ values.

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

According to the dialog box in the accompanying figure the lookup_value is found in row 2 of the table.

To evaluate a condition in Excel you use the ____ function.