USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which PivotChart tool limits the amount of data being displayed?
|
|
axis
|
|
|
filter
|
|
|
legend
|
|
|
sort
|
Explanation:
Detailed explanation-1: -Create a slicer to filter data in a PivotTable On the PivotTable tab, select Insert Slicer. In the Insert Slicers dialog box, select the check boxes for the fields you want to display, then select OK. A slicer will be created for every field that you selected.
Detailed explanation-2: -Click anywhere in the PivotTable (or the associated PivotTable of a PivotChart ) that has one or more report filters. Click PivotTable Analyze (on the ribbon) > Options > Show Report Filter Pages. In the Show Report Filter Pages dialog box, select a report filter field, and then click OK.
There is 1 question to complete.