The SUBTOTAL Function

question 60

Multiple Choice

The SUBTOTAL function

• A) highlights or emphasizes cells that meet certain conditions.
• B) formats cells based upon their value in reference to the value of other cells.
• C) calculates an aggregate for values in a range or database.
• D) tags a table element as a reference in a formula.

---

Definitions:

Financial Ratios

Financial Ratios are quantitative measures derived from a company's financial statements to assess its performance, efficiency, profitability, and financial health.

Dividend Payout Ratio

The portion of earnings a company pays to its shareholders in the form of dividends, expressed as a percentage of the company's total net income.

Retained Earnings

Profits that a company has earned to date, less any dividends or other distributions paid to shareholders, often used for reinvestment in the business.

Planning Assumption

Planning assumption involves the underlying assumptions or estimations made during the planning phase of a project or strategy, which guide decision-making and expectations for the future.