Three versions, and most candidates end up choosing the APP online test engine — find out why: the Microsoft Analyzing and Visualizing Data with Microsoft Excel material at TestsDumps, 118 practice questions for the 70-779 exam.
Microsoft 70-779 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Analyzing and Visualizing Data with Microsoft Excel |
| Exam Number: | 70-779 |
| Certificate Validity Period: | Retired January 31, 2021; previously valid for 2 years |
| Exam Duration: | 120 minutes |
| Passing Score: | 700 / 1000 |
| Exam Price: | $165 USD (varies by region) |
| Real Exam Qty: | 40-60 |
| Available Languages: | English |
| Exam Format: | Multiple choice, Scenario-based, Multiple response, Performance-based |
| Related Certifications: | 70-778: Analyzing and Visualizing Data with Power BI |
| Recommended Training: | Microsoft Official Exam Ref 70-779 Microsoft Learn BI Reporting Learning Path |
| Exam Registration: | Microsoft Learn Exam Page |
| Sample Questions: |  |
| Exam Way: | Proctored onsite or online via Microsoft authorized partners; retired since Jan 31, 2021 |
| Pre Condition: | No formal prerequisites; recommended strong Excel proficiency and basic data analysis experience |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/70-779/ |
Microsoft 70-779 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Model Data | 35-40% | - Optimize model performance
|
| Visualize Data | 30-35% | - Integrate with Power BI
|
| Consume and Transform Data by Using Microsoft Excel | 30-35% | - Import data from multiple sources
|
Microsoft 70-779 Exam: Engine Answers
The Microsoft Analyzing and Visualizing Data with Microsoft Excel is Microsoft's certification exam for MCSA: BI Reporting, at the Associate / MCSA level. It's demanding enough to intimidate — timed practice is the cure. Related credentials include 70-778: Analyzing and Visualizing Data with Power BI.
Yes:
After any course, build confidence with the 118 practice questions for the Microsoft Analyzing and Visualizing Data with Microsoft Excel — every answer expert-verified.
Through the vendor's official registration channels:
The Microsoft Analyzing and Visualizing Data with Microsoft Excel is delivered Proctored onsite or online via Microsoft authorized partners; retired since Jan 31, 2021 — pick the arrangement that suits you when booking.
120 minutes for 40-60 questions. The TestsDumps APP engine imitates the real test — set timed exams, mark performance, point out mistakes — so exam day feels rehearsed.
The Microsoft Analyzing and Visualizing Data with Microsoft Excel blueprint spans 3 domains — including Model Data (35-40%), Visualize Data (30-35%), Consume and Transform Data by Using Microsoft Excel (30-35%). The complete outline above lists every subtopic; our IT staff keep the material aligned daily.
No formal prerequisites; recommended strong Excel proficiency and basic data analysis experience Eligibility rules change over time, so verify the current requirements on the official page (official 70-779 exam page) before registering.
$165 USD (varies by region) per attempt, 700 / 1000 to pass. Retakes cost the full fee — practice whenever you want with the 118 practice questions for the 70-779 exam at TestsDumps.
Soon after payment you receive the Microsoft Analyzing and Visualizing Data with Microsoft Excel material by automatic email — about a minute, with Credit Card payment and a strict information system keeping money and data safe; our 7*24 service replies within 2 hours, even on official holidays. If you fail the corresponding 70-779 exam within 60 days of purchase, we refund in full: send a scanned enrollment slip plus the official Score Report PDF within 2 days of the exam, processed within 7 days. Excluded: exams within 3 days of purchase, candidate names that don't match the payer, and free or expired products. Or exchange for two equal-value products free.
Yes — download the free Microsoft Analyzing and Visualizing Data with Microsoft Excel demo and feel the engine before paying. Purchases include 365 days of free updates by email; renew afterward at 50% off.
Microsoft Analyzing and Visualizing Data with Microsoft Excel Sample Questions:
You need to create a PivotChart that has a filter as shown in the following exhibit.
What should you do first?
- A. From the model, create a measure.
- B. From the model, create a hierarchy.
- C. From Query Editor, create a function.
- D. From Query Editor, create a parameter.
Correct Answer: A 🗳️
Explanation: Only visible for TestsDumps members. You can sign-up / login (it's free).
You create the PivotChart shown in the exhibit. (Click the Exhibit button.) Exhibit:
In which area is Product and in which area is SalesAmount? 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.
Correct Answer:
Explanation
Box 1: Product: Axis
Box 2: SalesAmount: Values
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 a relationship between Date and Invoices.
What should you do first?
- A. Create a calculated column in Invoices that uses the Format DAX function.
- B. Change the Data Type of InvoiceDate and DateID to Text.
- C. Change the Data Type of DateID to Date.
- D. Create a measure in Invoices that uses the Format DAX Function.
Correct Answer: C 🗳️
Explanation: Only visible for TestsDumps members. You can sign-up / login (it's free).
You need to create a combo chart to display the count of orders by month and profit by month as shown in the exhibit. (Click the Exhibit tab.)
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.
Correct Answer:
Explanation
Order Count:Stacked columnNo
Profit:LineYes
http://www.excel-easy.com/examples/combination-chart.html
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 have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.) Exhibit:
Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You plan to use the DAX time intelligence functions of DATEADD and DATESMTD.
You need to ensure that the functions return the correct data.
What should you do first?
- A. Change the Data Type of FactSales[DateKey].
- B. Change trie Data Type of DimDate[DateKey].
- C. Delete and recreate the relationship between FactSales and DimDate.
- D. Mark DimDate as the date table.
Correct Answer: D 🗳️
Explanation: Only visible for TestsDumps members. You can sign-up / login (it's free).
Viewing page 1 out of 24 pages.
Viewing questions 1-5 out of 118 questions.
Kenneth 
Cedric 
Sheila 
Lena 
Eric 
Michael 
Will 
Gwendolyn 
Edison 
Sebastian 
Pearl 
Belinda 
Kerwin 
Uriah 
Priscilla 
Jack 
Lucien 
