Multiple Choice
The first row (key values) of the lookup table must be sorted in ____ order to use an HLOOKUP function with a TRUE lookup type.
A) ascending
B) descending
C) alphabetical
D) numerical
Correct Answer:

Verified
Correct Answer:
Verified
Q24: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Mark is
Q25: The LOOKUP function uses a _ lookup
Q26: A data list that categorizes values you
Q27: The syntax of the CHOOSE function is
Q28: When solving an HLOOKUP formula, Excel looks
Q30: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is
Q31: You can only use a LOOKUP function
Q32: The ISBLANK function checks whether a specified
Q33: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt=" Violet is
Q34: To find and retrieve data from a