If You Would Like to Show a Subtotal of the Wholesale

question 9

Multiple Choice

If you would like to show a subtotal of the wholesale price of a number of items of clothing on a PivotTable of data of both men and women.You have the following fields: Gender, Item and Price.Sum of Price is in the VALUES area.Gender is in the ROWS area.How do you get a subtotal of shirts and pants to display for each gender?

• A)Drag the Item field to VALUES.
• B)Drag the Item field above Gender in ROWS.
• C)Drag the Gender field off the ROWS.
• D)Drag the Item field beneath Gender in ROWS.

---

Definitions:

Labor Resource

Human capital or workforce available for the production of goods and services in an economy.

Computer Programmer

A professional who writes, tests, debugs, and maintains the code that allows software programs and applications to function.

Budget Line

A graphical representation showing the combination of goods a consumer can purchase with a fixed income.

Money Income

The total amount of monetary earnings or receipts a person or household receives within a given period.