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?

a. she should remove "shoe style" from the column labels area and replace it with "men’s/women’s".
b. she should add "men’s/women’s" to the report filter area, then use the filter and select only "women’s".
c. she should build a new pivottable and type into the region section the names of the rows labeled "women’s".
d. she should use the drop-down button next to column labels within the pivottable and select only the styles that are women’s shoes.