When a lookup table is used with a range of values,the compare values must be sorted in ____ order if they are text and in low-to-high order if they are numbers.
A) alphabetical
B) date
C) size
D) calculated
Correct Answer:
Verified
Q41: When you want to reference an entire
Q46: If you are not sure of a
Q50: When using VLOOKUP,the _argument is optional.
A)lookup_value
B)table_array
C)range_lookup
D)col_index
Q59: An error value begins with a(n)_ followed
Q82: _ lookup tables are commonly used to
Q86: Error values indicate that some element in
Q88: The Conditional Formatting button provides access to
Q89: To set up an approximate match lookup
Q90: The _ error value means that a
Q93: The _ error value means that invalid
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents