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) HLOOKUPlookup_value, table_array, row_index_num)
B) MATCHlookup_value, lookup_array, match_type)
C) INDEXarray, row_num, col_num)
D) VLOOKUPlookup_value, table_array, col_index_num)
Correct Answer:
Verified
Correct Answer:
Verified
Q20: Use the data given below to
Q21: The sort buttons in Excel can be
Q22: If cell G7 contains the function ,
Q23: Which of the following functions is a
Q24: What is a database?<br>A) a structured collection
Q25: Use the data given below to
Q26: For which of the following MATCH functions
Q27: In a database, information is stored and
Q28: Use the data given below to
Q30: Using the spreadsheet below, provide the