Question: True or False 1 The lookup value of a HLOOKUP function can

True or False.
1. The lookup_value of a HLOOKUP function can be a continuous cell range.
2. In a VLOOKUP formula with a TRUE lookup type, the lookup table referenced must be in ascending order to retrieve the correct value.
3. The result_vector of a LOOKUP function must be sorted in ascending order.
4. Reference and Lookup functions not contain nested arguments.
5. The default range_lookup type for the VLOOKUP and HLOOKUP functions is TRUE.
6. Excel matches the lookup_value “tom” with the entry “TOM” in a lookup table.
7. The row and column arguments in the INDEX function can be numeric values, Boolean values, or text.
8. The expression =INDEX((B2:D7, B12:D17,B22:D17),2,3,1) returns the value in cell D3.
9. The expression =AVERAGE(CHOOSE(1,B12:D17,B22:D17)) averages the value 1 with the values in cells B12 to D17 and B22 to D17.
10. The expression =MATCH(40,{10,20,40,50},0) returns the value 3.

View Solution:

Sale on SolutionInn
  • CreatedSeptember 16, 2015
  • Files Included
Post your question