Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
21 Cards in this Set
- Front
- Back
|
Value refers to any error value
|
ISERROR
|
|
|
Use _____ to check whether a specified reference or formula returns an empty cell.
|
ISBLANK
|
|
|
The VLOOKUP function "looks up" a value and evaluates (compares) it against values in a lookup_table (the "key data") in order to return a matching "answer." When constructing a table_array to be used as lookup reference table, the "key data" should be placed in the _____.
|
leftmost column
|
|
|
What two values does the ISBLANK function return?
|
TRUE or FALSE
|
|
|
Value refers to any error value except #N/A
|
ISERR
|
|
|
Use the _____ function to retrieve a value from a table based on the row and column numbers specified
|
INDEX
|
|
|
The _____ argument of the VLOOKUP function is the type of lookup...the value should be either TRUE or FALSE.
|
range_lookup
|
|
|
A LOOKUP function is used to retrieve a value from _____.
|
column or a row
|
|
|
For the VLOOKUP function, the _____ is the data to be looked up.
|
lookup_value
|
|
|
The number of the column containing the data you want to retrieve for the VLOOKUP function is the _____.
|
col_index_num
|
|
|
T/F...To specify an "Exact Match" vlookup, enter the word False into the range_lookup argument of the vlookup function.
|
True
|
|
|
A data list that categorizes values for retrieval is a(n) _____ table.
|
lookup
|
|
|
When numbers are below the category (ex. unit price) and you refer to this, would you use VLOOKUP or HLOOKUP
|
VLOOKUP
|
|
|
What can a lookup_value be?
|
a number, text, logical value, or a cell reference
|
|
|
for range_lookup, when you use a TRUE type, what does the V(H)LOOKUP function try to do?
|
find the greatest value that does not exceed the lookup_value
|
|
|
When you have more than two choices to pick from, and have a "list" of items from which to pick, what should you use?
|
VLOOKUP (or HLOOKUP) depending on the orientation
|
|
|
Values in a "closest match" vlookup table must be sorted in descending order so that the VLOOKUP function can make accurate comparisons.
|
FALSE (they can be in any order)
|
|
|
The range_lookup argument of the VLOOKUP and HLOOKUP functions is the range of values to be looked up in order to determine the function's result.
|
FALSE
|
|
|
In order to correctly use an "exact match" VLOOKUP function, the values in the first column of the lookup table must be sorted in ascending order.
|
FALSE
|
|
|
The lookup_value argument in a VLOOKUP or HLOOKUP function is often a number, text, a logical value, or a cell reference...but the lookup_value argument can also be a formula.
|
TRUE
|
|
|
The _____ argument of the VLOOKUP function is the type of lookup...the value should be either TRUE or FALSE.
|
range_lookup
|
