As He Prepares His Assignment for His Marketing Class, Ted

question 28

Multiple Choice

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.
-If Ted decides that he wants to work with nonnumeric data in his PivotTable,what function must he use to produce summaries?

• A)SUM
• B)AGGREGATE
• C)TOTAL
• D)COUNT

---

Definitions:

Financial Reporting

The method by which declarations are created to reveal the financial condition of an organization to its managers, investors, and governmental bodies.

External Auditor

An independent third-party professional who examines the financial statements of a company to provide an opinion on their accuracy and compliance with accounting standards.

Cost-Plus Contracts

Agreements where a contractor is paid for all construction-related expenses plus a contracted profit.

Profit Markup

The amount added to the cost price of goods to cover overhead and profit; a measure of the profit margin.