Microsoft 77-420 : Excel 2013

77-420 exam collection

Exam Code: 77-420

Exam Name: Excel 2013

Updated: Aug 08, 2026

Q & A: 30 Questions and Answers

Already choose to buy "PDF"
Price: $49.99 

If you failed, what should you do?

If you got a bad result in exam, first you can choose to wait the updating of 77-420 exam dumps or free change to other dumps if you have other test. If you want to full refund, please within 7 days after exam transcripts come out, and then scanning the transcripts, add it to the emails as attachments and sent to us. After confirmation, we will refund immediately.

Requirements for Test 77-420

There are no certification requisites to become eligible for this exam. So, once you ace this test, you’ll be able to earn such certifications as the Microsoft Office Specialist: Excel 2013 and Microsoft Specialist 2013 Master.

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

What is online test engine?

Online test engine provides users with 77-420 exam simulations experience. It enables interactive learning that makes exam preparation process easier and can support Windows/Mac/Android/iOS operating systems, which means you can practice your 77-420 real questions and test yourself by 77-420 practice exam. There is no limit of location or time to do 77-420 exam simulations. Online test engine perfectly suit to IT workers

There are some steps to apply for Microsoft 77-420 Exam

Step 1: Visit to Microsoft Exam Registration Step 2: Signup/Login to Microsoft account Step 3: Search for Microsoft 77-420 Certifications Exam Step 4: Select Date and Center of examination and confirm with payment value of $165

About our products

Our website offers latest study material that contains valid 77-420 real questions and detailed 77-420 exam answers, which written and tested by IT experts and certified trainers. The 77-420 exam dumps have exactly 90% similarity to questions in the 77-420 real test. One week preparation prior to attend exam is highly recommended. Free demo of our 77-420 exam collection can be downloaded from exam page.

Free Download 77-420 exam collection

Our website is an influential leader in providing valid online study materials for IT certification exams, especially Microsoft certification. Our Excel 2013 exam collection enjoys a high reputation by highly relevant content, updated information and, most importantly, 77-420 real questions accompanied with accurate 77-420 exam answers. The study materials of our website contain everything you need to get high score on 77-420 real test. Our aim is always to provide best quality practice exam products with best customer service. This is why more and more customers worldwide choose our website for their Excel 2013 exam dumps preparation.

How long will you received your dumps after payment

After you make payment, if the payment was successful and you will receive our email immediately, you just need to click the link in the email and download your 77-420 real questions immediately.

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.

Microsoft 77-420 Exam Syllabus Topics:

