Kevin Formatted the Values in a PivotTable by Selecting the Values

question 164

Multiple Choice

Kevin formatted the values in a PivotTable by selecting the values and then clicking the Accounting Number Format button on the Home tab. When he changed the layout of the PivotTable, he lost the number formatting. Which dialog box should he use instead?

• A) Format Cells dialog box
• B) Value Field Settings dialog box
• C) PivotTable Format dialog box
• D) Value Properties dialog box

---

Definitions:

Evaluate Performance

The process of assessing the effectiveness, efficiency, and productivity of an employee, team, or organization.

Company's Operation

Refers to the daily activities involved in running a business, including production, marketing, sales, and administrative tasks, essential for generating revenue.

Staff Department

A unit that provides services, assistance, and advice to the departments with line or other staff responsibilities.

Line Responsibilities

Duties and tasks directly involved in the operations of an organization and its core business functions.