Solved

Match the Following Terms with the Corresponding Description

Question 90

Matching

Match the following terms with the corresponding description.

Premises:
VLOOKUP
INDEX
MATCH
Lookup_value
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
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
The value that you want to find in the array or list.

Correct Answer:

VLOOKUP
INDEX
MATCH
Lookup_value
HLOOKUP
Related Questions

Q3: _ will return the interest paid for

Q28: The _ function should be used to

Q42: Which database function will return the smallest

Q46: In the function =IF(E5&lt;J7,F5*K7,IF(E5&lt;=J8,F5*K8,F5*K9)),F5*K7 is the:<br>A)Value_if_true.<br>B)Value_if_false.<br>C)Logical_test.<br>D)Modifier.

Q57: Which function will calculate the current value

Q66: _ can copy filtered information to a

Q75: Which function will return the intersection of

Q87: Which of the following functions does not

Q87: The RATE function returns the periodic rate

Q92: Which of the following database functions is