McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
My Cart (0)  

Microsoft Microsoft Office Specialist (MOS) 77-420

77-420

Exam Code: 77-420

Exam Name: Excel 2013

Updated: Jul 30, 2026

Q & A: 30 Questions and Answers

77-420 Free Demo download:

PDF Version Test Engine Online Test Engine

77-420 PDF Price: $109.00  $49.99


About Microsoft 77-420 Exam

There has been a dramatic increase in employee in the field, with many studies projecting that the unemployment rate in this industry is increasing. I don't know whether you are the one in the tide of job losses, if you are a member of the unemployed, you have to think about improving yourself. You should prepare your Microsoft 77-420 actual test to make sure that you will not be replaced if you are a practitioner. Maybe you are too busy to prepare the 77-420 actual test. Our 77-420 pass4sure vce will help you solve the problem. Our 77-420 training materials are created by professional writer which are more secure than other enterprises.

Free Download 77-420 Exam Torrent

Exam 77-420: Microsoft Excel 2013

A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demonstrate the correct application of the principal features of Excel 2013. These candidates should be able to create and edit a workbook with multiple sheets for a variety of purposes and situations. Examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs. Candidate roles might include students, clerical workers, bookkeepers, instructors, and others.

Part of the requirements for: Microsoft Office Specialist: Excel 2013 Microsoft Office Specialist 2013 Master

Download exam skills outline

Different versions to be chosen

In order follow the trend of the times, Our 77-420 study guide offers the PDF version to you. 77-420 PDF files can bring you many benefits. It occupies little memory and is easy to store. The important part is that it can be printed and you can read it at any time. PDF version won't have garbled content and the wrong words. Except for this version, Our Microsoft Office Specialist (MOS) 77-420 Latest Torrent also provides online practice. It will be very convenient if you could access the Internet. We have app which has pretty features, you can download after you have bought. What's more, our 77-420 training torrent is quite similar to the real exam circumstance; you can experience the exam in advance.

Microsoft 77-420 Exam Introduction

The Microsoft Office Specialist certification is for specialists who can design and manage worksheets and workbooks with Microsoft Office Excel 2013 and who have experience with previous versions of Microsoft Office Excel. They must also be able to perform tasks such as creating tables, applying formulas and functions, creating graphs and objects. Microsoft Exam 77-420 is an update to Microsoft Office Excel 2010.

High passing rate

Our 77-420 training materials are popular because of high quality. People who have made use of our Microsoft Office Specialist (MOS) training materials will have more possibility to get the certificate. The content is written by professions who have studied the exam for many years. When it comes to service and passing rate, our 77-420 prep practice is sure to win out over those of our competitors. Compared with other companies, our 77-420 : Excel 2013 training materials carries a guarantee for the exam content. We will be responsible for our 77-420 valid questions which means the content will continue to update until you have passed the exam. We have a variety of versions for you to choose which can meet all kinds of requirements; you can choose a suitable one.

Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

Knight Service

Our 77-420 valid cram we produced is featured by its high efficiency and good service. We are online for 24 hours. If you have any questions, just contact us without hesitation. We provide pre-trying experience, which means you can have a try before you buy it. Our 77-420 prep practice is well received. Most of the people who have bought our products have passed the exam and get the certificate.

Our 77-420 study materials have worked hard to provide better user experience. We promise that our content is up to date and once there is a new content, we will update it immediately. We will be responsible for our 77-420 training materials until you have passed the exam. What you need to do is to prepare for the exam and not concern with anything else.

Next Certification to Pursue After Acing the Microsoft 77-420 Exam

Once you're done with 77-420, it's time to consider taking other tests related to the expert-level Microsoft Office Specialist 2013 Master. Another great way to polish these skills is through the Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification (MO-200 test should be passed) or the Microsoft Office Specialist: Excel 2013 Expert certificate (exams 77-427 and 77-428 are required). Otherwise, one can expand the knowledge base and sit for related tests from the Microsoft Office Specialist Program. Some of the options are Microsoft Word 2013 (exam 77-418), Microsoft PowerPoint 2013 (exam 77-422), and Microsoft Outlook 2013 (exam 77-423), and such.

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

