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]
A graphical representation of the data in a PivotTable.
A
PivotTable
B
PivotChart
C
plot area
D
sparklines
Explanation: 

Detailed explanation-1: -PivotCharts provide graphical representations of the data in their associated PivotTables. PivotCharts are also interactive. When you create a PivotChart, the PivotChart Filter Pane appears.

Detailed explanation-2: -What is the Pivot Chart in Excel? PivotChart in Excel is an in-built program tool that helps you summarize selected rows and columns of data in a spreadsheet. The visual representation of a PivotTable or any tabular data helps summarize and analyze the datasets, patterns, and trends.

Detailed explanation-3: -Associated PivotTable report The PivotTable report in a workbook that is graphically represented in a PivotChart.

There is 1 question to complete.