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