70-779 무료 덤프문제 온라인 액세스

You have a table that contains the following data.

You need to create a PivotTable as shown in the exhibit. (Click the Exhibit button.)

How should you configure the PivotTable? 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

Box 1: Columns: Customers
Box 2: Rows: Products
Box 3: Values: Quantity
Box 4: Filters: Country

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

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 Format menu, click Clean.
• C.From the Extract menu, click Last Characters.
• D.From the Split Column menu, click By Delimiter.

You have a table that contains sales data.
You need to create a Pivot Table that will display the sales by country as shown in the following exhibit.

What should you use to display the icons?

• A.a measure
• B.a KPI
• C.conditional formatting
• D.data validation

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.
Solution: Create a PivotTable that uses the ProductName field in the Rows area.
Does this meet the goal?

• A.No
• B.Yes