USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Slicer
|
|
|
Dicer
|
|
|
Chopper
|
|
|
AutoFilter Menu
|
Detailed explanation-1: -Slicers are basically just filters but are easier and faster to use, allowing you to instantly pivot your data. If you frequently filter your PivotTables, you may want to consider using slicers instead of filters.
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.
Detailed explanation-3: -Just like filters, only selected items are used in the PivotTable. When you select or deselect an item, the PivotTable will instantly reflect the change. Try selecting different items to see how they affect the PivotTable. Press and hold the Ctrl key on your keyboard to select multiple items at once.