Excel 5

You use VLOOKUP when the ____ of the lookup table contains the data you are looking up.

the first column

With a ____ type of VLOOKUP, thefunction returns the greatest value that does not exceed the lookup value.

true

The INDEX function can solve for ____.

two or more variables

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.

two-dimensional

In a(n) ____ table, Excel can search a row or column to find key data, and then use that data to locate the correct value.

one-dimensional

When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.

row

You can use VLOOKUP and HLOOKUP to retrieve data stored in lookup tables on ____.

same worksheets or other worksheets

When you write a VLOOKUP formula, you indicate the value you want to look up in a ____.

table

You can only use a LOOKUP function when you want to retrieve a value that is stored to the ____ of a key data column in a vertical lookup table.

left

VLOOKUP searches for a matching value in the leftmost column of the table, and then retrieves the value ____.

in the same row but in another column that you specify

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

index

With a ____ type of VLOOKUP, the function would look only for the exact match.

False

The data you are looking up is also called the ____.

key data

As with the VLOOKUP and HLOOKUP functions with the TRUE lookup type, the ____ function looks for a value that matches the criterion by comparing values based on their position in the lookup table.

Lookup

LOOKUP also uses a ____ lookup type, so the column or row containing the lookup values must be in ascending order.

True

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

look up table

You can only use a LOOKUP function when you want to retrieve a value that is stored ____ a key data row in a horizontal lookup table.

above

The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.

ascending

The H look up stands for

horizontal