70-779

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 chokes, but the text of the scenario is the same in each question in this series. Start...

You add two tables named Date and Invoices to a data model, Invoices contains a column named InvoiceDate that has a Data Type of Date, Date contains a column named DateID that has a Data Type of which Number. DateID is in the format of YYYYMMDD. You need to create...

DRAG DROP You have a data model that contains a table named SalesOrders has four columns named Orderld, SalesAmount, OrderDate, and Territory. You plan to create a PivotChart that will display the percentage of SalesAmount for each Territory. You need to create a measure to calculate the percentage of sales...

You have a pie chart. You need the wedges of the pie chart to be separated as shown in the following exhibit. A . Change the chart type to Pie of Pie.B . Right-click the pie chart, click Expand/Collapse, and then click Expand.C . Right-click the pie chart, click Expand/Collapse,...

You have a table named Sales that has three columns named OrderDate, OrderNumber, and SalesAmount. You need to create the PivotTable as shown in the following table. What should you use?A . KPIsB . sparklinesC . conditional formattingD . banded rowsView AnswerAnswer: A

Your network contains a folder that has data files m various formats. You need to identify how many files of each extension type are in the folder by using Query Editor. What should you do?A . Create a query that uses a file source, and then use the Count Values...

You have the Excel worksheet shown in the exhibit. You need to transform the data by using Query Editor. What should you do first?A . From the Data tab, Click From Table/Range.B . From the Insert tab, Click Store.C . From the Data tab, Click Flash Fill.D . From the...

DRAG DROP You have 12 sales reports stored in a folder as CSV files. Each report represents one month of sales data for a year. The reports have the same structure. You need to analyze the entire year of sales data. Which three actions should you perform in sequence? To...

You have a workbook query that loads the following table. You pivot the table on the key column by using value as the values column, and you receive the results shown in the following table. You need to ensure that the data appears as shown in the following table. A...

You have a KPI named Goal that calculates the sales from the previous year and multiplies the sales by 1.1. You need to modify Goal to multiply the sales from the previous year by 1.15. What should you do?A . From Power Pivot, modify the measure.B . From the properties...