Microsoft 70-779 actual dump : Analyzing and Visualizing Data with Microsoft Excel

70-779
  • Exam Code: 70-779
  • Exam Name: Analyzing and Visualizing Data with Microsoft Excel
  • Updated: Sep 02, 2026
  • Q & A: 118 Questions and Answers

Already choose to buy "PDF"

Price: $59.99      

About Microsoft 70-779 Exam Questions

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.

Microsoft 70-779 Exam Overview:

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:Free Download Latest 70-779 actual dumps
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:

SectionWeightObjectives
Topic 1: Consume and Transform Data by Using Microsoft Excel30-35%- Clean and transform data
  • 1. Apply query parameters and M language
    • 2. Remove duplicates, handle missing values
      • 3. Split, merge, unpivot, and append columns/tables
        • 4. Change data types and format values
          - Manage query settings and load
          • 1. Combine and append queries
            • 2. Set load options and refresh properties
              - Import data from multiple sources
              • 1. Use Power Query to connect to data
                • 2. Import from text, CSV, XML, JSON, web, databases
                  Topic 2: Visualize Data30-35%- Integrate with Power BI
                  • 1. Refresh and share reports
                    • 2. Publish Excel data/models to Power BI
                      - Create and format PivotCharts and visuals
                      • 1. Format charts and apply conditional formatting
                        • 2. Create interactive dashboards
                          • 3. Select appropriate chart types
                            - Create and manage PivotTables
                            • 1. Design and configure PivotTables
                              • 2. Group and sort data
                                • 3. Apply filters, slicers, and timelines
                                  Topic 3: Model Data35-40%- Create and manage data models
                                  • 1. Create hierarchies and calculated columns
                                    • 2. Define tables, columns, and relationships
                                      • 3. Enable and use Power Pivot
                                        - Optimize model performance
                                        • 1. Reduce data size and cardinality
                                          • 2. Set appropriate data types and indexing
                                            - Implement DAX calculations
                                            • 1. Work with filter context and row context
                                              • 2. Create measures, KPIs, and calculated tables
                                                • 3. Use basic and advanced DAX functions

                                                  Microsoft Analyzing and Visualizing Data with Microsoft Excel FAQs: What Candidates Ask Most

                                                  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.

                                                  Microsoft Analyzing and Visualizing Data with Microsoft Excel Sample Questions:

                                                  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

                                                  What Clients Say About Us

                                                  I Passed 70-779 exam with about 95%. It is totally out of my expection. Valid and latest 70-779 exam questions!

                                                  Ivan Ivan       4.5 star  

                                                  My colleagues and I have bought many Microsoft Excel - Power BI - MCSA exams from you.
                                                  Now I can relax.

                                                  Quincy Quincy       4 star  

                                                  Good, all of the 70-779 questions are the real ones.

                                                  Alfred Alfred       5 star  

                                                  hello. passed 70-779 exam in today with a 90%

                                                  Stanley Stanley       4 star  

                                                  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.

                                                  Cathy Cathy       5 star  

                                                  Thank you!
                                                  Just passed 70-779 exam.

                                                  Maxwell Maxwell       4 star  

                                                  All my firend feel incredible after I passed 70-779 exam, because I have failed once. Actual4Dumps helped me, thank you so much!

                                                  Jessica Jessica       4 star  

                                                  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!

                                                  Sheila Sheila       4.5 star  

                                                  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.

                                                  Cornelius Cornelius       5 star  

                                                  Actual4Dumps assures that the candidate will pass the 70-779 test, just like me.

                                                  Stephanie Stephanie       5 star  

                                                  Passed with 94%, these questions are on point
                                                  thank you Actual4Dumps guys so much for this!

                                                  Osborn Osborn       5 star  

                                                  I passed exam today with 97%. I just studied 70-779 dump file but it is not difficult to pass.

                                                  Wade Wade       5 star  

                                                  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!

                                                  Vito Vito       4 star  

                                                  Have passed 70-779 exam.

                                                  Jodie Jodie       4 star  

                                                  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!

                                                  Tabitha Tabitha       5 star  

                                                  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.

                                                  Murray Murray       5 star  

                                                  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.

                                                  Celeste Celeste       5 star  

                                                  LEAVE A REPLY

                                                  Your email address will not be published. Required fields are marked *

                                                  QUALITY AND VALUE

                                                  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.

                                                  TESTED AND APPROVED

                                                  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.

                                                  EASY TO PASS

                                                  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.

                                                  TRY BEFORE BUY

                                                  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.

                                                  Our Clients

                                                  amazon
                                                  centurylink
                                                  vodafone
                                                  xfinity
                                                  earthlink
                                                  marriot
                                                  vodafone
                                                  comcast
                                                  bofa
                                                  timewarner
                                                  charter
                                                  verizon