070-779 試験問題を無料オンラインアクセス

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

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

• A.Right-click the pie chart, click Expand/Collapse, and then click Expand.
• B.Select a wedge of the pie chart and then drag the wedge.
• C.Right-click the pie chart, click Expand/Collapse, and Then click Expand Entire Field
• D.Change the chart type to Pie of Pie.

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

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 the following data.

You need to retrieve a list of the unique ProductName entries.
Select the ProductName column, and then click Group on the Data tab.
Does this meet the goal?

• A.Yes
• B.No

You have two visualizations as shown in the following exhibit.


Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

正解：