USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Filtering
|
|
|
Sorting
|
|
|
Positioning
|
|
|
Arranging
|
Detailed explanation-1: -In the PivotTable, select one or more items in the field that you want to filter by selection. Right-click an item in the selection, and then click Filter.
Detailed explanation-2: -Select any cell in the pivot table. Select the Analyze/Options tab in the ribbon. Click the Insert Slicer button. Check the box for the field that is in the Filters area with the filter applied to it.
Detailed explanation-3: -You can use Slicers and Timelines to filter your PivotTable data, and at a glance, you can see what filters are applied. To add a slicer, click a cell in your PivotTable, and the PIVOTTABLE TOOLS tab appears. Click ANALYZE, click Insert Slicer. The Insert Slicer dialog box has options for each field in the PivotTable.