Solved

Match the Following Terms with the Corresponding Description

Question 82

Matching

Match the following terms with the corresponding description.

Premises:
INDEX
Lookup_value
MATCH
VLOOKUP
HLOOKUP
Responses:
Looks for a value in the left most column of a table,and then returns a value in the same row from a column you specify
Returns a value or the reference to a value within a range based on X and Y coordinates
The value that you want to find in the array or list.
Returns the position of a value in a list
Looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify

Correct Answer:

INDEX
Lookup_value
MATCH
VLOOKUP
HLOOKUP
Related Questions

Q44: The first argument of any database function

Q55: _ can copy filtered information to a

Q78: _ calculates the standard deviation of a

Q79: The MATCH function can be used to

Q81: Match the following terms with the corresponding

Q82: The RATE function returns the periodic rate

Q83: The _ function should be used to

Q84: Match the following terms with the corresponding

Q85: Match the following terms with the corresponding

Q87: Match the following terms with the corresponding

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents