Câu 17: 70-779: Analyzing and Visualizing Data with Microsoft Excel

You have the following table. You plan to use [Month Name] as the axis in a PivotChart. You need to ensure that whenever [Month Name] is used in a chart, the months are displayed chronologically by default. What should you do?

1. A. Add a calculated column named [ID] that uses the [Month Name]&[Month Number] DAX formula — đáp án hiện tại
2. B. Change the Data Type of [Month Name] to Date
3. C. Sort the [Month Number] column by [Month Name]
4. D. Sort the [Month Name] column by [Month Number]