学習スタイルは人それぞれです。GoShikenでは070-779対策として、印刷して使えるPDF版、本番環境を再現するデスクトップテストエンジン、ブラウザで手軽に取り組めるオンラインテストエンジンの3つの形式で、Microsoft Analyzing and Visualizing Data with Microsoft Excelの練習問題118問をご用意しています。

Microsoft 070-779 試験概要:

Microsoft 070-779 試験シラバストピック:

Microsoft Analyzing and Visualizing Data with Microsoft Excelのよくある疑問を解決します

Microsoft Analyzing and Visualizing Data with Microsoft Excel 認定 070-779 試験問題：

問題 #1

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 a Power Pivot model that contains the following tables.

There is a relationship between Products and ProductCategory.
You need to create a hierarchy in Products that contains ProductCategoryName and ProductName.
Solution: You create a measure that uses the USERELATIONSHIP DAX function.
Does this meet the goal?

A. No
B. Yes

問題 #2

You have a table named Sales that has three columns named Region, Country, and SalesAmount.
You create a PivotTable as shown in the following exhibit.

You need to ensure that the PivotTable appears in three columns as shown in the following exhibit.

What should you do?

A. On the Design tab, click Report Layout and then click Show in Compact Form.
B. On the Design tab, click Report Layout and then click Show in Tabular Form.
C. Move Country from the Rows area to the Values area.
D. Move Country from the Rows area to the Columns area.

問題 #3

You have a query that retrieves customers and their locations. You have a sample of the data as shown in the following table.

Additional customers and locations are added frequently.
You need to transform the data as shown in the following table.

What should you do?

A. Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into columns.
B. Select the Customer columns, and then click Unpivot Other Columns.
C. Select the Customer columns, and then click Unpivot Columns.
D. Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into rows.

問題 #4

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.

A. From PivotTable Fields, modify the Field Settings for DatelMonth Year].
B. From PivotTable Fields, add Date[Year] to the Rows area.
C. In the data model, modify the Sort by Column setting for Sales[Date].
D. In the data model, modify the Sort By Column setting for Date[Month Year].

問題 #5

You have the PivotTable shown in the following exhibit.

You need to display only rows in the PivotTable in which the sum of LineTotal is greater than 100.
What should you do?

A. Add a slicer for LineTotal and select the values from the slicer.
B. From Row Label, configure a Value Filter.
C. Add LineTotal to the Filters area of PivotTable Fields. Configure the Filters value.
D. From Row Label, configure a Label filter.

解説：