live chatMcAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams

Microsoft Microsoft Office Specialist (MOS) 77-420

77-420

Exam Code: 77-420

Exam Name: Excel 2013

Updated: Aug 29, 2026

Q & A: 30 Questions and Answers

77-420 Free Demo download:

PDF Version Demo Test Engine Online Test Engine

PDF Version Price: $109.00  $49.99


IT-Tests 77-420 Exam Features

Guaranteed! Whichever level of the Certification Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013) you are at, rest assured you will get through your Customer Relationship Management exam Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013) right away.

Our products of Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013) come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.

100% Pass Your 77-420 Exam.

If you prepare for the exam using our IT-Tests.com testing engine, we guarantee your success in the first attempt. If you do not pass the Certification 77-420 exam (Excel 2013) on your first attempt we will give you free update..

Quality and Value for the Exam

IT-Tests.com Practice Exams for Microsoft Office Specialist (MOS) 77-420 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

There are Candidates must know the topics before they start of preparation.

Our Microsoft 77-420 -dumps will include the following topics:

  • Create tables
  • Apply formulas and functions
  • Create charts and objects
  • Create cells and ranges
  • Create and manage worksheets and workbooks

77-420 Interactive Exam engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination, our Practice Tests 77-420 will provide you with exam questions with verified answers that reflect the 77-420 materials. These questions and answers provide you with the experience of taking the best materials. High quality and Value for the 77-420 Exam: easy Pass Your Certification exam Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013) and get your Certification Microsoft Microsoft Office Specialist (MOS) 77-420 Certification.

Microsoft Microsoft Office Specialist (MOS) 77-420 Excel 2013 Exams

Our Exam 77-420 Preparation Material provides you everything you will need to take your 77-420 Exam. The 77-420 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you pass test in your first try, and also save your valuable time.

Its Corresponding Certification Paths

The Microsoft 77-420 exam is part of two accreditation paths. First of all, it earns one the Microsoft Office Specialist: Excel 2013 certificate by validating basic competence. Still, it is also one of the tests that candidates should take to earn the Microsoft Office Specialist 2013 Master certification. The other steps here include acing 77-425 test (Microsoft Word 2013 Expert Part One) and 77-426 (Microsoft Word 2013 Expert Part Two). Successful applicants signify that they can expertly deal with different Office programs and need to sit for one more exam chosen from five alternatives to get accredited.

How to Prepare for Exam 77-420 Using Study Guides

Overall, there are various methods available for test-takers who wish to prepare for 77-420 with varying degrees of effectiveness. So, if you want to maximize your chances of success, consider acquiring one or several study guides available in stores such as Amazon.com, signing up for official Microsoft training, and using practice tests from reputable third-party sources. To assist you with this, we have created the list of the most helpful and comprehensive books found on Amazon that you can refer yourself to while preparing for 77-420 test:

  • Exam 77-420 Microsoft Excel 2013 by Microsoft Official Academic Course

    This is the only Microsoft Official Academic Course (MOAC) textbook dedicated to exam 77-420. Particularly, it is a detailed guide that covers all the foundational skills of Microsoft Excel and is made exclusively for the Excel 2013 test objectives as well as reinforces those skills that are useful for newer employees and those who have been for years in the field. So, here is a brief overview of what this book offers:

    • A guide to creating and editing professional-looking spreadsheets of different types, purposes, and situations;
    • The coverage of fundamental Excel features such as charting, creating analytical and financial reports, data entry, and creating budgets;
    • Activities and assignments based on real-world examples;
    • Hands-on practice;
    • OfficeGrader, the MOAC proprietary academic tool that evaluates and corrects the task-based assignments covered in this book. OfficeGrader allows for efficient and consistent grading, which is useful for both students and instructors.
  • Exam Prep for Exam 77-420 Microsoft Excel 2013 by Just the Facts101

    Being a study guide that delivers a concise yet in-depth focus, this book is a part-study guide and part-exam dump as it covers all that you need and want to know to pass exam 77-420. With this book, you will get access to the following:

    • Over 2000 prep questions and answers, including items and tasks that are highly probably to appear in your official test;
    • Extensive coverage of key facts and questions in 77-420;
    • Detailed explanations to each practice question.
  • MOS 2013 Study Guide for Microsoft Excel by Joan Lambert

    This is a trusted and reputable study guide made for 77-420 test, which was written by Joan Lambert, a distinguished author of more than three dozen books about Windows, Office, and Microsoft Office Specialist features. She holds a number of certifications from Microsoft and definitely knows what she is writing about. In all, this book offers the following to supercharge your exam preparation:

    • Extensive coverage of all test domains;
    • Special procedures and illustrations to help you check your skill level;
    • Practical tasks to consolidate your knowledge;
    • Access to downloadable practice materials.
  • How I Passed 77-420: Exam Tips by Empirical Matt Publications

    In case you’re looking for the best & helpful tips that will help you clear the final validation on the first try, then this is the suitable study guide to acquire from Amazon. As a rule, the creators of such books turn to numerous successful candidates to collect information from them about which techniques they used when preparing for the official evaluation. Also, after you’ve purchased this book in Kindle format, you will be eligible for a free coupon code from Vullam. With the help of this code, you’ll manage to access several gratis practice tests available on that platform.

