Microsoft
70-779 · Question #117
70-779 Question #117: Real Exam Question with Answer & Explanation
Sign in or unlock 70-779 to reveal the answer and full explanation for question #117. The question stem and answer options stay visible for context.
Question
You have the following tables in a data model. You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table. You need to ensure that the data appears in chronological order. What should you do?
Exhibit
Options
- AIn the data model, modify the Sort By Column setting for Date[Month Year]
- BFrom PivotTable Fields, add Date[Year] to the Rows area
- CIn the data model, modify the Sort by Column setting for Sales[Date]
- DFrom PivotTable Fields, modify the Field Settings for Date[Month Year]
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.