Which of the Following Functions Will Rank Two Values Evenly

question 37

Multiple Choice

Which of the following functions will rank two values evenly if there is a duplicate value present?

• A)RANK.EQ
• B)RANK.AVG
• C)RANK
• D)PERCENTILE

---

Definitions:

Present Value

The current worth of a future sum of money or stream of cash flows given a specified rate of return.

Endowment

In economics, an endowment is the total range of assets, including both physical goods and intangible elements like labor skills, that an individual or entity owns.

Interest Rate

The proportion of a loan that is charged as interest to the borrower, typically expressed as an annual percentage of the loan amount.

Consumes

The act of using up goods or services for personal need, satisfaction, or utility, reducing the quantity available.