subject

Loretta, a shoe store manager, is working with a spreadsheet that contains quarterly sales values for every different shoe style in the store. She has built a PivotTable with "Shoe Style" as the row labels and with "Quarter" as the column labels. Even though there is a "Men’s/Women’s" column in the original data that labels each shoe style as either "Men’s" or "Women’s," the manager is not using this field in the PivotTable yet.

What would be the most efficient way for Loretta to remove every sales value for men’s shoes from the PivotTable while still being able to see the individual style names?

She should remove "Shoe Style" from the Column Labels area and replace it with "Men’s/Women’s".
She should add "Men’s/Women’s" to the Report Filter area, then use the filter and select only "Women’s".
She should build a new PivotTable and type into the Region section the names of the rows labeled "Women’s".
She should use the drop-down button next to Column Labels within the PivotTable and select only the styles that are women’s shoes.

ansver
Answers: 3

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 11:20, destinyleisantos
The kurt vonnegut commencement speech, the neiman-marcus chocolate chip cookie recipe, and the get-well emails to the dying boy are examples of select one: a. social engineering b. hoax emails c. email viruses d. worms
Answers: 1
image
Computers and Technology, 23.06.2019 08:30, mai1261
Helen's credit card has an apr of 15.32% and a grace period of 17 days and helen pays her balance in the full every month. if her last billing cycle ended on september 26, 2009, and she made her payment on october 11, 2009, did she owe any interest on her last statement's balance?
Answers: 3
image
Computers and Technology, 23.06.2019 17:00, Need1ng
The more powerful, 60 volt cables and the main power shut-off on an hev are both colored orange.
Answers: 1
image
Computers and Technology, 24.06.2019 02:30, sha273
Which option completes the explanation for conflict of interest in an organization
Answers: 1
You know the right answer?
Loretta, a shoe store manager, is working with a spreadsheet that contains quarterly sales values fo...

Questions in other subjects: