Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Exam 70-779 topic 1 question 38 discussion

Actual exam question from Microsoft's 70-779

Question #: 38
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. Right-click a bar in the PivotChart and click Expand Entire Field
B. Right-click the PivotChart and click Reset to Match Style
C. Click the + button
D. Click the "" button

Show Suggested Answer

Suggested Answer: A 🗳️
References:
https://support.office.com/en-us/article/expand-collapse-or-show-details-in-a-pivottable-or-pivotchart-d70d7e70-d230-4d45-81db-1f5e39bcb394

by GST0101 at Oct. 9, 2019, 6:45 p.m.

Comments

Submit Cancel

mohroshdy

Highly Voted 5 years, 8 months ago

The correct answer is to click on "-", I think it's D but the browser shows it as â€"

upvoted 8 times

...

GST0101

Highly Voted 5 years, 9 months ago

Shouldn't we be collapsing instead of expanding????? The product category is at the top of the hierarchy in the data model so expanding doesn't make sense.

upvoted 5 times

HiJaak

5 years, 9 months ago

Yes, you're right, it should be collapse, but this cannot be achieved on the right click o a bar. Moreover, I have created a Pivot Chart and on the right side I have a + - buttons that are NOT displayed on the exhibit. From the presented options, my browser does not display correctly the option D (I see strange characters) but if "-" (minus) sign is presented, this could be the option.

upvoted 15 times

...

ammu

5 years, 8 months ago

link attached says "â€“ appears to represent the hyphen character" So I guess correct option is D https://answers.microsoft.com/en-us/msoffice/forum/all/translating-unusual-characters-back-to-normal/a819a82f-dad8-4072-bb05-49c087d4d6b2

upvoted 4 times

...

CDL

Most Recent 4 years, 9 months ago

Tested, D right. Create hierarchy of product/subCat/Cat (Row/Axis area in the field lists). Layer 1: category Layer 2: subcategory Layer3: particular product “+” means more layer, which goes deep down to layer 3; “-“ means less layer, which goes backward to the layer 2, and layer 1.

upvoted 3 times

...

hroumani

4 years, 11 months ago

Answer is "D" Click the "-" minus button

upvoted 1 times

...

Waltmas

5 years ago

Minus should do the trick, tested it

upvoted 1 times

...

Outsider

5 years, 1 month ago

The correct answer is D. Pivot Chart is already expended and question ask for goes back to Category level. Need to press ( - ) to goes up

upvoted 3 times

...

Mange

5 years, 2 months ago

The + - field buttons work for me. Should be D

upvoted 3 times

...

Mar_tin

5 years, 3 months ago

Unclear request: If they want to see the visualized data of that specific category, then they are right. Unfortunately the +/- Field Buttons disappears when clicking on the bar. If they just want (out of a hierarchical perspective) to see the data of the ProductCategory layer, then push “–“ Button. You can also just use the Product Field Buttons and sort it there.

upvoted 1 times

...