FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

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.