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, 22.06.2019 03:00
Data is processed, stored, and transmitted as a series of 1s and 0s. each 1 or 0 is called a(n) . a series of eight 0s and 1s, called a(n) , represents one character—a letter, number, or punctuation mark. data becomes when it is presented in a format that people can understand and use. digital signals are represented by two different , such as +5 volts and +.2 volts. digital data can also take the form of light and dark spots etched onto the surface of a cd or the positive and negative orientation of particles on the surface of a hard disk. data consists of numbers that might be used in arithmetic operations. it can be represented digitally using the number system. data is composed of letters, symbols, and numerals that are not used in arithmetic operations. computers represent this type of data using , ebcdic, unicode, or utf-8. data is quantified using terms such as or kibibyte (1024 bytes), and prefixes such as or mebi (1,048,576), and giga or (1,073,741,824). to reduce file size and transmission times, digital data can be compressed. compression provides the means to compress data and reconstitute it into its original state. compression throws away some of the original data during the compression process. compressed files usually have at the end of the file name and are represented with special icons. these files have to be or unzipped before you can view the data they contain.
Answers: 1
question
Computers and Technology, 22.06.2019 15:00
The three logical operators used to write compound conditions are "and," "or," and "not." a: true b: false
Answers: 2
question
Computers and Technology, 22.06.2019 18:10
How can i delete permalinks from a word press site?
Answers: 1
question
Computers and Technology, 22.06.2019 18:30
Kto rozmawia z clamentain przez krótkofalówke w the walking dead która śledzi lee w 4 epizodzie
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
Health, 15.11.2019 10:31
Questions on the website: 13722363