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:

Motives

The reasons or drives behind an individual's actions or behavior.

Deficiencies

Refers to the lack or shortage of something essential, including nutrients, resources, or qualities necessary for normal functioning and health.

Ideals

Principles or values that are actively pursued as goals or standards of perfection.

Interests

Refers to activities, topics, or subjects that an individual finds engaging or enjoys exploring.