Solved

When a Lookup Table Is Used with a Range of Values,the

Question 74

Multiple Choice

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:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q27: You have been using a variety of

Q39: For conditional formatting,a formula must be in

Q63: When using VLOOKUP,the _argument is optional.<br>A)lookup_value<br>B)table_array<br>C)range_lookup<br>D)col_index

Q65: An error value begins with a(n)_ followed

Q69: The _ function is a logical function

Q74: If you are not sure of a

Q79: When manually creating a conditional formatting formula,if

Q86: The categories for a lookup table called

Q104: A formula must start with a(n)_.<br>A)plus sign<br>B)minus

Q134: After a calculated column contains an inconsistency