Provides a valid Microsoft MCSA 70-779 exam dumps | 100% Free

Examsall shares online exam exercise questions all year round! Microsoft MCSA 70-779 exam “Analyzing and Visualizing Data with Microsoft Excel”
https://www.lead4pass.com/70-779.html (109 Q&As).Continue to study and we provide an updated cisco 70-779 exam practice questions and answers. You can practice the test online!

Watch the Microsoft MCSA 70-779 video tutorial online

Table of Contents:

Latest Microsoft MCSA 70-779 pdf

[PDF] Free Microsoft MCSA 70-779 pdf dumps download from Google Drive: https://drive.google.com/open?id=1rKYauOFwJ2UkXI0L6DoAlcKkh3HrgCP5

Exam 70-779: Analyzing and Visualizing Data with Microsoft Excel:https://www.microsoft.com/en-us/learning/exam-70-779.aspx

Skills measured

This exam measures your ability to accomplish the technical tasks listed below.

  • Consume and Transform Data by Using Microsoft Excel (30-35%)
  • Model Data (35-40%)
  • Visualize Data (30-35%)

Who should take this exam?

Candidates for this exam should have a strong understanding of how to use Microsoft Excel to perform data analysis. Candidates should be able to consume, transform, model, and visualize data in Excel. Candidates should also be able to configure and manipulate data in PowerPivot, PivotTables, and PivotCharts. Candidates may include BI professionals, data analysts, and other roles responsible for analyzing data with Excel.

Microsoft MCSA 70-779 Exam Practice Questions

QUESTION 1

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:lead4pass 70-779 exam question q1

The data model is shown in the Data Model exhibit. Data Model:

lead4pass 70-779 exam question q1-1

A. In the workbook query for Workshops, filter [IsLatest] to equal 1.
B. In the workbook query for Workshops, add an index column.
C. In the Power Pivot model, change the data type for Workshop[lD] to General.
D. In the Power Pivot model, change the Table Behavior setting for Workshops.
Correct Answer: D

 

QUESTION 2
You have the PivotTable shown in the following exhibit.lead4pass 70-779 exam question q2

You need to display only rows in the PivotTable in which the sum of LineTotal is greater than 100. What should you do?
A. From Row Label, configure a Label filter.
B. Add a slicer for LineTotal and select the values from the slicer.
C. From Row Label, configure a Value Filter.
D. Add LineTotal to the Filters area of PivotTable Fields. Configure the Filters value.
Correct Answer: D

 

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

lead4pass 70-779 exam question q3

You need to ensure that the PivotTable appears in three columns as shown in the following exhibit.

lead4pass 70-779 exam question q3-1

A. On the Design tab, click Report Layout and then click Show in Compact Form.
B. Move Country from the Rows area to the Columns area.
C. Move Country from the Rows area to the Values area.
D. On the Design tab, click Report Layout and then click Show in Tabular Form.
Correct Answer: D

 

QUESTION 4
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 following table.

lead4pass 70-779 exam question q4

NOTE: Each correct selections is worth one point.
Hot Area:

lead4pass 70-779 exam question q4-1

Correct Answer:

lead4pass 70-779 exam question q4-2

% Profit of Annual Total: % of Parent Total % Profit of Grand Total: % of Column Total
https://support.office.com/en-us/article/show-different-calculations-in-pivottable-value-fields-014d2777-baaf-480b-a32b-98431f48bfec

 

QUESTION 5
You have a workbook query that loads data from a table named Products.
Products contains a column named IntemalPrice that has a Data Type of Decimal.
From Query Editor you create a custom column named ResellerPrice that uses a formula to multiply InternalPrice by
1.2, and then you remove the IntemalPrice column.
What will occur when you load the data to a worksheet?
A. All the columns except InternalPrice will load to the worksheet The values in ResellerPrice will be correct.
B. An error message will appear and all the data will fail to load.
C. An error message will appear and all the columns except InternalPnce and ResellerPrice will load to the worksheet.
D. All the columns except InternalPrice will load to the worksheet. The values in ResellerPrice will be null.
Correct Answer: A

 

