Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 60 discussion

Actual exam question from Microsoft's 70-779

Question #: 60
Topic #: 1

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?

A. Click the + button
B. Double-click a bar in the PivotChart
C. Drag Products from the Axis area to the Legend area
D. Right-click a bar in the PivotChart and click Collapse Entire Field

Show Suggested Answer

Suggested Answer: C 🗳️
Reference:
https://www.contextures.com/pivotchart.html

by tho at Nov. 20, 2019, 12:46 p.m.

Comments

Submit Cancel

Shil

Highly Voted 5 years, 6 months ago

D is the right answer. All you need is to collapse to the first level where the product category is displayed.

upvoted 19 times

...

cs3122

Highly Voted 5 years, 5 months ago

D is the only correct answer here :)

upvoted 11 times

...

iaaqq

Most Recent 4 years, 5 months ago

C is the definitive ans on the context of question

upvoted 1 times

...

CDL

4 years, 8 months ago

D is correct. in the PivotChart, lowerright conner there are icons "+"(Expand), & "-"(Collapse), just click the button "-" to collapse.

upvoted 4 times

jason69

4 years, 5 months ago

Yes, correct answer is D. Just tested it. C is strictly speaking NOT what the question asks for i.e. to display Product Category ONLY. By dragging Products to the legend area, it will still be displayed together with Product Category.

upvoted 1 times

...

Waltmas

4 years, 11 months ago

The only correct answer is C

upvoted 3 times

...

NasheM

4 years, 11 months ago

I tried this and collapse only works if you right click the Pivot table not a bar in the pivot chart as is stated by D. That leaves C as the correct answer

upvoted 2 times

...

Eric777

5 years ago

Please disregard my first post. Maybe that's a hierarchy at the bottom of the graphic?

upvoted 1 times

...

Eric777

5 years ago

Let's not be too quick with "D". Look at the first exhibit. I don't see a hierarchy this time. What exactly would a "Collapse" do? We may have to swap in the correct field.

upvoted 1 times

...

Outsider

5 years ago

This questions is similar to the P38. If on P38 the correct answer is A. Right-click a bar in the PivotChart and click Expand Entire Field. In here it should be D. Right-click a bar in the PivotChart and click Collapse Entire Field

upvoted 4 times

...