Multiple Choice
How can one filter a PivotTable using a report filter?
A) Click on the drop down arrow for a Report Filter in the pivot table and Click (All) .
B) Click the Report Filter's drop-down arrow,then click on an item to select an item in the list and click OK.
C) Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to 'Down,Then Over' On the Layout & Format tab.
D) Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to Over,Then Down' On the Layout & Format tab.
Correct Answer:

Verified
Correct Answer:
Verified
Q1: A student creates data for trees in
Q2: Which of these series of clicks will
Q3: On which of the following tabs of
Q4: In which of these boxes will you
Q6: To illustrate different data levels using small
Q7: After drilling down,Esteban wants to drill up
Q8: Ned wants to calculate the total sale
Q9: Amin wants to extract data from a
Q10: Which of the following will you select
Q11: If Power View is enabled,one can create