1 What is the main purpose of a PivotChart in Excel?
a) To display charts from static data
b) To provide a visual representation of PivotTable data
c) To create formulas for data analysis
d) To format cells and ranges
Answer: b) To provide a visual representation of PivotTable data
2 How can you create a PivotChart in Excel?
a) Select a PivotTable and choose “PivotChart” from the Insert tab
b) Use the “Create Chart” option from the Data tab
c) Directly insert a chart and manually link it to the PivotTable
d) Use the “Charts” tab and select “PivotChart”
Answer: a) Select a PivotTable and choose “PivotChart” from the Insert tab
3 Which area of a PivotChart displays the actual data values and chart type?
a) Data Series
b) Axis
c) Legend
d) Chart Area
Answer: a) Data Series
4 How can you filter data in a PivotChart?
a) Use the filter options in the PivotTable Field List
b) Apply a chart filter from the chart tools
c) Right-click on the chart and select “Filter”
d) Use the filter dropdowns directly on the PivotChart
Answer: a) Use the filter options in the PivotTable Field List
5 To change the chart type of a PivotChart, which steps should you take?
a) Right-click on the PivotChart and select “Change Chart Type”
b) Use the “Design” tab under PivotChart Tools to select a new chart type
c) Modify the chart type in the PivotTable Field List
d) Delete the PivotChart and create a new one
Answer: b) Use the “Design” tab under PivotChart Tools to select a new chart type
6 What feature allows you to display different data fields from the PivotTable in a PivotChart?
a) Filter Field
b) Chart Layout
c) PivotChart Field List
d) Data Series
Answer: c) PivotChart Field List
7 In a PivotChart, what does the “Filter” button do?
a) It changes the chart layout
b) It allows you to filter data based on specific criteria
c) It adds additional data series to the chart
d) It formats the chart area
Answer: b) It allows you to filter data based on specific criteria
8 How can you format the elements of a PivotChart, such as changing the color of data series?
a) Use the “Format” tab under PivotChart Tools
b) Right-click on the data series and select “Format Data Series”
c) Use the “Design” tab to change the chart style
d) Apply conditional formatting directly to the data source
Answer: b) Right-click on the data series and select “Format Data Series”
9 To synchronize the data between a PivotTable and its associated PivotChart, what should you ensure?
a) The PivotTable and PivotChart are based on the same data source
b) Both are created from different worksheets
c) The PivotTable is updated without refreshing the PivotChart
d) Different chart types are used for the PivotTable and PivotChart
Answer: a) The PivotTable and PivotChart are based on the same data source
10 Which of the following is NOT a feature of PivotCharts?
a) Ability to filter data dynamically
b) Display data labels directly on the chart
c) Create pivot tables from the chart
d) Use slicers to filter data visually
Answer: c) Create pivot tables from the chart