Online Access Free 70-779 Exam Questions
| Exam Code: | 70-779 |
| Exam Name: | Analyzing and Visualizing Data with Microsoft Excel |
| Certification Provider: | Microsoft |
| Free Question Number: | 118 |
| Posted: | Aug 28, 2026 |
You have a date column named [Date] in the format of mm-dd-yyyy.
You need to create a column named Quarter that displays the yearly quarter. A sample of the desired data is shown in the following table.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
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, white 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 query named Query1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved t]y the query is shown in the following table.
You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.
Solution: You select the-UserName and Location columns, and then you click Remove Duplicates.
Does this meet the goal?
You have a query that retrieves customers and their locations. You have sample of the data as shown in the following table.
Additional customers and locations are added frequently.
You need to transform the data as shown in the following table.
What should you do?
You have an Excel spreadsheet that contains a PivotChart.
You install Microsoft Power BI Publisher for Excel.
You need to add a tile for the PivotChart to a Power BI dashboard.
What should you do?
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?