SectionWeightObjectives
Create and Manage Worksheets and Workbooks30%- Customize workbook options and views
  • 1. Freeze panes, split windows, and change views
    • 2. Set workbook properties and protection
      - Navigate through worksheets and workbooks
      • 1. Use Go To, Name Box, and Find/Replace
        • 2. Insert and follow hyperlinks
          - Create worksheets and workbooks
          • 1. Add, copy, move, and delete worksheets
            • 2. Import and open non-native file formats
              • 3. Create blank and template-based workbooks
                - 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
                      Create Tables15%- 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
                              - Create and format tables
                              • 1. Apply table styles and banded rows/columns
                                • 2. Convert ranges to tables
                                  Create Cells and Ranges25%- Insert data in cells and ranges
                                  • 1. Enter, edit, and clear cell content
                                    • 2. Use AutoFill and Flash Fill
                                      - Summarize and organize data
                                      • 1. Create named ranges
                                        • 2. Group, outline, and insert subtotals
                                          - Format cells and ranges
                                          • 1. Apply cell styles, number formats, and conditional formatting
                                            • 2. Apply borders, fill colors, and alignment
                                              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. Insert images, shapes, SmartArt, and text boxes
                                                    • 2. Position, resize, and apply styles to objects
                                                      Apply Formulas and Functions20%- Troubleshoot formulas
                                                      • 1. Correct common formula errors
                                                        - Apply functions
                                                        • 1. Text, date, and lookup functions
                                                          • 2. SUM, AVERAGE, MIN, MAX, COUNT
                                                            • 3. Logical functions: IF, AND, OR
                                                              - Utilize cell references
                                                              • 1. Use relative, absolute, and mixed references

                                                                We also provide you good service:

                                                                • Updating: You have right to free update your 77-420 vce dumps one-year after you bought. Once there is the latest version released, our system will send 77-420 exam dumps to your e-mail automatically and immediately. In this way, you needn't worry about the updating. You just need to check your e-mail.
                                                                • Payment: Our payment is by Credit Card because it's safe and fast. But it can be bound with the credit card, so the credit card is also available.
                                                                • Invoice: When you need the invoice, please email us the name of your company. We will make custom invoice according to your demand.
                                                                • Customer Assisting: There are 24/7 customer assisting support you in case you may encounter some problems in downloading or purchasing. Please fell free to contact us.
                                                                No help, Full refund!

                                                                No help, Full refund!

                                                                RealVCE confidently stands behind all its offerings by giving Unconditional "No help, Full refund" Guarantee. Since the time our operations started we have never seen people report failure in the 77-420 exam after using our products. With this feedback we can assure you of the benefits that you will get from our products and the high probability of clearing the 77-420 exam.

                                                                We still understand the effort, time, and money you will invest in preparing for your certification exam, which makes failure in the 77-420 exam really painful and disappointing. Although we cannot reduce your pain and disappointment but we can certainly share with you the financial loss.

                                                                This means that if due to any reason you are not able to pass the 77-420 actual exam even after using our product, we will reimburse the full amount you spent on our products. you just need to mail us your score report along with your account information to address listed below within 7 days after your unqualified certificate came out.

                                                                What Clients Say About Us

                                                                With the 77-420 exam questions, you will really understand what to expect on the exam. I have passed the exam smoothly. Just study hard and you will pass as well!

                                                                Gustave Gustave       4 star  

                                                                Currently using this dump to study for the 77-420 examination. This is a good exam preparation guide. I passed my exam using the guide.

                                                                Cara Cara       5 star  

                                                                It was the tremendous support of RealVCE questions answers that finally made my career! I passed exam 77-420 reading only the 77-420 QandAs of RealVCE! They are so perfectly crafted that Got my 77-420 Certification today!

                                                                Bill Bill       4 star  

                                                                The concrete knowledge was really interesting and kept me fresh through out the 77-420 preparations. I have already recommended your products to my friends and I will recommend where ever I will get a chance. Thanks!

                                                                Simona Simona       4.5 star  

                                                                Almost all the questions I had on exam were in 77-420 exam dump. I just passed my exam!yesterday.

                                                                Hyman Hyman       5 star  

                                                                Thank you so much for such 77-420 quality questions.

                                                                Doreen Doreen       4.5 star  

                                                                Searching for 77-420 real exam questions and answer to pass your Microsoft certification exam then you are at right place. I just got through my 77-420 certification

                                                                Odelia Odelia       5 star  

                                                                The service is wonderful, and i passed the 77-420 exam this time. Last time, i bought one exam file from the other website, no one answerd me after payment and i failed. I will buy other exam materials from this website later on.

                                                                Delia Delia       4.5 star  

                                                                Make use of these 77-420 exam prep materials and you won’t regret. You will get your certification as me. Good luck!

                                                                Clement Clement       4 star  

                                                                Your 77-420 training material is very useful to me.

                                                                Melissa Melissa       4 star  

                                                                Thanks for your help. I passed my exam using your dumps. Valid. RealVCE study materials are very good for the people who do not have much time for their exam preparation. Very helpful exam guidance. Thank you again for your almost real exam material!

                                                                Horace Horace       4.5 star  

                                                                I recommend all to study from the dumps at RealVCE. I achieved 91% marks in the certified 77-420 exam. Great work RealVCE.

                                                                Jay Jay       5 star  

                                                                I practiced the 77-420 question sets for days and then i passed the exam last week with highest marks-full marks.

                                                                Gladys Gladys       4 star  

                                                                LEAVE A REPLY

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

                                                                Why Choose RealVCE

                                                                Quality and Value

                                                                RealVCE Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all vce.

                                                                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 RealVCE 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

                                                                RealVCE 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
                                                                earthlink
                                                                marriot
                                                                vodafone
                                                                comcast
                                                                bofa
                                                                charter
                                                                vodafone
                                                                xfinity
                                                                timewarner
                                                                verizon