Exam 5: Retrieving Data for Computation, Analysis, and Reference

If you have a valid range that is not in ascending order, you can sort it using the ____ commands in the Editing group on the HOME tab on the ribbon.

When using the CHOOSE function, if the index_num argument is less than 1 or greater than the last value in the list, the function displays the error ____.

If you use an INDEX formula that refers to ranges on separate worksheets, Excel displays the ____________________ error.

Excel provides nine functions, called the ____ functions, that test a value or cell reference and then return a TRUE or FALSE value depending on the results.

In a LOOKUP function, the argument ____ refers to the data you want to look up.

The ____ function allows you to retrieve data from multidimensional tables.

A data list that categorizes values you want to retrieve is called a ____ table.

The MATCH function is designed to return the relative position (such as 1, 2, or 3) of an item in a list. _________________________

A table_array argument must contain relative cell references so that the row values will not change when the formula is copied down the column.

When creating a range for use with a type FALSE VLOOKUP table, make sure to sort the values in the first column of table_array in ____ order.

In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value.

If a lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the ____ error value.

You can often use a LOOKUP function instead of a VLOOKUP or HLOOKUP function with a TRUE lookup type.

MATCHING Identify the letter of the choice that best matches the definition of the word or phrase. -Can return a value or a range for up to 254 different values

Range names copy absolutely.

In a(n) ____ table, Excel searches one dimension, such as the columns, and then searches another dimension, such as the rows, to find the value at the intersection of a single row and column.

Identify the letter of the choice that best matches the function definition and arguments. -area_num

To return a negative value, ____ is a correct formula.

The syntax of the IFERROR function is ____.

If you want to use the INDEX function to retrieve data stored in more than one range, be certain to store all the lookup ranges on the same computer. _________________________