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

Microsoft 77-420

77-420

Exam Code: 77-420

Exam Name: Excel 2013

Updated: Sep 10, 2026

Q & A: 30 Questions and Answers

77-420 Free Demo download

PDF Version Demo PC Test Engine Online Test Engine

Already choose to buy "PDF"

Price: $49.99 

About Microsoft 77-420 Exam

Target Audience

The candidates for the Microsoft 77-420 exam are those core-level individuals who have the ability to use multiple sheets in creating and editing a workbook for various situations and purposes. This Microsoft Excel 2013 test is an ideal fit for instructors, students, bookkeepers, and clerical workers. They aim for this exam in order to obtain the Microsoft Office Specialist: Excel 2013 or Microsoft Office Specialist 2013 Master certifications. They can get the second certificate if they pass this test along with 77-425 and 77-426 and choose one exam from the list that includes 77-421, 77-422, 77-423, 77-424, and 77-419.

Conclusion

Becoming a certified passer of the Microsoft 77-420 demonstrates your knowledge and proficiency in the fundamental features found in all Excel applications. Having the related qualification tells your current and future employers that you can be relied upon in accomplishing the multiple tasks that require an Excel Spreadsheet, which allows you to charge up your career in clerical work, accounting and finance, and so on.

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

In recent years, many people choose to take Microsoft 77-420 certification exam which can make you get the Microsoft certificate that is the passport to get a better job and get promotions.

How to prepare for Microsoft 77-420 exam and get the certificate? Please refer to Microsoft 77-420 exam questions and answers on ITCertTest.

ITCertTest is a good website that provides all candidates with the latest IT certification exam materials. ITCertTest will provide you with the exam questions and verified answers that reflect the actual exam. The Microsoft 77-420 exam dumps are developed by experienced IT Professionals. 99.9% of hit rate. Guarantee you success in your 77-420 exam with our exam materials.

Furthermore, we are constantly updating our 77-420 exam materials. We will provide our customers with the latest and the most accurate exam questions and answers that cover a comprehensive knowledge point, which will help you easy prepare for 77-420 exam and successfully pass your exam. You just need to spend you 20-30 hours on studying the exam dumps.

ITCertTest provides you not only with the best materials and also with excellent service. If you buy ITCertTest questions and answers, free update for one year is guaranteed. You fail, after you use our Microsoft 77-420 dumps, 100% guarantee to FULL REFUND. You just need to send the scanning copy of your examination report card to us. After confirming, we will refund you.

What's more, before you buy, you can try to use our free demo. We provide you some of Microsoft 77-420 exam questions and answers and you can download it for your reference.

ITCertTest is no doubt your best choice. Using the Microsoft 77-420 training dumps can let you improve the efficiency of your studying so that it can help you save much more time.

Quick and easy: just two steps to finish your order. We will send your products to your mailbox by email, and then you can check your email and download the attachment.

Microsoft 77-420 Exam Syllabus Topics:

