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.


Answer: D

Computer Science & Information Technology

You might also like to view...

How is the type field in the Ethernet header used?

What will be an ideal response?

Computer Science & Information Technology

A __________ is an entity corresponding to a user job or application that owns resources such as memory and open files.

A) ?task ? B) ?process ? C) ?thread ? D) ?token

Computer Science & Information Technology

Would this compile? If not, what change do you need to make so that it will compile?

``` public String test4 ( int x ) { return x * 4 ; } ```

Computer Science & Information Technology

A(n) ________ installation installs all the most commonly used files and programs from the distribution disc to your computer's hard drive

Fill in the blank(s) with correct word

Computer Science & Information Technology