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:

Interest Computation

The process of calculating the interest due on a loan, based on the principal, interest rate, and time.

Lending Institution

An organization that provides financial loans to individuals or businesses, expecting repayment with interest.

Discounted

The process of determining the present value of a payment or a series of payments that will be made in the future, taking into consideration a specific interest rate.

Discounted

The process of determining the present value of a future amount, or stream of payments, by applying a discount rate.