Reference: https://www.microsoft.com/en-us/learning/exam-77-420.aspx

'Success of our customers and our products goes side by side'

Time is the most important element for our customers so we keep that in mind while preparing our Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013) practice tests. Senior IT Professionals put in a lot of effort in ensuring this. Ongoing improvement in our real questions and answers of Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013) and services is a part of our mission. On the contrary, if any of our customers remain unsuccessful in an exam and is very unhappy, they can notify us through an Email, and we will immediately exchange them. The positive thing is we review that product immediately.

You should not worry about the money you pay for the exam material for Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013), as in case you do not succeed in the exam Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013), it will be exchange with another Product. On the other hand, you can also be provided request for access extension and product update on your discretion. Give it a thought! You have nothing to lose in it.

Method to Claim Guarantee

Totally hassle free! All you need to do is contact the Customer Support and request for the exam you like. You will be required to scan a copy of your failed exam Microsoft Microsoft Office Specialist (MOS) 77-420 and mail it to us so you are provided access to another certification test immediately.

Your success is insured by the IT-Tests.com Guarantee!

Exam Description: It is well known that 77-420 exam test is the hot exam of Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013). IT-Tests.com offer you all the Q&A of the 77-420 Tests . It is the examination of the perfect combination and it will help you pass 77-420 exam at the first time!

What is our secret of maintaining 100% success rate on our Questions and Answers Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013)?

We believe in helping our customers achieve their goals. For this reason, we take great care while preparing our Questions and Answers Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013). Our practice tests Microsoft Microsoft Office Specialist (MOS) 77-420 (Excel 2013) are prepared with the help of highly professional people from the industry, so we benefit from their vast experience and knowledge.

Microsoft 77-420 Exam Syllabus Topics:

