Work and study can share a week if the materials respect both. DumpsActual lets you balance them: 30 practice questions in three formats — a printable PDF, an offline Windows simulator, and an online engine for the spare minutes between tasks.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Excel 2013 |
| Exam Number: | 77-420 |
| Exam Price: | USD 100–115 |
| Certificate Validity Period: | Lifetime (no expiration, retired June 30, 2024) |
| Related Certifications: | 77-428 Microsoft Excel 2013 Expert Part Two 77-427 Microsoft Excel 2013 Expert Part One Microsoft Office Specialist 2013 Microsoft Office Specialist 2013 Master |
| Real Exam Qty: | 30-40 |
| Available Languages: | Portuguese (Brazil), Spanish, Norwegian, English, German, Arabic, Vietnamese, Greek, Russian, Traditional Chinese, Dutch, Polish, Italian, Japanese, Korean, Simplified Chinese, French |
| Exam Format: | Simulation-based questions, Performance-based tasks |
| Exam Duration: | 50 minutes |
| Passing Score: | 700 / 1000 |
| Recommended Training: | Certiport Learning Resources Microsoft Official MOS Training |
| Exam Registration: | Microsoft Official Exam Page Certiport Registration |
| Sample Questions: | ![]() |
| Exam Way: | Proctored on-site at Certiport testing centers; no online proctoring |
| Pre Condition: | No formal prerequisites; basic working knowledge of Microsoft Excel 2013 recommended |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/exams/77-420/ |
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Create Cells and Ranges | 25% | - Format cells and ranges
|
| Topic 2: Create and Manage Worksheets and Workbooks | 30% | - Navigate through worksheets and workbooks
|
| Topic 3: Apply Formulas and Functions | 20% | - Utilize cell references
|
| Topic 4: Create Charts and Objects | 10% | - Create and format charts
|
| Topic 5: Create Tables | 15% | - Modify tables
|
The 77-420 exam is a Microsoft certification exam validating the Microsoft Excel 2013 syllabus shown above. It belongs to these credential paths: Microsoft Office Specialist 2013, Microsoft Office Specialist 2013 Master, 77-427 Microsoft Excel 2013 Expert Part One, 77-428 Microsoft Excel 2013 Expert Part Two. Candidates in 2026 prepare for it with DumpsActual's 30 practice questions, available as a printable PDF, a Windows Desktop Test Engine, and an Online Test Engine — three versions of the same materials.
Proctored on-site at Certiport testing centers; no online proctoring Register for the Microsoft Excel 2013 exam through these official channels:
After booking, DumpsActual delivers your practice questions within 1 minute — preparation starts the same day.
Three versions of the same study materials: a printable, expert-prepared PDF with free demo download and instant access; a Desktop Test Engine for Windows that simulates the real exam with two practice modes and works offline; and an Online Test Engine for any browser on Windows, Mac, Android, and iOS with test history and performance review. All 30 practice questions are identical across versions. Every purchase includes 365 days of free updates, a 50% renewal discount afterward, and unlimited computer installations — and the website runs discounts at intervals, so timing your purchase can save a little more.
The Microsoft Excel 2013 exam contains 30-40 to complete within 50 minutes. Timed simulation in the DumpsActual Desktop Test Engine teaches that rhythm before exam day does.
The official Microsoft Excel 2013 outline defines 5 domains. The leading three are Create Tables (15%), Create Cells and Ranges (25%), and Create Charts and Objects (10%). The full list is in the topics section above, and DumpsActual's 30 practice questions cover each one.
Microsoft recommends these training resources for the Microsoft Excel 2013 exam:
Follow the training with steady self-testing — the 30 practice questions from DumpsActual help you apply theory and fill any gaps the training leaves.
No formal prerequisites; basic working knowledge of Microsoft Excel 2013 recommended Since requirements change over time, confirm the latest on the official Microsoft exam page before scheduling.
DumpsActual issues a full refund if you take the Microsoft Excel 2013 exam within 60 days of purchase and do not pass. The policy does not apply if the exam is taken within 3 days of purchase, if the exam was never actually taken, or to free materials or expired orders, and the candidate name must match the payer name. Submit a scan of your enrollment slip and the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Alternatively, exchange for two free exam products of equal value and keep your original update service. Orders arrive by email within 1 minute — contact support if nothing arrives within 2 hours.
The Microsoft Excel 2013 exam requires 700 / 1000 to pass, and registration costs USD 100–115. A failed attempt means paying the same fee again — a readiness check with the DumpsActual engines before booking is the cheaper option.
CORRECT TEXT
Sort and Filter.
Apply a sort and a filter to the table.
Cell range B6:F29
Sort Column Zero Scores Order Largest to Smallest Column IDs Order Smallest to Largest Filter Hide students ids with no zero scores.
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click a cell in the table.
Step 2:On the Home tab select the Sort & Filter button, and select Custom sort (needed to
sort on more than one column at a time).
Step 3:In the Sort dialog box select Sort by: Zero Scores, Order: Largest to Smallest, and click the Add Level button.
Step 4:Select then by: Ids, Order: Smallest to Largest, and click the OK button.
Step 5:Click the Zero Scores column header header arrow, select Number Filters, and clickDoes not Equal.
Step 6: In the Custom AutoFilter enter 0, and click OK The result will look like:

