Multiple Choice
Which of the following Lookup functions returns the relative position of an item in an array that equals a specified value in a specified order?
A) HLOOKUP(lookup_value, table_array, row_index_num)
B) MATCH(lookup_value, lookup_array, match_type)
C) INDEX(array, row_num, col_num)
D) VLOOKUP(lookup_value, table_array, col_index_num)
Correct Answer:
Verified
Correct Answer:
Verified
Q18: Which of the following ways would 102
Q19: AND(condition 1, condition 2…) is a logical
Q20: Identify the equation for calculating the
Q21: In a MATCH function, the default value
Q22: A positive NPV means that the investment
Q24: In a MATCH function, if match_type =
Q25: Use the data given below to
Q26: The Excel function of is used to
Q27: To find the number of orders with
Q28: Using a $ sign before a column