IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 70-779 問題集  / 70-779 問題練習

Microsoft 70-779 問題練習

Analyzing and Visualizing Data with Microsoft Excel 試験

最新更新時間: 2019/07/10,合計120問。

平成から令和へ:70-779 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、70-779 問題集を使用してください。

 / 8

Question No : 1
HOTSPOT
You have a model that contain data relating to corporate profits. The model contains a measure named Profit.
You need to create a PivoTable to display the Profit measure in three different formats by using the Show Value As feature. The PivoTable must produce the result shown in the following table.



How should you configure the Show Value As feature for % Profit of Annual Total and % Profit of Grand Total? To answer,
Select the appropriate options in the answer area.
NOTE: Each correct selections is worth one point.
Answer Area



正解:


Explanation:
https://support.office.com/en-us/article/show-different-calculations-in-pivottable-value-f ields-014d2777-baaf-480b-a32b-98431f48bfec

Question No : 2
HOTSPOT
You have a table named Date that contains the following data.



You plan to create Pivot Charts that will be sliced by MonthName.
You need to create a relationship between Sales and Date.
Which Columns should you use to create the relationship? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.



正解:


Explanation:
Refer below



https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

Question No : 3
DRAG DROP
You have a model that contains the following table named Sales.



You have measure named TotalSales that calculates the sum of Line Total.
You plan to create a PivotChart to display TotalSale for each category and the percent of total sales for each category as shown in the following exhibit.






How should you complete the DAX formula for the Percent measure? To answer, drag the appropriate values 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.
NOTE: Each correct selection is wroth on point.



正解: DIVIDE(TotalSales , CALCULATE(LineTotal, ALL(TotalSales), 0))

Question No : 4
You have a table in Power Pivot model that is loaded from a Microsoft SQL Server database.
The source table has four columns named ID, Price, Quantity, and Total. Total is derived by multiplying Price and Quantity. ID is a unique row identifier.
You need to minimize the amount of memory used to load the mode. The solution must ensure that you can create visualizations based on Price, Quantity, and Total.
What should you do?

正解:

Question No : 5
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 be default.
What should you do?

正解:

Question No : 6
You add two tables named Date and Invoices to a data model, Invoices contains a column named InvoiceDate that has a Data Type of Date, Date contains a column named DateID that has a Data Type of which Number. DateID is in the format of YYYYMMDD.
You need to create a relationship between Date and Invoices.
What should you do first?

正解:

Question No : 7
DRAG DROP
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.



正解: SUM([SalesAmount) / ALL(SalesOrders) /(FILTER , ALL(SalesOrders))

Question No : 8
You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1.
You need to modify Goal to multiply the sales from the previous year by 1.15.
What should you do?

正解:

Question No : 9
You have the data model shown in the Data Model exhibit. (Click the Exhibit button.)



You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.)

Untitled

You need to change the current view of the PivotChart to display ProductCategory only.
What should you do?

正解:

Question No : 10
DRAG DROP
You create a new workbook and add a table to a data model. The data is shown in the following table.

Untitled

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

Untitled

Witch three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Untitled

正解:

Question No : 11
You need to create a PivotChart that has a filter as shown in the following exhibit.

Untitled

正解:

Question No : 12
You have a pie chart.
You need the wedges of the pie chart to be separated as shown in the following exhibit.

Untitled

正解:

Question No : 13
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.



正解:

Question No : 14
You have a data model in Excel.
You export the data and the data model into a dataset in the Microsoft Power BI service.
What can you use to modify the data model that is published to the Power BI service?

正解:

Question No : 15
Your network contains a folder that has data files m various formats.
You need to identify how many files of each extension type are in the folder by using Query Editor.
What should you do?

正解:

 / 8