Solved

Match the Following Functions with Their Definition

Question 17

Matching

Match the following functions with their definition.

Premises:

Responses:

Returns one of two values depending upon whether the logical statement is evaluated as being true or false

VLOOKUP

Calculates periodic disbursement for a loan

Matches a provided value in a table of data and returns a value from a subsequent column

AND

Returns true if all arguments are true

PMT

Returns true if one argument is true

Premises:

VLOOKUP

AND

PMT

Responses:

Returns one of two values depending upon whether the logical statement is evaluated as being true or false

Calculates periodic disbursement for a loan

Matches a provided value in a table of data and returns a value from a subsequent column

Returns true if all arguments are true

Returns true if one argument is true

Correct Answer:

Premises:

Responses:

VLOOKUP

AND

PMT