Microsoft Excel - Power BI - MCSA 070-779

Certification exams change, and Getcertkey keeps pace: the 070-779 practice question set is reviewed continuously and updated free of charge for 365 days. Your Microsoft Analyzing and Visualizing Data with Microsoft Excel preparation stays aligned with the current exam throughout 2026 and beyond.

Microsoft 070-779 Exam Overview:

Certification Vendor:	Microsoft
Exam Name:	Analyzing and Visualizing Data with Microsoft Excel
Exam Number:	70-779
Exam Price:	USD price historically around 165 (retired exam pricing varied)
Exam Duration:	150 minutes
Passing Score:	700 (scaled score)
Certificate Validity Period:	Retired – this exam was officially retired January 31, 2021
Exam Format:	Multiple choice, Scenario based
Related Certifications:	MCSA: BI Reporting
Available Languages:	English
Real Exam Qty:	Approximately 40
Sample Questions:
Exam Way:	Onsite and Online proctored delivery when it was active (via Pearson VUE)
Pre Condition:	Strong understanding of Microsoft Excel data analysis and visualization; recommended experience with Power Query, Power Pivot, PivotTables, DAX
Official Syllabus URL:	https://learn.microsoft.com/en-us/answers/questions/474664/schedule-retired-exam-70-779-analyzing-and-visuali

Microsoft 070-779 Exam Syllabus Topics:

Common Questions About the Microsoft 070-779 Exam

What is the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam all about?

The 070-779 exam is the official Microsoft exam behind the Microsoft Excel - Power BI - MCSA certification, validating the skills measured by the Microsoft Analyzing and Visualizing Data with Microsoft Excel credential. It sits at the Professional / MCSA-level (BI Reporting) level of the Microsoft certification program. It also connects to MCSA: BI Reporting, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 070-779 exam, and how much time do I get?

The 070-779 exam contains Approximately 40 questions to be completed within 150 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 070-779 exam, and what does it cost?

The passing score for the 070-779 exam is 700 (scaled score), and the official registration fee is USD price historically around 165 (retired exam pricing varied). Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 118 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 070-779 exam?

Strong understanding of Microsoft Excel data analysis and visualization; recommended experience with Power Query, Power Pivot, PivotTables, DAX Requirements can change when Microsoft revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

Can I try the 070-779 practice questions before I buy?

Yes. Getcertkey provides a free 070-779 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Microsoft revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 070-779 exam, and how is my order delivered?

Every Microsoft Analyzing and Visualizing Data with Microsoft Excel purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 070-779 exam?

The Microsoft Analyzing and Visualizing Data with Microsoft Excel exam blueprint is organized into 3 domains. The first three are:

• Model Data — 35-40 of the exam
• Consume and Transform Data by Using Microsoft Excel — 30-35 of the exam
• Visualize Data — 30-35 of the exam

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

Microsoft Analyzing and Visualizing Data with Microsoft Excel Sample Questions:

Question 1

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.

Question 2

You have the following tables.

There is a relationship between the tables.
You need to create a measure that displays how many users have a total TimeInMinutes that is greater than 60.
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.

Question 3

You have a pie chart.
You need the wedges of the pie chart to be separated as shown in the following exhibit.

A. Select a wedge of the pie chart and then drag the wedge.
B. Right-click the pie chart, click Expand/Collapse, and Then click Expand Entire Field
C. Right-click the pie chart, click Expand/Collapse, and then click Expand.
D. Change the chart type to Pie of Pie.

Question 4

You need to create a PivotChart as shown in the exhibit. (Click the Exhibit button.) Exhibit:

Which field should you use for each area? 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.

Question 5

You have two visualizations as shown in the following exhibit.


Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Solutions: