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:

Capacity

The maximum amount or number of something that a system or process can contain or produce.

Phonological Code

The representation of spoken sounds in an individual’s mind that is used in the processing and storage of verbal information.

Visual Code

The system of symbols or representations used in visual communication, such as gestures, images, or signs, to convey messages or meaning.

Iconic Code

A system of symbols or representations that stands in for objects or ideas in a way that is directly perceptible to the senses, especially sight.