Solved

Match the Following Functions with Their Definition

Question 93

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

Related Questions

Q88: In financial applications,the word _ refers to

Q89: The _ function calculates the difference between

Q90: A(n)_ function determines if a statement is

Q91: _ functions are functions that manage,manipulate,and format

Q92: Excel's _ function returns only the current

Q94: Match the following functions with their definition.

Q95: Match the following functions with their description.

Q96: Match the following functions with their definition.

Q97: Match the following categories with their description.

Q98: Match the following categories with their description.

Unlock this Answer For Free Now!

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

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

Unlock quizzes for free by uploading documents