live chatHACKER SAFEにより証明されたサイトは、99.9%以上のハッカー犯罪を防ぎます。

Microsoft 070-779問題集

070-779

試験コード:070-779

試験名称:Analyzing and Visualizing Data with Microsoft Excel

バージョン:V14.35

最近更新時間:2021-06-18

問題と解答:118 Q&As

070-779 無料でデモをダウンロード:

PDF版 Demo ソフト版 Demo オンライン版 Demo

追加した商品:"PDF版"
価格:¥5999 

無料問題集070-779 資格取得

質問 1:
You have a model that contains the following table named Sales.

You have a measure named TotalSales that calculates the sum of LineTotal.
You plan to create a PivotChart to display TotalSales 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 fields to the correct areas. Each field may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解:

Explanation
DIVIDE(TotalSales , CALCULATE(LineTotal, ALL(TotalSales), 0))

質問 2:
Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
Start of repeated scenario.
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.
(Click the Exhibit button.)
Data Sample exhibit:




The data model is shown in the Data Model exhibit. (Click the Exhibit button.)

The tables in the model contain the following data:
* DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue column.
* Workshops have a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always Firstname Lastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.
* RepairTypes has a list of all the repair types
* Dates has a list of dates from 2015 to 2018
End of repeated scenario.
To the Dates table, you need to add a calculated column named Months Ago. Months Ago must display the number of calendar months before the current month. For example, if the current date is July 10, 2017, the Value of Months Ago will be 0 for all the dates in July 2017, 1 for all the dates in June 2017, and 2 for all the dates in May 2017.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

正解:

Explanation

Box 1: MONTH
Box 2: TODAY
References:
https://msdn.microsoft.com/en-us/library/ee634914.aspx
https://msdn.microsoft.com/en-us/library/ee634567.aspx
https://msdn.microsoft.com/en-us/library/ee634554.aspx

質問 3:
You merge several CSV files by using Query Editor.
You need to remove all the leading whitespaces and all the non-printable characters from a column.
What should you do to achieve each task? To answer, drag the appropriate actions to the correct goals. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解:

Explanation

Box 1: From the Extract menu, click Trim
Box 2: From the Extract menu, click Clean

質問 4:
Note: This question is part of a series of questions that use the same scenario, For your convenience is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
Start of repeated scenario
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.

The data model is shown in the Data Model exhibit.

The tables in the model contain the following data:
DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue are two measures defined in DailyRepairs. Total Hours sums the Hours column, and Total Revenue sums the Revenue column.
Workshops has a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always Firstname Lastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.
RepairTypes has a list of alt the repair types.
Dates has a list of dates from 2015 to 2018.
End of repeated scenario.
You create a measure named Average Revenue Per Hour that calculates the average revenue per hour.
You need to populate a cell in a worksheet to display the Average Revenue Per Hour where Repair Type is Engine.
Which Excel formula should you use?

A. Option C
B. Option B
C. Option D
D. Option A
正解:C

質問 5:
You have two queries named Client and Invoices. A sample of Client is shown in the following table.

A sample of Invoices is shown in the following table.

You need to create a new table that has the following information.

Which join kind should you use?
A. Left Anti
B. Inner
C. Left Outer
D. Right Anti
正解:C
解説: (Pass4Test メンバーにのみ表示されます)

質問 6:
You have an Excel workbook query that loads data to a worksheet and the data model.
You need to ensure that the data is refreshed whenever you open the workbook.
What should you do?
A. From the Power Pivot model, modify the Table Behavior setting.
B. From the File tab, click Options, and then modify the General options.
C. From the File tab, click Option, and then modify the Data option.
D. From the Data tab, click Queries & Connections, and then edit the properties of the query.
正解:D
解説: (Pass4Test メンバーにのみ表示されます)

質問 7:
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 ISCROSSFILTERED DAX function Does this meet the goal?
A. No
B. Yes
正解:A

質問 8:
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, white 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 query named Quety1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved by the query is shown in the following table.

You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.

Solution: You sort the UserName column in ascending order. You select the UserName column, and then you click Remove Duplicates. Does this meet the goal?
A. No
B. Yes
正解:A

質問 9:
You use a workbook query to import a table named Customers that contains a column named CustomerName.
CustomerName has names in the format of Lastname, Firstname.
You need the CustomerName column to contain names in the format of Firstname Lastname. A space must separate Firstname and Lastname.
Which two commands should you use? To answer, drag the appropriate fields to the correct areas. Each field may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

正解:

Explanation
* Split Column By Delimiter
* Merge Columns
https://support.office.com/en-us/article/split-a-column-of-text-power-query-5282d425-6dd
0-46ca-95bf-8e0da9539662
https://support.office.com/en-us/article/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0

一年間無料で問題集をアップデートするサービスを提供します。

弊社の商品をご購入になったことがあるお客様に一年間の無料更新サービスを提供いたします。弊社は毎日問題集が更新されたかどうかを確認しますから、もし更新されたら、弊社は直ちに最新版の070-779問題集をお客様のメールアドレスに送信いたします。ですから、試験に関連する情報が変わったら、あなたがすぐに知ることができます。弊社はお客様がいつでも最新版のMicrosoft 070-779学習教材を持っていることを保証します。

弊社は無料でMicrosoft Excel - Power BI - MCSA試験のDEMOを提供します。

Pass4Testの試験問題集はPDF版とソフト版があります。PDF版の070-779問題集は印刷されることができ、ソフト版の070-779問題集はどのパソコンでも使われることもできます。両方の問題集のデモを無料で提供し、ご購入の前に問題集をよく理解することができます。

簡単で便利な購入方法ご購入を完了するためにわずか2つのステップが必要です。弊社は最速のスピードでお客様のメールボックスに製品をお送りします。あなたはただ電子メールの添付ファイルをダウンロードする必要があります。

領収書について:社名入りの領収書が必要な場合には、メールで社名に記入して頂き送信してください。弊社はPDF版の領収書を提供いたします。

Pass4Test問題集を選ぶ理由は何でしょうか?
 品質保証Pass4Testは試験内容に応じて作り上げられて、正確に試験の内容を捉え、最新の97%のカバー率の問題集を提供することができます。
 一年間の無料アップデートPass4Testは一年間で無料更新サービスを提供することができ、認定試験の合格に大変役に立ちます。もし試験内容が変われば、早速お客様にお知らせします。そして、もし更新版がれば、お客様にお送りいたします。
 全額返金お客様に試験資料を提供してあげ、勉強時間は短くても、合格できることを保証いたします。不合格になる場合は、全額返金することを保証いたします。(全額返金)
 ご購入の前の試用Pass4Testは無料でサンプルを提供することができます。無料サンプルのご利用によってで、もっと自信を持って認定試験に合格することができます。