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

Question

Quizplus · Accepted Answer

The first row (key values) of the lookup table must be sorted in ascending order to use an HLOOKUP function with a TRUE lookup type. This means the values need to be arranged from smallest to largest in order for the function to work correctly.

The First Row (Key Values) of the Lookup Table Must