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:

Standard of Care

The level of attention, caution, and prudence reasonably expected of a professional or individual in a given situation.

Subsequent Services

Services provided after an initial service, often as a follow-up or to maintain the initial service's effect.

Third Parties

Individuals or entities that are not directly involved in a legal agreement or contract but may be affected by it or have interests in its outcomes.

Fiduciary Duty

A legal obligation of one party to act in the best interest of another when managing assets or making decisions on their behalf.