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

Another question on Computers and Technology

question
Computers and Technology, 24.06.2019 07:00
Why would a business likely use a java applet - to back up their data files for the business - to create a program that a customer can launch in their web browser - to create music on a powerpoint presentation - to organize files on their company directory
Answers: 3
question
Computers and Technology, 24.06.2019 15:30
What is the total number of time zones that can be configured to show by default in a calendar in outlook 2016?
Answers: 1
question
Computers and Technology, 24.06.2019 23:30
Adrian has decided to subscribe for a new internet connection. he wants a high speed connection so that he can stream video content smoothly. which access technology would you advise adrian against using?
Answers: 1
question
Computers and Technology, 25.06.2019 01:30
The physical parts or components of a computer system is called .
Answers: 1
You know the right answer?
Loretta, a shoe store manager, is working with a spreadsheet that contains quarterly sales values fo...
Questions
question
Mathematics, 01.04.2021 22:20
question
Mathematics, 01.04.2021 22:20
Questions on the website: 13722362