Microsoft 77-420 Exam Syllabus Topics:

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

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

                                                                Excellent dumps for the 77-420 exam. I studied from other sites but wasn't able to score well. Thank you Itcertmaster.

                                                                Zebulon

                                                                Zebulon     4 star  

                                                                I read all the questions and answers and passed the test in the first attempt.

                                                                Enid

                                                                Enid     4.5 star  

                                                                I have passed 77-420 before.

                                                                Isidore

                                                                Isidore     4.5 star  

                                                                I just passed my 77-420 exam. I could not have done this without Itcertmaster's exam preparation material. I must say, Itcertmaster is really good.

                                                                Aaron

                                                                Aaron     4.5 star  

                                                                Itcertmaster has the best exam practise software. I passed my 77-420 certification exam very easily by practising on the practise exam software by Itcertmaster. I scored 95% in the exam.

                                                                Lewis

                                                                Lewis     4.5 star  

                                                                If you buy this 77-420 dump, you do not worry about the exam completely. Part of the dumps are same with real exam.

                                                                Ivy

                                                                Ivy     4.5 star  

                                                                77-420 study materials in Itcertmaster are valid, and I also learned lots of professional knowledge from them.

                                                                Kristin

                                                                Kristin     5 star  

                                                                Cleared my 77-420 certification exam by preparing with Itcertmaster exam dumps. Very similar to the actual exam. Achieved 91% marks.

                                                                Joyce

                                                                Joyce     4 star  

                                                                It gave me courage to prepare for exam with full effort and within short time period I got the 77-420 result that was outstanding.

                                                                Eden

                                                                Eden     5 star  

                                                                I find 77-420 training course is easy to be understood and i passed the exam without difficulty. Nice to share with you!

                                                                Elsie

                                                                Elsie     4.5 star  

                                                                Passed my exam today with 90%, thx a lot for your help, I only used your simulator for this.

                                                                Hyman

                                                                Hyman     4 star  

                                                                Thank you!
                                                                Hey guys, I passed this exam and scored 90%.

                                                                Kristin

                                                                Kristin     5 star  

                                                                Valid 77-420 exam materials, pass 77-420 exam today.There are one or two wrong questions, you have to search them. Thanks!

                                                                Jonathan

                                                                Jonathan     5 star  

                                                                The practice 77-420 exam contains all valid questions and answers, I passed my 77-420 test smoothly, thanks a lot.

                                                                Kim

                                                                Kim     5 star  

                                                                Thank you Itcertmaster for making my company proud of me. Cleared 77-420 exam with outstanding numbers

                                                                Gordon

                                                                Gordon     5 star  

                                                                The answers of the 77-420 dumps are accurate and correct! I passed the exam with these 77-420 Software questions. Thank you! So happy now!

                                                                Carl

                                                                Carl     4.5 star  

                                                                You really did a good job for dump 77-420

                                                                Noel

                                                                Noel     4 star  

                                                                All Microsoft questions are from Itcertmaster 77-420 dumps.

                                                                Elaine

                                                                Elaine     5 star  

                                                                LEAVE A REPLY

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

                                                                Contact US:  
                                                                 [email protected]
                                                                 [email protected]  Support

                                                                Free Demo Download

                                                                Popular Vendors
                                                                Adobe
                                                                Alcatel-Lucent
                                                                Avaya
                                                                BEA
                                                                CheckPoint
                                                                CIW
                                                                CompTIA
                                                                CWNP
                                                                EC-COUNCIL
                                                                EMC
                                                                EXIN
                                                                Hitachi
                                                                HP
                                                                ISC
                                                                ISEB
                                                                Juniper
                                                                Lpi
                                                                Network Appliance
                                                                Nortel
                                                                Novell
                                                                SASInstitute
                                                                Sybase
                                                                Symantec
                                                                The Open Group
                                                                Tibco
                                                                VMware
                                                                Zend-Technologies
                                                                IBM
                                                                Lotus
                                                                OMG
                                                                Oracle
                                                                RES Software
                                                                all vendors