Which of the Following Is the Default Function Excel Uses

question 269

Multiple Choice

Which of the following is the default function Excel uses to summarize text data in a PivotTable?

• A) SUM
• B) COUNT
• C) MIN
• D) VAR

---

Definitions:

Operating Leverage (DOL)

Operating leverage measures how revenue growth translates into growth in operating income. It is a measure of how sensitive the operating income is to the change in revenues.

Fixed Costs

Expenses that do not change with the level of production or sales, such as rent or salaries.

Variable Cost

A cost that changes with the level of output or production, such as materials and labor costs.

EBIT

Earnings Before Interest and Taxes; a measure of a company's profitability that excludes interest and income tax expenses.