FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which is the name of an interactive graphical representation of data thatallows a user to change the groupings?
A
PivotChart
B
PivotTable
C
PivotDate
D
Rotate Table
Explanation: 

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.

There is 1 question to complete.