- Exam Code: 70-779
- Exam Name: Analyzing and Visualizing Data with Microsoft Excel
- Updated: Sep 02, 2026
- Q & A: 118 Questions and Answers
From a free demo to 365 days of free updates, Actual4Dumps covers every stage of your 70-779 preparation in one place. Study the 118 practice questions for the Microsoft Analyzing and Visualizing Data with Microsoft Excel and book your exam date with confidence.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Analyzing and Visualizing Data with Microsoft Excel |
| Exam Number: | 70-779 |
| Real Exam Qty: | 40-60 |
| Passing Score: | 700 / 1000 |
| Related Certifications: | 70-778: Analyzing and Visualizing Data with Power BI |
| Exam Format: | Multiple response, Multiple choice, Performance-based, Scenario-based |
| Exam Price: | $165 USD (varies by region) |
| Exam Duration: | 120 minutes |
| Available Languages: | English |
| Certificate Validity Period: | Retired January 31, 2021; previously valid for 2 years |
| 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/ |
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Consume and Transform Data by Using Microsoft Excel | 30-35% | - Clean and transform data
|
| Topic 2: Visualize Data | 30-35% | - Integrate with Power BI
|
| Topic 3: Model Data | 35-40% | - Create and manage data models
|
The Microsoft Analyzing and Visualizing Data with Microsoft Excel is the official Microsoft exam that leads to the MCSA: BI Reporting certification at the Associate / MCSA level. Passing it validates your skills against Microsoft standards and proves your qualification to current and future employers. The credential is also connected with related certifications such as 70-778: Analyzing and Visualizing Data with Power BI, so it can serve as a solid step in a broader certification path.
The 70-779 exam has 40-60 questions in total and must be completed within 120 minutes. That leaves only a narrow time budget per item, so train yourself to flag a difficult question, move on, and circle back later instead of getting stuck. A week or two before your test date, run at least one full timed mock exam in the Actual4Dumps desktop or online test engine under the same 120 minutes limit, and repeat until you can finish with a few minutes left for review.
The passing score for the 70-779 exam is 700 / 1000, and the official registration fee is $165 USD (varies by region). Keep in mind that a failed attempt is not discounted — retaking the exam means paying the full fee again — so it is wise not to book your seat until your practice scores sit comfortably above the passing mark. Working through the 118 questions at Actual4Dumps in timed mode is a reliable way to judge when you are truly ready.
Microsoft sets the following requirement for the 70-779 exam: No formal prerequisites; recommended strong Excel proficiency and basic data analysis experience. Eligibility rules can change from time to time, so always confirm the current prerequisites on the official exam page at https://learn.microsoft.com/en-us/credentials/certifications/exams/70-779/ before you register.
You can register for the Microsoft Analyzing and Visualizing Data with Microsoft Excel through the following official channels:
The 70-779 exam is delivered as Proctored onsite or online via Microsoft authorized partners; retired since Jan 31, 2021, so review the technical and check-in requirements for that format when you schedule your appointment.
Microsoft recommends the following official training options for the Microsoft Analyzing and Visualizing Data with Microsoft Excel:
Official courses build the theory, and pairing them with the 118 practice questions from Actual4Dumps turns that knowledge into exam-ready answers.
Yes. Actual4Dumps offers a free PDF demo for the Microsoft Analyzing and Visualizing Data with Microsoft Excel, so you can review real sample questions and judge the quality before paying anything. After your purchase, you receive 365 days of free updates — whenever the question pool changes, you get the latest version at no cost. Once that period expires, you can extend your update service at a 50% discount from your member zone.
If you take the 70-779 exam within 60 days of your purchase and do not pass, you can apply for a full refund under our 100% Money Back Guarantee. To qualify, submit a scanned copy of your exam enrollment slip together with your official Score Report (PDF) within 2 days after the exam date, and your claim will be processed within 7 days. Note that the guarantee applies only to the corresponding exam: attempts taken within 3 days of purchase, downloaded-but-unused materials, free resources, and expired orders are not eligible, and the candidate name must match the purchaser name. If you would rather not refund, you can exchange the product for two free exam products of equal value while keeping the update service on your original purchase.
Delivery is instant: your files are available to download right after payment and are also sent to your email within one minute. If nothing arrives within 2 hours, contact our support team (and check your spam folder first). There is no limit on the number of computers you can install the product on.
The Microsoft Analyzing and Visualizing Data with Microsoft Excel is organized into 3 domains. Among the first ones are Visualize Data (30-35%), Model Data (35-40%), Consume and Transform Data by Using Microsoft Excel (30-35%), and the remaining domains cover the rest of the official objectives. For the complete topic breakdown with every subtopic, see the full 70-779 exam outline above on this page.
Question 1
You have the data model shown in the Data Model exhibit. (Click the Exhibit button.)
You have the PivotChart shown in the Pivot Chart exhibit. (Click the Exhibit button.)
You need to change the current view of the PivotChart to display ProductCategory only.
What should you do?
A. Right-click a bar in the PivotChart and click Expand Entire Field.
B. Click the - button.
C. Double-click a bar in the PivotChart.
D. Right-click the PivotChart and click Reset to Match Style
Question 2
You have the following table named SalesOrder Detail in a model.
You need to calculate the sum of SalesTotal for all the rows that have a quantity greater than 1.
Question 3
You have a model that contains data relating to corporate profits. The model contains a measure named Profit.
You need to create a PivotTable to display the Profit measure in three different formats by using the Show Value As feature. The PivotTabte must produce the results shown in the following table.
How should you configure the Show Value As feature for % Profit of Annual Total and % Profit of Grand Total? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 4
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?
A. Select the Locations columns and the select split column by delimiter. Use a comma as the delimiter and split into rows.
B. Select the Customer columns, and then click
C. Select the Location columns and then select split column by delimiter. Use a comma as the delimiter and split into columns.
D. Select the Customer columns, and then click
Question 5
You need to create a PivotChart that has a filter as shown in the following exhibit.
What should you do first?
A. From Query Editor, create a parameter.
B. From the model, create a measure.
C. From the model, create a hierarchy.
D. From Query Editor, create a function.
Solutions:
| Question 1 Answer: A | Question 2 Answer: Only visible for members | Question 3 Answer: Only visible for members | Question 4 Answer: A | Question 5 Answer: B |
Over 45369+ Satisfied Customers
I Passed 70-779 exam with about 95%. It is totally out of my expection. Valid and latest 70-779 exam questions!
My colleagues and I have bought many Microsoft Excel - Power BI - MCSA exams from you.
Now I can relax.
Good, all of the 70-779 questions are the real ones.
hello. passed 70-779 exam in today with a 90%
I concluded that the 70-779 practice test is a good learning material for the 70-779exam. You can not only learn from it, but also pass the exam with it.
Thank you!
Just passed 70-779 exam.
All my firend feel incredible after I passed 70-779 exam, because I have failed once. Actual4Dumps helped me, thank you so much!
After practicing 70-779 exam dumps for several days, i attended my 70-779 exam and found quite easy to write it. And i got a high score. No wander so many people use exam questions from Actual4Dumps, it is worthy to trust!
It's funny that just a week before the exam I knew nothing about 70-779 exam, but with Actual4Dumps's exam questions, i studied very quickly and passed the 70-779 exam easily without spending any money and lot of time on preparing.
Actual4Dumps assures that the candidate will pass the 70-779 test, just like me.
Passed with 94%, these questions are on point
thank you Actual4Dumps guys so much for this!
I passed exam today with 97%. I just studied 70-779 dump file but it is not difficult to pass.
Thanks for 70-779 practice braindumps! I have passed my exam and finally got the certificate! It is my dream for a long time! And you helped me to make it come true. Thanks a million!
Have passed 70-779 exam.
I really need the knowledge to solve the problems in my daily work, and i can gain the certification as well. Why not buy the 70-779 exam questions? Now i got all i need. Thanks a million!
The 70-779 exam file had helped me to get easy on my 70-779 exam this Monday. Thanks! I passed it successfully! I will come back if i have other exams to attend since i am a student.
Actual4Dumps is simply amazing! I used it when I had to give my 70-779 exam and scored among the highest in my class. I would say that anyone looking for help for their 70-779 certification should definitely try Actual4Dumps. It will really help you improve your scores.
Actual4Dumps Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
We are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
If you prepare for the exams using our Actual4Dumps testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Actual4Dumps offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.