SectionWeightObjectives
Create Cells and Ranges25%- Summarize and organize data
  • 1. Create named ranges
    • 2. Group, outline, and insert subtotals
      - Format cells and ranges
      • 1. Apply borders, fill colors, and alignment
        • 2. Apply cell styles, number formats, and conditional formatting
          - Insert data in cells and ranges
          • 1. Enter, edit, and clear cell content
            • 2. Use AutoFill and Flash Fill
              Apply Formulas and Functions20%- Apply functions
              • 1. Logical functions: IF, AND, OR
                • 2. Text, date, and lookup functions
                  • 3. SUM, AVERAGE, MIN, MAX, COUNT
                    - Troubleshoot formulas
                    • 1. Correct common formula errors
                      - Utilize cell references
                      • 1. Use relative, absolute, and mixed references
                        Create and Manage Worksheets and Workbooks30%- Format worksheets and workbooks
                        • 1. Modify page setup, themes, and tab colors
                          • 2. Add headers, footers, watermarks, and print areas
                            • 3. Adjust row height, column width, and alignment
                              - Create worksheets and workbooks
                              • 1. Create blank and template-based workbooks
                                • 2. Add, copy, move, and delete worksheets
                                  • 3. Import and open non-native file formats
                                    - Customize workbook options and views
                                    • 1. Set workbook properties and protection
                                      • 2. Freeze panes, split windows, and change views
                                        - Navigate through worksheets and workbooks
                                        • 1. Use Go To, Name Box, and Find/Replace
                                          • 2. Insert and follow hyperlinks
                                            Create Tables15%- Filter and sort table data
                                            • 1. Apply filters and custom sorts
                                              • 2. Remove duplicates and manage table ranges
                                                - Modify tables
                                                • 1. Add total rows and calculated columns
                                                  • 2. Add/remove table rows and columns
                                                    - Create and format tables
                                                    • 1. Convert ranges to tables
                                                      • 2. Apply table styles and banded rows/columns
                                                        Create Charts and Objects10%- Insert and format objects
                                                        • 1. Insert images, shapes, SmartArt, and text boxes
                                                          • 2. Position, resize, and apply styles to objects
                                                            - Create and format charts
                                                            • 1. Create column, line, pie, and bar charts
                                                              • 2. Modify chart titles, legends, axes, and styles

                                                                1113 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

                                                                I am from Philippines, 77-420 exam guide is enough for me to pass exam!

                                                                Mick

                                                                Mick     4.5 star  

                                                                The best 77-420 I've ever bought. This is the second time for me to sit for the 77-420 exam. If I met It-Tests earlier, I would pass at the first time. Anyway, i passed it!

                                                                Yetta

                                                                Yetta     5 star  

                                                                It is valid.It is a very good summary of the key knowledge. I learned a lot. I passed on Mar 3th. Good news.

                                                                Doreen

                                                                Doreen     4.5 star  

                                                                77-420 braindumps provides great study material. It helped me to start preparation for 77-420 exam. Great dumps! I passed the exam last week.

                                                                Tyler

                                                                Tyler     4 star  

                                                                I confirm that all actual questions are from your Excel 2013 dumps.

                                                                Gloria

                                                                Gloria     4.5 star  

                                                                Your 77-420 exam braindumps are valid! My collegue have passed the exam just now with your help. I bought this 77-420 exam dumps for him. Thank you! I will buy it after finishing this comment.

                                                                Daniel

                                                                Daniel     5 star  

                                                                It was a huge task to pass 77-420 exam, but It-Tests made it easy for me. I did recommend It-Tests to my other pals and recommending you.

                                                                Eden

                                                                Eden     5 star  

                                                                So great It-Tests 77-420 real exam questions.

                                                                Maximilian

                                                                Maximilian     4.5 star  

                                                                Finally, i passed my 77-420 exam. Thanks to 77-420 practice test package that i got from It-Tests! Nice purchase!

                                                                Theodore

                                                                Theodore     4 star  

                                                                Passed 77-420 exam last Friday.

                                                                Mignon

                                                                Mignon     5 star  

                                                                I passed the 77-420 today. The dump was in very good conditions and in a very good price. I definitely think that was a great deal. Thanks so much.

                                                                Moira

                                                                Moira     4.5 star  

                                                                Very detailed exam dumps for the 77-420 77-420 certification exam. Passed with 92% marks. I studied with It-Tests. Satisfied with their content. I suggest everyone refer to these before taking the original exam.

                                                                Arthur

                                                                Arthur     4 star  

                                                                Valid and latest dumps for 77-420 certification exam. I passed my exam today with great marks. I recommend everyone should study from It-Tests.

                                                                Toby

                                                                Toby     4.5 star  

                                                                Thanks to It-Tests's good 77-420 exam dumps -- all the questions are available!!!

                                                                Cornelia

                                                                Cornelia     4.5 star  

                                                                77-420 practice dump is so good that i passed my exam with flying colours. Highly recommended.

                                                                Joseph

                                                                Joseph     5 star  

                                                                I wrote the 77-420 exam easily in less than 30 minutes and passed it. If you study more, and you will do better! Great!

                                                                Noel

                                                                Noel     5 star  

                                                                Yes, just as what you promised, all of them are real questions.
                                                                Passd 77-420

                                                                Christopher

                                                                Christopher     4 star  

                                                                LEAVE A REPLY

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

                                                                Why Choose IT-Tests Testing Engine
                                                                 Quality and ValueIT-Tests Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
                                                                 Tested and ApprovedWe 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 PassIf you prepare for the exams using our IT-Tests testing engine, It is easy to succeed for certifications in the first attempt. You don't have to deal with dumps or any free torrent / rapidshare stuff.
                                                                 Try Before BuyIT-Tests 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.