Microsoft 77-420 - Excel 2013

Microsoft 77-420 Actual PDF
  • Exam Code: 77-420
  • Exam Name: Excel 2013
  • Updated: Sep 15, 2026
  • Q & A: 30 Questions and Answers
Already choose to buy "PDF"
Price: $49.99 

About Microsoft 77-420 Exam

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.

Microsoft 77-420 Exam Overview:

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:Free Download 77-420 Test PDF
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

Microsoft 77-420 Exam Syllabus Topics:

SectionWeightObjectives
Create Charts and Objects20%- Create charts
  • 1. Select appropriate chart types
    • 2. Insert and modify charts
      - Insert and format objects
      • 1. Insert images and shapes
        • 2. Format visual elements
          Create and Manage Worksheets and Workbooks25%- 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
                  Create Tables20%- Manage table data
                  • 1. Sort and filter table data
                    • 2. Add calculated columns
                      - Create and format tables
                      • 1. Convert ranges to tables
                        • 2. Apply table styles
                          Perform Operations with Formulas and Functions35%- 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
                                  Manage Data Cells and Ranges20%- Format cells and ranges
                                  • 1. Merge and align data
                                    • 2. Apply cell formats and styles
                                      - Manage data in worksheets
                                      • 1. Use data validation rules
                                        • 2. Sort and filter data

                                          77-420 Exam Information, Without the Confusion

                                          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:

                                          • Manage Data Cells and Ranges (20%)
                                          • Create Charts and Objects (20%)
                                          • Perform Operations with Formulas and Functions (35%)

                                          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.

                                          Microsoft Excel 2013 Sample Questions:

                                          Question #1

                                          CORRECT TEXT
                                          Modify the cell alignment settings.
                                          Cell range B3:B25
                                          Horizontal: Right (Indent)

                                          Reveal Solution  Discussion  0

                                          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.

                                          Question #2

                                          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.

                                          Reveal Solution  Discussion  0

                                          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:

                                          Question #3

                                          CORRECT TEXT
                                          Change the color theme. MathTracker.xlsx Slipstream

                                          Reveal Solution  Discussion  0

                                          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.

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

                                          Thank you for 77-420 dumps.

                                          Sherry

                                          Sherry     4.5 star  

                                          I must to say I can not pass without this 77-420 study dump. Many questions are same with 77-420 practice braindumps. Thanks!

                                          Stanley

                                          Stanley     4 star  

                                          Your name stands true!! THANK YOU !!!
                                          I just passed my 77-420 exam today.

                                          Meredith

                                          Meredith     5 star  

                                          TestPDF updated version 77-420 is useful.

                                          Noah

                                          Noah     4 star  

                                          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!

                                          Althea

                                          Althea     4 star  

                                          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.

                                          John

                                          John     4 star  

                                          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.

                                          Walker

                                          Walker     5 star  

                                          Your 77-420 questions are the real ones.

                                          Betty

                                          Betty     4.5 star  

                                          I got all the 77-420 questions in it.

                                          Patricia

                                          Patricia     4.5 star  

                                          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.

                                          Ansel

                                          Ansel     5 star  

                                          TestPDF helped me get started to scope all the knowledge, which I needed for the 77-420 examination.

                                          Florence

                                          Florence     4.5 star  

                                          You must try study 77-420 dump, really good. Good luck!

                                          Gilbert

                                          Gilbert     4.5 star  

                                          The online 77-420 exam guide is very convinient for us.

                                          Ryan

                                          Ryan     4 star  

                                          77-420 real exam questions are still valid more than 98%.

                                          Jerry

                                          Jerry     4.5 star  

                                          LEAVE A REPLY

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

                                          Quality and Value

                                          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.

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

                                          Try Before Buy

                                          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.

                                          Our Clients