2026に70-779の再受験を避けるには、本番前に不足分野を具体的に把握することが重要です。Microsoft Analyzing and Visualizing Data with Microsoft Excelに対応したFast2testの118問の問題集なら、繰り返し演習で理解度を確認しながら受験計画を立てられます。

70-779試験対策に選べる3つの学習形式

• PDF版：印刷して持ち運べる形式で、専門家が作成した内容をすぐにダウンロードして確認できます。学習場所を選ばず、365日間の無料更新と無料PDFサンプルに対応しています。
• Desktop Test Engine：インストールして使用するソフトウェアで、実際の試験環境を再現した2つの練習モードを利用できます。オフライン学習に対応し、Windowsで動作します。
• Online Test Engine：ブラウザーからすぐにアクセスでき、学習履歴と成績を確認できます。Windows、Mac、Android、iOSで利用できます。

Fast2testの安心な購入・利用サポート

• McAfeeのセキュリティサービスにより、お客様の情報を安全に取り扱います。
• ご購入後365日間は無料で更新版をご利用いただけます。更新期間の終了後も、50%割引で継続更新が可能です。
• ご入金確認後はすぐにダウンロードでき、通常1分以内にメールでもお届けします。2時間経っても届かない場合は、カスタマーサポートへご連絡ください。
• インストール可能なパソコン台数に制限はありません。

Microsoft Analyzing and Visualizing Data with Microsoft Excelの試験情報

Microsoft 70-779 試験概要:

70-779試験の出題範囲

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

70-779試験の疑問を解消するFAQ

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

問題 #1

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 SalesAmount to the Rows area and add UnitPrice to the Values area.
Right-click a cell value for UnitPrice and modify the Field 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 UnitPrice to the Rows area and add SalesAmount to the Values area.
Right-click a cell value for UnitPrice and modify the Group settings.

問題 #2

From a workbook query, you import a table that has the following data.

You need to configure the table to appear as shown in the following table.

What should you do?

A. From the Format menu, click Trim.
B. From the Extract menu, click Last Characters.
C. From the Format menu, click Clean.
D. From the Split Column menu, click By Delimiter.

問題 #3

You have a measure that is used by a KPI.
You need to display the output of the measure in a cell in your workbook.
Which Excel function should you use?

A. LOOKUP
B. CUBESET
C. CUBEVALUE
D. VLOOKUP

問題 #4

You have a measure named SalesGrowth that calculates the percent of sales growth. The measure uses the following formula.
([Total Sales Current Year] - [Total Sales Last Year]) / [Total Sales Last Year] Total Sales Current Year is a measure that calculates the sales from the current calendar year. Total Sales Last Year is a measure that calculates the sales from the previous calendar year.
You need to create a KPI that displays a red icon when the sales growth is less than last year.
What should you use to define the target value?

A. the Total Sales Last Year measure
B. an absolute value of 0
C. an absolute value of 100
D. the Total Sales Current Year measure

問題 #5

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.
Repair types has a list of all the repair types.
Dates has a list of all the repair types.
Dates has a list of dates from 2015to 2018.
End of repeated scenario.
You need to create a PivotChart that displays the month, the hours of the month, and the hours of the previous month, as shown in the following exhibit.

Which DAX formula should you use for the Total Hours Last Month 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 may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

解説：