USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In order to directly report the data, what must a PivotChart always beassociated with?
|
Table
|
|
Range
|
|
PivotTable
|
|
Worksheet
|
Explanation:
Detailed explanation-1: -Creating a Simple Pivot Chart Our pivot chart is always associated with a Pivot table report, hence, we will see a Pivot table report alongside the chart we created in our Excel worksheet.
Detailed explanation-2: -When you create a Pivot Table report, each column of your source data becomes a field that you can use in the report. Fields summarize multiple rows of information from the source data.
Detailed explanation-3: -You can summarize a PivotTable by placing a field in ∑ VALUES area in the PivotTable Fields Task pane. By default, Excel takes the summarization as sum of the values of the field in ∑ VALUES area.
There is 1 question to complete.