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 Gender field off the ROWS. B) Drag the Item field above Gender in ROWS.
C) Drag the Item field beneath Gender in ROWS. D) Drag the Item field to VALUES.

C

Computer Science & Information Technology

You might also like to view...

What PowerShell cmdlet will allow you to view information about a connection with an SMB share on a Windows server?

A. Get-SmbMultichannelConnection B. Show-SmbMultichannelConnection C. Get-SmbConnection D. Show-SmbConnection

Computer Science & Information Technology

Which of the following is a free packet sniffer that is available for both Windows and Macintosh systems?

A) Wire shark B) Ether Detect C) Comm View D) Microsoft

Computer Science & Information Technology