Microsoft 77-420 Exam : Excel 2013

  • Exam Code: 77-420
  • Exam Name: Excel 2013
  • Updated: Oct 24, 2026
  • Q & A: 30 Questions and Answers

Already choose to buy: "PDF"

Total Price: $49.99  

About Microsoft 77-420 Exam Questions

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.

Microsoft 77-420 Exam Overview:

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:Free Download real 77-420 actual tests
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/

Microsoft 77-420 Exam Syllabus Topics:

SectionWeightObjectives
Topic 1: Create Cells and Ranges25%- Format cells and ranges
  • 1. Apply borders, fill colors, and alignment
    • 2. Apply cell styles, number formats, and conditional formatting
      - Summarize and organize data
      • 1. Create named ranges
        • 2. Group, outline, and insert subtotals
          - Insert data in cells and ranges
          • 1. Enter, edit, and clear cell content
            • 2. Use AutoFill and Flash Fill
              Topic 2: Create and Manage Worksheets and Workbooks30%- Navigate through worksheets and workbooks
              • 1. Insert and follow hyperlinks
                • 2. Use Go To, Name Box, and Find/Replace
                  - Customize workbook options and views
                  • 1. Freeze panes, split windows, and change views
                    • 2. Set workbook properties and protection
                      - Format worksheets and workbooks
                      • 1. Add headers, footers, watermarks, and print areas
                        • 2. Adjust row height, column width, and alignment
                          • 3. Modify page setup, themes, and tab colors
                            - 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
                                  Topic 3: Apply Formulas and Functions20%- Utilize cell references
                                  • 1. Use relative, absolute, and mixed references
                                    - Troubleshoot formulas
                                    • 1. Correct common formula errors
                                      - Apply functions
                                      • 1. SUM, AVERAGE, MIN, MAX, COUNT
                                        • 2. Text, date, and lookup functions
                                          • 3. Logical functions: IF, AND, OR
                                            Topic 4: Create Charts and Objects10%- Create and format charts
                                            • 1. Create column, line, pie, and bar charts
                                              • 2. Modify chart titles, legends, axes, and styles
                                                - Insert and format objects
                                                • 1. Insert images, shapes, SmartArt, and text boxes
                                                  • 2. Position, resize, and apply styles to objects
                                                    Topic 5: Create Tables15%- Modify tables
                                                    • 1. Add/remove table rows and columns
                                                      • 2. Add total rows and calculated columns
                                                        - Create and format tables
                                                        • 1. Apply table styles and banded rows/columns
                                                          • 2. Convert ranges to tables
                                                            - Filter and sort table data
                                                            • 1. Remove duplicates and manage table ranges
                                                              • 2. Apply filters and custom sorts

                                                                77-420 Exam FAQ: What Candidates Ask

                                                                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.

                                                                Microsoft Excel 2013 Sample Questions:

                                                                Question #1

                                                                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.

                                                                Reveal Solution  Discussion  0

                                                                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:

                                                                Question #2

                                                                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"

                                                                Reveal Solution  Discussion  0

                                                                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:

                                                                Question #3

                                                                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.

                                                                Reveal Solution  Discussion  0

                                                                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.

                                                                10%

                                                                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.

                                                                Solomon

                                                                Solomon     5 star  

                                                                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.

                                                                Ben

                                                                Ben     5 star  

                                                                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!

                                                                Bowen

                                                                Bowen     4.5 star  

                                                                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!

                                                                Abigail

                                                                Abigail     5 star  

                                                                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.

                                                                Sidney

                                                                Sidney     5 star  

                                                                I came across a lot of questions from the 77-420 dumps and I passed. These dumps are valid,

                                                                Dennis

                                                                Dennis     5 star  

                                                                Passed 77-420 exam. Everything went quite smoothly. Study hard guys, 77-420 will become easy with this 77-420 questions set.

                                                                Barbara

                                                                Barbara     4.5 star  

                                                                Good 77-420 study material, very useful! I passed my exam two weeks ago.

                                                                Shirley

                                                                Shirley     4 star  

                                                                Thank you guys for updating 77-420 exam questions.

                                                                Osborn

                                                                Osborn     4 star  

                                                                Thanks so much!
                                                                wow, I cant believe my eyes, I passed 77-420 exam successfully.

                                                                Carol

                                                                Carol     4.5 star  

                                                                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

                                                                Andy

                                                                Andy     4.5 star  

                                                                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.

                                                                Marlon

                                                                Marlon     4 star  

                                                                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!

                                                                Payne

                                                                Payne     4 star  

                                                                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!

                                                                Jeremy

                                                                Jeremy     4 star  

                                                                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.

                                                                Andy

                                                                Andy     4 star  

                                                                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!

                                                                Ralap

                                                                Ralap     4.5 star  

                                                                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

                                                                Penelope

                                                                Penelope     4 star  

                                                                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.

                                                                Mavis

                                                                Mavis     4.5 star  

                                                                LEAVE A REPLY

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

                                                                QUALITY AND VALUE

                                                                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.

                                                                EASY TO PASS

                                                                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.

                                                                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.

                                                                TRY BEFORE BUY

                                                                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.