Exam 70-779 All Questions

View all questions & answers for the 70-779 exam

Go to Exam

Exam 70-779 topic 1 question 88 discussion

Actual exam question from Microsoft's 70-779

Question #: 88
Topic #: 1

[All 70-779 Questions]

You have the following table.

You need to create a PivotTable as shown in the following exhibit.

What should you do?

A. Add LineTotal to the Rows area. Add Product to the Values area twice.
B. Add LineTotal to the Rows area. Add Product to the Values area twice.
C. Add Product to the Rows area. Add LineTotal to the Values area twice.
D. Add Product to the Rows area. Add LineTotal to the Columns area twice.

Show Suggested Answer

Suggested Answer: C 🗳️

by CibrevN at June 10, 2020, 4:16 p.m.

Comments

Submit Cancel

Sachin08

Highly Voted 5 years, 1 month ago

C is correct.

upvoted 15 times

...

Robc79

Most Recent 4 years, 8 months ago

C is correct, although you would also have to change the 2nd field value to Max

upvoted 1 times

...

guido_007

4 years, 9 months ago

C is corect: add line total one time as SUM, and a second time as MAX

upvoted 2 times

...

Waltmas

5 years ago

C is correct

upvoted 1 times

...

panal

5 years ago

C is correct.

upvoted 1 times

...

r8d1

5 years ago

C Aggregates are in the Values area.

upvoted 1 times

...

Agustin

5 years, 1 month ago

I tested this. C is right. Do not forget, if you have any doubt, try replicating the exercise by yourself.

upvoted 4 times

...

Linyu

5 years, 1 month ago

C is correct. Tested.

upvoted 3 times

...

CibrevN

5 years, 1 month ago

D is correct

upvoted 2 times

...