You Would Like to See Both Average Sales and Total

question 31

Multiple Choice

You would like to see both average sales and total sales for a category in a pivot table.Which of these would best accomplish both a Total and an Average column on the field Sales?

• A)Add sales to the VALUES area once and select both AVERAGE and SUM functions.
• B)Add sales to the COLUMNS area.
• C)Add sales to the ROWS area and then choose Average.
• D)Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM.

---

Definitions:

Diabetes Risk

The likelihood of developing diabetes based on genetic, lifestyle, and environmental factors.

Canadians

Individuals originating from or holding citizenship in Canada, a country in North America.

Transtheoretical Change Theory

A psychological framework that analyzes the stages of individuals' readiness to change behavior.

Action Phase

In planning or project management, this represents the stage where strategies are implemented and actions are taken to achieve objectives.