Solved

When Creating a Range for Use with a Type FALSE

Question 130

Multiple Choice

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.

A) descending
B) ascending
C) alphabetical
D) any (values do not need to be sorted)

Related Questions

Q125: In a LOOKUP function, the argument _

Q126: The _ function allows you to retrieve

Q127: A data list that categorizes values you

Q128: The MATCH function is designed to return

Q129: A table_array argument must contain relative cell

Q131: In a VLOOKUP function, the argument _

Q132: If a lookup_value is smaller than the

Q133: You can often use a LOOKUP function

Q134: MATCHING<br>Identify the letter of the choice that

Q135: Range names copy absolutely.