USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
PivotChart
|
|
PivotTable
|
|
PivotDate
|
|
Rotate Table
|
Detailed explanation-1: -The visual representation of a PivotTable or any tabular data helps summarize and analyze the datasets, patterns, and trends. Simply put, a pivot chart in Excel is an interactive Excel chart that outlines large amounts of data.
Detailed explanation-2: -PivotCharts provide graphical representations of the data in their associated PivotTables. PivotCharts are also interactive.
Detailed explanation-3: -Pivot Table Slicers. Another way to filter a pivot table is with one or more Slicers. Pivot Table Slicers can apply filters to a single pivot table, or you can connect them to multiple pivot tables (from the same source data). Then, just click a button on a Slicer, to quickly filter all the connected pivot tables.