USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
PivotTable
|
|
|
PowerChart
|
|
|
Query
|
|
|
Slicer
|
Detailed explanation-1: -To remove all report filters, labels, values, and formatting from a PivotTable, and to start designing the layout all over again, use the Clear All command. Click the PivotTable or PivotChart. On the Analyze tab, in the Actions group, click Clear, and then click Clear All.
Detailed explanation-2: -After you insert a column, line, pie, or radar chart, you can pivot it by changing or moving fields using the PivotTable Fields list. You can also filter data in a PivotTable, and use slicers.
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.
Detailed explanation-4: -The Sum function is used by default for numeric value fields you place in your PivotTable, but here’s how to choose a different summary function: In the PivotTable, right-click the value field you want to change, and then click Summarize Values By. Click the summary function you want.