Exam 7: Using Advanced Functions and Conditional Formatting

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

Press the ____ keys to move to the top of the table.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Excel table column containing data derived from other columns

Calculated columns work only in ranges of data.

When Excel automatically fills the rest of a table column with a formula entered into an empty table column,this is referred to as a(n)____ column.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Use to reference cells within an Excel table

The ____ error value means that invalid numbers are used in a formula or function.

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.

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

When using VLOOKUP,the ____argument is optional.

For conditional formatting,a formula must be in the form of a(n)____ test that results in a true or false value.

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

When a lookup table is used with a range of values,the compare values must be sorted in ____ order if they are text and in low-to-high order if they are numbers.

A formula must start with a(n)____.

If you are not sure of a table's name,click in the table,click the ____ tab on the Ribbon,and then click the Table Name box in the Properties group.

Case-Based Critical Thinking Questions Case 7-3 You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on,suggesting that there is an easier approach to use. -Which of the following is an effective alternative for the use of extensive nested IF functions?

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.

When manually creating a conditional formatting formula,if the formula references a cell or range outside the table,relative references should be used._________________________

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