Free Microsoft 70-779 Exam Dumps Questions & Answers
| Exam Code/Number: | 70-779Join the discussion |
| Exam Name: | Analyzing and Visualizing Data with Microsoft Excel |
| Certification: | Microsoft |
| Free Question Number: | 118 |
| Publish Date: | Nov 16, 2026 |
| # of views: | 6697 |
|
|
|
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?
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 of repeated scenario
You are creating reports for a car repair company. You have four datasets in Excel spreadsheets. Four workbook queries load the datasets to a data model. A sample of the data is shown in the Data Sample exhibit.
Data Sample exhibit:



The data model is shown in the Data Model exhibit. (Click the Exhibit button.)
The tables in the model contain the following data:
* DailyRepairs has a log of hours and revenue for each day, workshop, and repair type. Every day, a log entry is created for each workshop, even if no hours or revenue are recorded for that day. Total Hours and Total Revenue column.
* Workshops have a list of all the workshops and the current and previous workshop managers. The format of the Workshop Manager column is always Firstname Lastname. A value of 1 in the IsLatest column indicates that the workshop manager listed in the record is the current workshop manager.
* RepairTypes has a list of all the repair types
* Dates has a list of dates from 2015 to 2018
End of repeated scenario.
When you attempt to create a relationship between DailyRepairs and Workshops, Power Pivot generates the following error message: "The relationship cannot be created because each column contains duplicate values.
Select at least one column that contains only unique values".
You need to ensure that you can create a valid relationship between the tables.
What should you do?
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?
Your company has sales offices in several cities.
You create a table that represents the amount of sales in each city by month as shown in the exhibit.
You need to ensure that all values lower than 250 display a red icon. The solution must ensure that all values greater than 500 display a green icon.
Solution: You create a measure, and then define a target value.
Does this meet the goal?
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 answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
