70-779

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...

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...

You create an Excel workbook named SalesResults.xlsx. You create a workbook query that connects to a Microsoft SQL Server Database and loads data to the data model. You create a PivotTable and PivotChart. You plane to share SalesResults.slsx to several users outside of your organization. You need to ensure that...

You have an Excel workbook that has the following two workbook queries: A query named consultants that retrieves a table named Consultants_Contact from a Microsoft SQL Server database A query named employees that retrieves a table named Employee_Contact from a Microsoft Azure SQL database Both tables have the same columns....

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?A . Sort the [Month Name] column by [Month Name].B...

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...

HOTSPOT You have a workbook query that uses an Excel data source. The data source contains the following table. You need the data to appear as shown in the following table. How should you transform the data from Query Editor? To answer, select the appropriate options in the answer area....

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. A . On the Design tab, click Report...

DRAG DROP You create a new workbook and add a table to a data model. The data is shown in the following table. You need to create a visualization as shown in the following exhibit. Witch three actions should you perform in sequence? To answer, move the appropriate actions from...

DRAG DROP You use a workbook query to import a table named Customers that contains a column named CustomerName. Has names in the format of Lastname, Firstname. You need the CustomerName column to contain names in the format of FirstnameLastname. A space must separate Firstname and lastname. Which two commands...