Microsoft
70-779 · Question #51
70-779 Question #51: Real Exam Question with Answer & Explanation
The correct answer is C. Right-click the PivotChart, click Select Data, and then remove five of the bins from the Horizontal. https://a4accounting.com.au/switching-rows-and-columns-in-a-pivotchart/
Question
You create a PivotTable and a Pivot Chart as shown in the following exhibit. You need to decrease the number of columns in the PivotChart to six. What should you do?
Exhibit
Options
- ARight-click the PivotChart, click Format Axis, and then change Interval between marks to 2.
- BRight-click the PivotTable, click Group, and then change By from 10 to 20.
- CRight-click the PivotChart, click Select Data, and then remove five of the bins from the Horizontal
- DChange the chart type to Histogram.
Explanation
https://a4accounting.com.au/switching-rows-and-columns-in-a-pivotchart/
Community Discussion
No community discussion yet for this question.