真正上考場時，時間壓力往往比題目本身更可怕。Fast2test 的 Desktop Test Engine 完整模擬 Microsoft Analyzing and Visualizing Data with Microsoft Excel 的考試環境，搭配 118 道 70-779 練習題反覆實戰演練，正式考試時就能像平常練習一樣從容。

Microsoft 70-779 考試概覽:

Microsoft 70-779 考試大綱主題:

關於 70-779 考試，你可能想知道的事

最新的 Microsoft Excel - Power BI - MCSA 70-779 免費考試真題：

問題 #1

You have a data model that has the following tables.

You create a PivotTable. The data displayed in the PivotTable is shown in the following table.

You need to ensure that the correct data is displayed.
What should you do?

A. Modify the workbook connections
B. Modify the relationships
C. Refresh the data connection
D. Configure the PivotTable Options

問題 #2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result these questions will not appear in the review screen.
You have an Excel workbook that contains a table named Table1. A sample of the data in Table1 is shown in the following table.

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

Solution: You create a measure named Products the uses the CONCATENATEX DAX function. You add a PivotTable. You drag Products to the Rows field. You drag Price to the Values field.
Does this meet the goal?

A. No
B. Yes

問題 #3

You have a data model that contains a table named SalesOrders has four columns named Orderld, SalesAmount, OrderDate, and Territory.
You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory.
You need to create a measure to calculate the percentage of sales of each territory.
How should you complete the DAX formula? To answer, drag the appropriate value to the correct targets.
Each value may be used once, more than once, or not at all. You need to drag the split bar between panes or scroll to view content.

問題 #4

You have the following data sample.

You need to create a PivotTable that presents the data as shown in the following table.

A. Create a PivotTable. Add UnitPrice to the Rows area and add SalesAmount to the Values area.
Right-click a cell value for SalesAmount and modify the Field Settings.
B. Create a PivotTable. Add UnitPrice to the Rows area and add SalesAmount to the Values area.
Right-click a cell value for UnitPrice and modify the Group settings.
C. Create a PivotTable. Add SalesAmount to the Rows area and add UnitPrice to the Values area.
Right-click a cell value for SalesAmount and modify the Group settings.
D. Create a PivotTable. Add SalesAmount to the Rows area and add UnitPrice to the Values area.
Right-click a cell value for UnitPrice and modify the Field Settings.

問題 #5

You have a workbook query that loads the following table

You pivot the table on the Key column by using Value as the values column, and you receive the results shown in the following table.

You need to ensure that the data appears as shown in the following table.

What should you do?

A. Change the Data Type of the Value column.
B. Select the ID column, and then click
C. Delete the Picoted Column step. Select the Key column, and the click UnpivotColumns.
D. Change the aggregate value function of the pivot.

問題與答案：