SectionWeightObjectives
Topic 1: Create Charts and Objects10%- Create and format charts
  • 1. Modify chart titles, legends, axes, and styles
    • 2. Create column, line, pie, and bar charts
      - Insert and format objects
      • 1. Position, resize, and apply styles to objects
        • 2. Insert images, shapes, SmartArt, and text boxes
          Topic 2: Create Tables15%- Create and format tables
          • 1. Apply table styles and banded rows/columns
            • 2. Convert ranges to tables
              - Modify tables
              • 1. Add/remove table rows and columns
                • 2. Add total rows and calculated columns
                  - Filter and sort table data
                  • 1. Apply filters and custom sorts
                    • 2. Remove duplicates and manage table ranges
                      Topic 3: Create and Manage Worksheets and Workbooks30%- 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
                            - Navigate through worksheets and workbooks
                            • 1. Use Go To, Name Box, and Find/Replace
                              • 2. Insert and follow hyperlinks
                                - Customize workbook options and views
                                • 1. Set workbook properties and protection
                                  • 2. Freeze panes, split windows, and change views
                                    - Format worksheets and workbooks
                                    • 1. Modify page setup, themes, and tab colors
                                      • 2. Adjust row height, column width, and alignment
                                        • 3. Add headers, footers, watermarks, and print areas
                                          Topic 4: Create Cells and Ranges25%- Summarize and organize data
                                          • 1. Group, outline, and insert subtotals
                                            • 2. Create named ranges
                                              - 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. Enter, edit, and clear cell content
                                                    • 2. Use AutoFill and Flash Fill
                                                      Topic 5: Apply Formulas and Functions20%- Troubleshoot formulas
                                                      • 1. Correct common formula errors
                                                        - 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

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

                                                                I passed my 77-420 exam in the first attempt. Thanks to Itcerttest for providing the latest dumps that are surely a part of the original exam.

                                                                Elizabeth

                                                                Elizabeth     5 star  

                                                                I must to say I can not pass without this 77-420 study dump. I love 77-420 exam dumps. They are good to study. Wonderful!

                                                                Darlene

                                                                Darlene     5 star  

                                                                Using these 77-420 exam questions and answers before your exam is wonderful. I used them and passed my 77-420 exam.

                                                                Pamela

                                                                Pamela     5 star  

                                                                All Microsoft questions are there.

                                                                Ron

                                                                Ron     4.5 star  

                                                                Thanks for giving me the wonderful study guide, which helped me pass my 77-420 test.

                                                                Gwendolyn

                                                                Gwendolyn     4.5 star  

                                                                Sample exams help a lot to prepare for the 77-420 exam. I could only spare 2 hours a day to study and manage my professional career. Itcerttest helped me pass the exam with flying colours.

                                                                Jerome

                                                                Jerome     5 star  

                                                                The 77-420 study guide with high-quality is very nice, i feel that i learn a lot since i own it.

                                                                Ron

                                                                Ron     4 star  

                                                                77-420 study materials give me a brillent exam success after a few days of preparation. Can't believe they are so accurate!

                                                                Elvira

                                                                Elvira     4.5 star  

                                                                The 77-420 practice dumps helped me passed my exam. I was so happy because I had started my study a little late. The dumps really saved me.

                                                                Marlon

                                                                Marlon     5 star  

                                                                I am not surprised at I can pass the 77-420 exam. Because this material builds my confidence. I passed with a high score. Thanks!

                                                                Hunter

                                                                Hunter     4 star  

                                                                When I got the result in mail, I exclaimed in surprise. Passed 77-420 exam that too with flying colors also on my first attempt.

                                                                Tom

                                                                Tom     4 star  

                                                                77-420 is really difficult. Luckily I choose to purchase exam prep and pass exam or I may fail. Very Useful.

                                                                Amanda

                                                                Amanda     4 star  

                                                                I got the certificate, the 77-420 exam torrent is quite useful and they help me to handle the knowledge.

                                                                Broderick

                                                                Broderick     4 star  

                                                                I used Itcerttest 77-420 real exam questions to prepare my test and passed it.

                                                                Valentine

                                                                Valentine     5 star  

                                                                I just passed my 77-420 certification exam with 94% marks. I must thank the developers and thinking minds of Itcerttest who shared such informative and beneficial answers for the exams. I intend to refer to Itcerttest for future exams as well.

                                                                Lawrence

                                                                Lawrence     4.5 star  

                                                                I took the 77-420 test on Jul 31, 2026

                                                                Philipppa

                                                                Philipppa     5 star  

                                                                LEAVE A REPLY

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

                                                                Contact US:  
                                                                 [email protected]  Support

                                                                Free Demo Download

                                                                Popular Vendors
                                                                Alcatel-Lucent
                                                                Avaya
                                                                CIW
                                                                CWNP
                                                                Lpi
                                                                Nortel
                                                                Novell
                                                                SASInstitute
                                                                Symantec
                                                                The Open Group
                                                                Tibco
                                                                Zend-Technologies
                                                                Lotus
                                                                OMG
                                                                RES Software
                                                                all vendors
                                                                Why Choose ITCertTest Testing Engine
                                                                 Quality and ValueITCertTest 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 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 ITCertTest 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 BuyITCertTest 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.