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:

Partnership Debts

Obligations for which all partners are jointly responsible in a partnership setup, meaning each partner can be held accountable for the entire amount of the debt.

Initial Capital

The amount of money or assets used to start a business or investment.

Continuation Agreement

A legal contract that extends the period of a previous agreement, ensuring the ongoing provision of services or terms.

Partnership Property

Partnership property refers to all the assets and property owned by a partnership, which are utilized for the partnership's business activities and are distinct from the personal property of the individual partners.