Which Function Returns the Rank of a Value Within a Dataset

question 97

Multiple Choice

Which function returns the rank of a value within a dataset, assigning an average rank for tied values?

• A)RANK.EQ
• B)RANK.AVG
• C)RANK.TIE
• D)AVERAGERANK

---

Definitions:

CCA Class

In tax terminology, specifically for Canadian taxation, a system categorizing business assets for the purpose of depreciation calculation.

Turret Lathe

A type of lathe that allows multiple machining operations, like drilling and cutting, to be performed sequentially on a workpiece without repositioning it.

After-Tax Cost of Debt

The net cost of debt after the effects of income tax deductions on interest payments are considered.

Corporate Tax Rate

The percentage of a corporation's income that it pays as taxes to the government.