Microsoft
70-779 · Question #56
You have an Excel workbook that displays two PivotCharts. One chart displays sales by month. The other chart displays sales by year. You add a slicer for month. You discover that when you select a…
The correct answer is C. Modify the Report Connections of the slicer. See the full explanation below for the reasoning.
Question
You have an Excel workbook that displays two PivotCharts. One chart displays sales by month. The other chart displays sales by year. You add a slicer for month. You discover that when you select a month in the slicer, the data in the sales by year PivotChart changes. You need to prevent the slicer from affecting the sales by year PivotChart. What should you do?
Options
- ARemove all the fields from the Filters area of the sales by month PivotChart.
- BModify the Value Field Settings for the values of the sales by year PivotChart,
- CModify the Report Connections of the slicer.
- DRemove all the fields from the Filters area of the sales by year PivotChart.
How the community answered
(23 responses)- A4% (1)
- B17% (4)
- C74% (17)
- D4% (1)
Community Discussion
No community discussion yet for this question.