CORRECT TEXT
Formula. Find the average of each student's homework scores.
Cell range C7:C29
Use Function AVERAGE
Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click cell C7, and the click the Insert Function Button.
Step 2:In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK.
The function Arguments Dialog box appears:
Step 3:Click on the Section 3 tab (left bottom part of the window).
Step 4:Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.
Step 5:Copy cell C7 downwards until cell C29.
Result will be like:
CORRECT TEXT
Formula.
Find themaximum homework score for each student.
Cell rangeE7:E29 Use Function MAX Number 1: maximum homework score for each student on "Section 3" worksheet.
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1: Click cellE7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function MAX, and click OK.
The function Arguments Dialog box appears:
Step 3: Click on the Section 3 tab (left bottom part of the window).
Step 4: Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.
Step 5: Copy cellE7 downwards until cellE29.
Result will be like:
Viewing page 1 out of 10 pages.
Viewing questions 1-3 out of 30 questions.
Over 76101+ Satisfied Customers
1195 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)I am planning to take other certification exams and going to use for sure.
DumpsActual 77-420 Exam Engine proved the best pathway to enhance my career. I used DumpsActual practice tests to consolidate and revise the certification syllabus.
Luckily, most of the questions in my exam are from your 77-420 study materials. I passed my exam today easily. I will recommend your website- DumpsActual to all the people that I know!
The exam dumps from DumpsActual helped me to score breakthrough results in 77-420 exams. I couldn't clear my exams without DumpsActual exam practice questions & answers. Thanks!
Almost all of 77-420 questions in real exam are from dumps, so it was not that difficult to get the certification. You can rely on it.
I came across a lot of questions from the 77-420 dumps and I passed. These dumps are valid,
Passed 77-420 exam. Everything went quite smoothly. Study hard guys, 77-420 will become easy with this 77-420 questions set.
Good 77-420 study material, very useful! I passed my exam two weeks ago.
Thank you guys for updating 77-420 exam questions.
Thanks so much!
wow, I cant believe my eyes, I passed 77-420 exam successfully.
My promotion was attached to passing the 77-420: Excel 2013 exam. Had not time to spare for preparation but needed that promotion badly. Eventually paid for DumpsActual 77-420 then it made me pass
Very similar questions and accurate answers for the 77-420 certification exam. I would like to recommend DumpsActual to all giving the 77-420 exam. Helped me achieve 91% marks.
It really was tough for me to prepare for the 77-420 exam. After with 77-420 exam materials' help, I passed it for the whole thing in just a couple days and achieved 96% score. Thank you very much!
I'm very happy about the service and the 77-420 dump. I passed with a high score in my 77-420 exam. Most of questions are from the dumps. I am so happy!
I appeared today for my 77-420 exam and passed. I would not have passed the 77-420 exam without it. Good study material for the test.
After praparation for one week, i was ready to rock my exam day and successfully passed the exam. Everything went well. Thanks for so helpful 77-420 exam materials!
I had almost given up after failing the 77-420 exam. In this time of depression, somebody suggested DumpsActual Study Guide to me. The question and answer format was good
I’m preparing for my 77-420 exam and just stumbled upon this site. I passed my 77-420 exam with their practice test. It is a good chance.
DumpsActual 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.
If you prepare for the exams using our DumpsActual 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.
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.
DumpsActual 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.