Microsoft
70-779 · Question #25
You have the data model shown in the Data Model exhibit. (Click the Exhibit button.) Data Model exhibit: You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.) Pivot Cha
Sign in or unlock 70-779 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
Visualize data by using Microsoft Excel
Question
You have the data model shown in the Data Model exhibit. (Click the Exhibit button.) Data Model exhibit:
You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.) Pivot Chart exhibit:
You need to change the current view of the PivotChart to display ProductCategory only. What should you do?
Options
- ADouble-click a bar in the PivotChart.
- BClick the + button.
- CDrag Products from the Axis area to the Legend area
- DRight-click a bar in the PivotChart and click Expand Entire Field.
Unlock 70-779 to see the answer
You've previewed enough free 70-779 questions. Unlock 70-779 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#PivotChart#expand field#drill down#data visualization