Microsoft 77-420 - Excel 2013
- Exam Code: 77-420
- Exam Name: Excel 2013
- Updated: Sep 15, 2026
- Q & A: 30 Questions and Answers
When the exam changes, we move. The moment Microsoft Excel 2013 content is updated, TestPDF's experts devote their time to research and revision, keeping the 77-420 bank current — and your copy updates free for 365 days.
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Microsoft Office Specialist: Microsoft Excel 2013 |
| Exam Number: | 77-420 |
| Certificate Validity Period: | No expiration (Microsoft Office Specialist certifications do not expire) |
| Related Certifications: | Microsoft Office Specialist: PowerPoint 2013 Microsoft Office Specialist: Outlook 2013 Microsoft Office Specialist: Word 2013 |
| Passing Score: | 700 (on a scale of 1000) |
| Exam Format: | Live in-application testing, Performance-based tasks |
| Exam Duration: | 60 minutes |
| Available Languages: | Spanish, French, German, Japanese, Chinese (Simplified), Korean, English |
| Exam Price: | Approximately 100 USD (varies by region) |
| Real Exam Qty: | Performance-based tasks (typically 35–50 tasks, varies) |
| Recommended Training: | MOS Excel 2013 Study Resources Microsoft Learn - Excel training |
| Exam Registration: | Certiport Microsoft MOS Registration |
| Sample Questions: | ![]() |
| Exam Way: | Proctored exam delivered via Certiport authorized testing centers or online proctoring (where available). |
| Pre Condition: | No formal prerequisites required, but familiarity with Microsoft Excel 2013 is recommended. |
| Official Syllabus URL: | https://certiport.pearsonvue.com/Certifications/Microsoft/MOS/Overview |
| Section | Weight | Objectives |
|---|---|---|
| Create Charts and Objects | 20% | - Create charts
|
| Create and Manage Worksheets and Workbooks | 25% | - Manage Worksheets
|
| Create Tables | 20% | - Manage table data
|
| Perform Operations with Formulas and Functions | 35% | - Insert formulas and functions
|
| Manage Data Cells and Ranges | 20% | - Format cells and ranges
|
Immediately and easily. Upon successful payment, our system sends the product file to your mailbox automatically — typically within about a minute — with an instant download link as well. If nothing arrives within two hours, check your spam folder and contact support. Installations are unlimited, the PDF supports printing for paper-based review, and your purchase includes 365 days of free updates: whenever the exam content changes, the latest version reaches you automatically, with a 50% renewal discount after the year ends.
The Microsoft Excel 2013 blueprint covers these principal domains:
The remaining domains appear in the full official outline, all of which our bank addresses.
As of the latest information, the passing score for the 77-420 exam is 700 (on a scale of 1000) and the fee is Approximately 100 USD (varies by region). Microsoft can revise both, so confirm the current figures on the official site before registering.
Registration runs through the official channels below:
Choose your center or online session, and reserve early for the most convenient dates.
Documented and dependable. If you fail the corresponding exam within 60 days of purchase, email us a scanned copy of your enrollment slip and your official Score Report PDF within two days of the exam date; verified claims are refunded in full within seven days. Exclusions apply: exams taken within three days of purchase, candidate names that do not match the payer, and free or expired products. Alternatively, request a free exchange for two products of equal value.
Microsoft recommends these official training options:
Pick the course matching your experience, then reinforce it with regular question practice.
Microsoft lists the following prerequisites for the Microsoft Excel 2013: No formal prerequisites required, but familiarity with Microsoft Excel 2013 is recommended..
Confirm the details on the official certification page before you book.
Per current exam information, the 77-420 exam includes Performance-based tasks (typically 35–50 tasks, varies) questions and allows 60 minutes minutes. Timed practice beforehand makes the format feel routine on the day.
Because every step respects your time. Buying is a simple, transparent procedure: choose your version or package, see the cost generated automatically, confirm, and order — then the materials arrive by email in about a minute. The 77-420 content is clear, the main points easy to acquire, and every answer expert-verified; the PDF prints for paper review. When the exam changes, our experts devote their energy to immediate research and revision, and critical comments trigger improvement measures as soon as possible. A free demo lets you run a mini-test and confirm quality first, and your personal information is protected on an integrity-based platform throughout.
CORRECT TEXT
Modify the cell alignment settings.
Cell range B3:B25
Horizontal: Right (Indent)
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click cell B3.
Step 2:Shift-click cell B25
Step 3:Right-click somewhere in the B3-B25 cell range, and choose Format Cells from the
context menu.
Step 4:In the Format Cells dialog box click the Alignment Tab, change Horizontal: to Right (Indent), change Indent: to 1, and then click the OK button.
CORRECT TEXT
Formula.
Find the minimum homework score for each student.
Cell range D7:D29
Number 1: minimum homework score for each student on "Section 3" worksheet.
Use the following steps to complete this task in
Explanation:
Step 1: Click cell D7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function MAX,
and click OK.
Formula.
Find the minimum homework score for each student.
Correct Answer:
Step 1: Click cell D7, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function MIN, 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 D7 downwards until cell D29.
Result will be like:
CORRECT TEXT
Change the color theme. MathTracker.xlsx Slipstream
Correct Answer:
Use the following steps to complete this task in
Explanation:
Step 1:Click the PAGE LAYOUT tab, click Colors, scroll down and select Slipstream.
Over 40257+ Satisfied Customers
922 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)Thank you for 77-420 dumps.
I must to say I can not pass without this 77-420 study dump. Many questions are same with 77-420 practice braindumps. Thanks!
Your name stands true!! THANK YOU !!!
I just passed my 77-420 exam today.
TestPDF updated version 77-420 is useful.
The 77-420 practice material helped me a lot to pass 77-420 exam. Buy it now if you need to pass the 77-420 exam! It works as guarantee!
Got through different web sites for real exam dumps for my upcoming Microsoft 77-420 exam. Finally TestPDF gave me the 100% guarantee to pass.
I took the 77-420 exam last week in Korea. And I passed the 77-420 exam safely. I got 95% scores! It is already pretty high for me.
Your 77-420 questions are the real ones.
I got all the 77-420 questions in it.
I attended the 77-420 exam today, in the real exam, I encountered most questions in the 77-420 training materials, and I had confidence that I can pass the exam this time.
TestPDF helped me get started to scope all the knowledge, which I needed for the 77-420 examination.
You must try study 77-420 dump, really good. Good luck!
The online 77-420 exam guide is very convinient for us.
77-420 real exam questions are still valid more than 98%.
TestPDF 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.
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.
If you prepare for the exams using our TestPDF 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.
TestPDF 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.