QUESTION 6
You need to create a combo chart to display the count of orders by month and profit by month as shown in the exhibit.lead4pass 70-779 exam question q6

How should you configure the combo chart? To answer, select the appropriate options in the answer area. NOTE: Each
correct selection is worth one point.
Hot Area:

lead4pass 70-779 exam question q6-1

Correct Answer:

lead4pass 70-779 exam question q6-2

Order Count:Stacked column No Profit:Line Yes http://www.excel-easy.com/examples/combination-chart.html

 

QUESTION 7
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 of the KPI, modify the KPI base field.
C. From Power Pivot, create a new calculated column, and then modify the KPI.
D. From the properties of the KPI, modify the absolute value.
Correct Answer: B


QUESTION 8
You have a table named Sales. Sales contains the following columns.lead4pass 70-779 exam question q8

You need to add a column that shows the first three letters of the day of the week.
How should you complete the DAX formula? To answer, drag the appropriate values to the correct targets.
Each value 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.
Select and Place:

lead4pass 70-779 exam question q8-1

Correct Answer:

lead4pass 70-779 exam question q8-2

 

QUESTION 9
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.lead4pass 70-779 exam question q9

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. Yes
B. No
Correct Answer: B


QUESTION 10
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 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.lead4pass 70-779 exam question q10

The data model is shown in the Data Model exhibit.

lead4pass 70-779 exam question q10-1

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 are two
measures defined in DailyRepairs. Total Hours sums the Hours column, and Total Revenue sums the Revenue column.
Workshops has 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 alt the repair types.
Dates has a list of dates from 2015 to 2018.
End of repeated scenario.
You need to add a custom column to the workbook query for Workshops that contains the email address of the
workshop manager. The format of the email address is [email protected]
How should you complete the query from Query Editor? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point
Hot Area:

lead4pass 70-779 exam question q10-2

Correct Answer:

lead4pass 70-779 exam question q10-3

 

QUESTION 11
You have a table named AnnualSales. A sample of the data in AnnualSales is shown in the following table.lead4pass 70-779 exam question q11

You need to create a PivotTable as shown in the exhibit.

lead4pass 70-779 exam question q11-1

How should you configure the Rows area and the Columns area in PivotTable Fields? 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.
Select and Place:

lead4pass 70-779 exam question q11-2

Correct Answer:lead4pass 70-779 exam question q11-3

 

QUESTION 12
You have the following table.lead4pass 70-779 exam question q12

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. Change the Data Type of [Month Name] to Date.
C. Sort the [Month Name] column by [Month Name].
D. Add a calculated column named [ID] that use the [Month Name] and [Month Number] DAX formula
Correct Answer: D


QUESTION 13
You have a workbook query that uses an Excel data source. The data source contains the following table.lead4pass 70-779 exam question q13

You need the data to appear as shown in the following table.

lead4pass 70-779 exam question q13-1

How should you transform the data from Query Editor? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

lead4pass 70-779 exam question q13-2

Correct Answer:

lead4pass 70-779 exam question q13-3

Related 70-779 Popular Exam resources

titlepdf youtube Microsoft lead4pass Lead4Pass Total Questions
Microsoft MCSA lead4pass 70-779 dumps pdf lead4pass 70-779 youtube Analyzing and Visualizing Data with Microsoft Excel https://www.lead4pass.com/70-779.html 109 Q&A

Get Lead4Pass Coupons(12% OFF)

lead4pass coupon

What are the advantages of Lead4pass?

We have a number of Cisco, Microsoft, IBM, CompTIA and other exam experts. We update exam data throughout the year.
Top exam pass rate! We have a large user base. We are an industry leader! Choose Lead4Pass to pass the exam with ease!

about lead4pass

Summarize:

The free Microsoft MCSA 70-779 exam dumps can help you improve your skills and exam experience! To pass the cisco 70-779 exam at once: https://www.lead4pass.com/70-779.html We make Microsoft 70-779 videos and 70-779 pdf for you to learn! I hope you can pass the exam easily.