Solved

Match the Following Terms with the Corresponding Description

Question 36

Matching

Match the following terms with the corresponding description.

Premises:
MATCH
INDEX
HLOOKUP
VLOOKUP
Lookup_value
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
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
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

Correct Answer:

MATCH
INDEX
HLOOKUP
VLOOKUP
Lookup_value
Related Questions

Q31: Match the following terms to their meanings:

Q32: Match the following terms with the corresponding

Q33: You can manually change each element of

Q34: Clicking Distribute Columns and Distribute Rows ensures

Q35: Match the following PowerPoint features with the

Q37: A(n)_ chart is used to show to

Q38: To select all slices in a pie,you

Q39: Match the following dialog boxes to their

Q40: Match the following terms with the corresponding

Q41: Match the following terms to their meanings: