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…
The correct answer is D. Right-click a bar in the PivotChart and click Expand Entire Field. All you need is to collapse to the first level where the product category is displayed.
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.
How the community answered
(30 responses)- A13% (4)
- B3% (1)
- C10% (3)
- D73% (22)
Explanation
All you need is to collapse to the first level where the product category is displayed.
Topics
#PivotChart#expand field#drill down#data visualization
Community Discussion
No community discussion yet for this question.