Some candidates read on the train, others drill on a laptop, others review on a phone. Whichever you are, ExamTorrent has a format for the 070-779 exam: a printable PDF, a Windows desktop test engine, or an online engine — all carrying the same 118 practice questions.
Microsoft 070-779 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Model Data | - Create calculated columns and measures using DAX - Create and manage data models using Power Pivot - Define relationships between tables |
| Topic 2: Publish and Share Data | - Manage and consume shared reports - Publish Excel workbooks to Power BI or SharePoint |
| Topic 3: Visualize Data | - Create PivotTables and PivotCharts - Design interactive dashboards in Excel - Apply filters, slicers, and conditional formatting |
| Topic 4: Consume and Transform Data | - Combine and append datasets - Clean, shape, and transform data - Get data from various sources using Excel and Power Query |
Microsoft Analyzing and Visualizing Data with Microsoft Excel Exam FAQ Hub
Registering for the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam costs $165 USD (varies by region), and you need 700 (on a 1000-point scale) to pass. One detail worth remembering: a failed attempt is not discounted — retaking the exam means paying $165 USD (varies by region) again in full. Use the ExamTorrent test engine to benchmark yourself first; when your mock results consistently clear 700 (on a 1000-point scale), you are ready to book.
The 070-779 exam is Microsoft's official test for the MCSA: BI Reporting (retired) credential, a certification at the Associate level. Earning it tells employers your skills have been verified by the vendor itself, which carries real weight in hiring and promotion decisions. Within the same certification track, it sits alongside MCSA: BI Reporting, Microsoft Certified: Data Analyst Associate (Power BI - successor track), so it can also serve as a stepping stone toward those credentials.
Microsoft divides the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam into 4 domains. The largest ones are Model Data, Consume and Transform Data, Visualize Data — together these account for the bulk of your score, so start there. The complete domain-by-domain outline appears in the exam topics section above on this page.
Two layers of protection here. First, delivery: your 070-779 product is available for instant download, and a copy lands in your email within one minute of payment — if 2 hours pass with nothing (check spam first), our support team will resend it. There is no cap on how many computers you can install it on. Second, the refund policy: if you take the 070-779 exam within 60 days of purchase and fail, you may claim a full refund. The claim needs a scanned enrollment slip plus your official Score Report PDF, filed within 2 days after the exam, and it is settled within 7 days. The policy covers only the corresponding exam — attempts within 3 days of purchase, exams never actually taken, free materials, and expired orders are excluded, and the candidate's name must match the payer's. If you would rather keep studying, you can instead exchange your product for two free exam products of equal value and keep the update service on your original purchase.
You will face 40-60 (approximate range) questions in 120 minutes on the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam. Do the math and the per-question budget is tight, which is why pacing drills matter as much as content review. Our advice: take two or three full timed mocks in the ExamTorrent engine before the real thing, and practice skipping a stubborn question instead of burning five minutes on it.
Yes — Microsoft lists these official training options for Microsoft Analyzing and Visualizing Data with Microsoft Excel candidates:
Formal training teaches the syllabus; then the 118 practice questions from ExamTorrent show you whether that knowledge holds up under real exam conditions.
Of course. ExamTorrent publishes a free PDF demo for the Microsoft Analyzing and Visualizing Data with Microsoft Excel exam so you can review real sample questions and answers first. Every purchase also includes 365 days of free updates, and after that period you can renew the update service at a 50% discount directly from your member zone.
No formal prerequisites, but experience with Excel 2016, Power Query, and Power Pivot is strongly recommended Eligibility rules are set by Microsoft and do change from time to time, so double-check the latest requirements on the official exam page at https://learn.microsoft.com/en-us/credentials/certifications/exams/70-779 before you register.
Registration for the 070-779 exam runs through these official channels:
As for how you will actually sit the exam: Online proctored or test center exam (Pearson VUE). Choose whichever delivery option suits your setup when you book.
Microsoft Analyzing and Visualizing Data with Microsoft Excel Sample Questions:
You have 20 workbook queries that load 20 CSV files to a local computer.
You plan to send the workbook and the 20 CSV files to several users. The users will store the files in various location.
You need to ensure that the users can change the path to the CSV files in the queries as quickly as possible.
What should you do from Query Editor?
- A. Append all the queries. Edit the source of the first query.
- B. For each query, create a new query that uses a reference. Modify the source of each new query.
- C. Create a parameter. Modify the source of each query to use the parameter.
- D. Merge all the queries. Edit the source of the first query.
Correct Answer: C 🗳️
Explanation: Only visible for ExamTorrent members. You can sign-up / login (it's free).
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.
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 new conditional formatting rule that uses the Format only cells that contain rule type.
Does this meet the goal?
- A. No
- B. Yes
Correct Answer: B 🗳️
Explanation: Only visible for ExamTorrent members. You can sign-up / login (it's free).
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.
Correct Answer:
Explanation
Click From CSV, and then select the first file in the folder.
Edit the query, and then click Append Queries.
From the Power Pivot tab, click Add to Data Model.
You have a workbook query that loads data from a table in a Microsoft Azure SQL database. The table has a column named LineTotal. The following is a sample of the data in LineTotal:
* 40
* 1
* 999
* 7658
* 883432
You need to ensure that when you load the data to the model, LineTotal is set as currency.
What should you do from Query Editor?
- A. Configure the Data Type
- B. Split the column by characters.
- C. Round the column.
- D. Split the column by delimiter.
Correct Answer: A 🗳️
You have the following tables in a data model.
You create a PivotTable to display SaleAmount by Month. A sample of the results are shown in the following table.
You need to ensure that the data appears in chronological order.
What should you do?
- A. From PivotTable Fields, modify the Field Settings for Date[Month Year]
- B. In the data model, modify the Sort By Column setting for Date[Month Year]
- C. From PivotTable Fields, add Date[Year] to the Rows area
- D. In the data model, modify the Sort by Column setting for Sales[Date]
Correct Answer: A 🗳️
Viewing page 1 out of 24 pages.
Viewing questions 1-5 out of 118 questions.
1130 Customer Reviews
