Edwin Wants to Insert a PivotChart to Summarize Sales Data

question 452

Multiple Choice

Edwin wants to insert a PivotChart to summarize sales data. On which of the following does he need to base the new PivotChart?

• A) an existing PivotTable
• B) another PivotChart
• C) a column or bar chart on another worksheet
• D) a slicer on the same worksheet

---

Definitions:

Compensation Survey

A tool used to gather and analyze information about compensation levels and practices within an industry or among competitors.

Identifying Jobs

The process of defining and categorizing positions within an organization, including detailing job responsibilities, requirements, and qualifications.

Identifying Employees

The process of recognizing and understanding the unique attributes, skills, and needs of each individual within an organization to better manage and support them.

Compa-ratio

A metric used to evaluate an employee's pay relative to the midpoint of their pay range, indicating how compensation compares to market or organizational standards.