To Set Up an Approximate Match Lookup Table So It

Multiple Choice

To set up an approximate match lookup table so it works in Excel,the leftmost column in the lookup table must represent the lower end of the range for each category,and the lookup table must be sorted in ____.

A) ascending order based on the value in the first column
B) descending order based on the value in the first column
C) ascending order based on the value in the last column
D) descending order based on the value in the last column