Which Is an Effective Way to Change a SUM of Price

question 29

Multiple Choice

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

• A)Select the appropriate cell in the PivotTable and type =AVERAGE(Price).
• B)Click the AVERAGE button on the Analyze tab.
• C)Right click the appropriate cell and select AVERAGE from the mini-tool bar.
• D)Click the field's arrow in the VALUES area and select Value Field Settings.

---

Definitions:

Pelvic Girdle

A ring-like bony structure located at the base of the spine and connected to the thigh bones, supporting the weight of the upper body.

Hip Bone

A large, irregularly shaped bone forming the upper part of each half of the pelvis, composing of three parts - the ilium, the ischium, and the pubis.

Exoskeletons

Hard outer structures that provide support and protection to the bodies of certain organisms, such as insects and crustaceans.

Invertebrates

Animals without a backbone, comprising a large variety of species including insects, worms, and mollusks.