Multiple Choice
Dana added a report filter to a PivotTable, but the list of filter values is long and difficult to use. What can she do to reduce the filter values in the list?
A) Use a slicer instead of a report filter.
B) Enter search text in the Search box above the list of field item values.
C) Sort the PivotTable first.
D) Use the Approximate Filter feature.
Correct Answer:

Verified
Correct Answer:
Verified
Q16: To highlight track changes in a worksheet,go
Q36: Which of the following functions would you
Q53: In formulas,calculations in square brackets are calculated
Q54: Which of the following inserts a function
Q87: Which of the following is true about
Q193: The value in cell B2 cell is
Q421: To create a PivotTable layout, you can
Q427: How do you select a cell containing
Q428: Jason wants to average the sales in
Q431: Dean wants to insert two blank rows