Microsoft Excel 2013 - 77-420

Exam Code: 77-420
Exam Name: Excel 2013
Updated: Aug 16, 2026
Q & A: 30 Questions and Answers

Following are the requirements of Microsoft 77-420 Exam

A top-level candidate for the Microsoft Excel 2013 exam must have a basic understanding of the Excel environment and the ability to perform tasks independently. They must know and demonstrate the correct application of the main features of Excel 2013. These candidates must be able to create and edit a multi-sheet workbook for a variety of purposes and situations. Examples include professional-looking quotes, team performance charts, sales invoices, and exercise magazines. The roles of the candidates may include students, office workers, accountants, instructors, and others.

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

Skills measured

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

As everyone knows, although passing Microsoft Excel 2013 is difficult for IT workers, but once you pass exam and get the Microsoft Office Specialist (MOS), you will have a nice career development. ActualPDF Excel 2013 actual test pdf can certainly help you sail through examination. Currently our product on sale is the Excel 2013 actual test latest version which is valid, accurate and high-quality. You can rest assured that Excel 2013 actual test pdf helps 98.57% candidates achieve their goal. Every year there are more than 100000+ candidates who choose us as their helper for Microsoft Excel 2013.

Why are our 77-420 actual test pdf so popular among candidates? Why do so many candidates choose us? Because we are not only offering the best 77-420 actual test latest version but also 100% service satisfaction.

The details are below:

Firstly, we run business many years, we have many old customers; also they will introduce their friends, colleagues and students to purchase our Excel 2013 actual test pdf. We think highly of every customer and try our best to serve for every customer, so that our Excel 2013 actual test latest version is sold by word of mouth. Since so many years our education experts is becoming more and more professional, the quality of our Excel 2013 actual test pdf is becoming higher and higher. Meanwhile, the passing rate is higher and higher.

Secondly, we have good reputation in this field that many people know our passing rate of 77-420 actual test latest version is higher than others; our accuracy of actual test dumps is better than others. Our Excel 2013 actual test pdf has many good valuable comments on the internet. Many authorities recommend our actual test dumps to their acquaintances, students and friends for reference.

Thirdly, normally our 77-420 actual test pdf contains about 80% questions & answers of actual exam. Most candidates can pass exams with our 77-420 actual test dumps. We have three versions for every Excel 2013 actual test pdf. 63% candidates choose APP on-line version. We guarantee your money safety that if you fail exam unfortunately, we can refund you all cost about the Excel 2013 actual test pdf soon. Or you would like to wait for the update version or change to other exam actual test dumps, we will approve of your idea. We have one year service warranty that we will serve for you until you pass. Believe me, No Pass, Full Refund, No excuse!

Fourthly, our service is satisfying. Our guideline for our service work is that we pursue 100% satisfaction. We use our Excel 2013 actual test pdf to help every candidates pass exam. Any questions or query will be answered in two hours. We are 7*24 on-line working even on official holidays.

If you are interested in purchasing 77-420 actual test pdf, our ActualPDF will be your best select. If you want to know more products and service details please feel free to contact with us, we will say all you know and say it without reserve. Trust me, our Excel 2013 actual test pdf & Excel 2013 actual test latest version will certainly assist you to pass Microsoft Excel 2013 as soon as possible.

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.

Microsoft 77-420 Exam Syllabus Topics:

Section	Weight	Objectives
Topic 1: Create and Manage Worksheets and Workbooks	25%	- Manage Worksheets 1. Insert, delete, rename, and move worksheets 2. Format worksheet tabs - Manage Workbooks 1. Save and share workbooks 2. Inspect and protect workbooks
Topic 2: Perform Operations with Formulas and Functions	35%	- Insert formulas and functions 1. Use SUM, AVERAGE, COUNT, MIN, MAX 2. Use logical functions such as IF - Audit formulas 1. Check for errors in formulas 2. Trace precedents and dependents
Topic 3: Manage Data Cells and Ranges	20%	- Manage data in worksheets 1. Use data validation rules 2. Sort and filter data - Format cells and ranges 1. Merge and align data 2. Apply cell formats and styles
Topic 4: Create Tables	20%	- Create and format tables 1. Apply table styles 2. Convert ranges to tables - Manage table data 1. Sort and filter table data 2. Add calculated columns
Topic 5: Create Charts and Objects	20%	- Create charts 1. Insert and modify charts 2. Select appropriate chart types - Insert and format objects 1. Format visual elements 2. Insert images and shapes