USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Actions
|
|
|
Data
|
|
|
Filter
|
|
|
Tools
|
Detailed explanation-1: -Click anywhere in a PivotTable to show the PivotTable Tools ribbon group, then click Analyze > Insert Timeline. In the Insert Timeline dialog box, check the date fields you want, and click OK.
Detailed explanation-2: -On the Analyze tab, in the Filter group, click Insert Slicer. Select the checkboxes for the slicer(s) you want to create, and click OK.
Detailed explanation-3: -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. Check the fields you want to slice the PivotTable with, and click OK.
Detailed explanation-4: -If you don’t see the Pivot Table Analyze tab when you click a Pivot Table, please follow the below steps: In your excel document select File > Options > Customize the Ribbon. Select Tool Tabs from the drop-down list of Customize the Ribbon box. Locate PivotTable Tools.