77-420 Excel 2013 Core Exam Guide: Skills, Preparation, and Scheduling Decisions
Exam 77-420 validates practical Excel 2013 skills through a project-based assessment in which candidates create and edit a workbook with multiple worksheets. It is aimed at learners and professionals who need to demonstrate core spreadsheet ability rather than only recall commands. This guide helps you decide whether the exam matches your current Excel version and goal, identify the skills that need practice, build a workbook-based study plan, and verify registration details before committing to a test appointment.
What does exam 77-420 validate?
Exam 77-420 is the Microsoft Office Specialist Excel 2013 Core exam, and its central task is practical workbook production. Certiport describes the assessment as project-based and performance-based: candidates work inside Excel on realistic exercises rather than responding only to isolated questions. The official examples include budgets, team-performance charts, sales invoices, and exercise logs.
That distinction should determine how you prepare. Knowing the name of a command is not enough if you cannot locate it, apply it to the correct range, and preserve the workbook’s intended structure. Your preparation should therefore alternate between learning a feature and using it in a complete workbook.
The exam belongs to the MOS 2013 lineup. Certiport identifies 77-420 as “Excel 2013 Core,” while the Excel 2013 Expert pathway uses separate Expert Part One and Expert Part Two exams. Passing the core exam should not be treated as proof that you have completed the Expert pathway.
Who is the exam for?
The strongest fit is a candidate who regularly creates or edits Excel 2013 workbooks and needs an external validation of core skills. That may include a student, an office worker, or someone preparing for an academic or workforce opportunity. The official description focuses on demonstrated ability to complete a realistic Excel project, not on a particular job title.
It may be a poor scheduling choice if your only experience is with a substantially different Excel interface and you have no opportunity to practise in Excel 2013. The objective document is version-specific, so first confirm that your training environment exposes the menus, views, and behaviours required by the 2013 objectives.
What it does not establish
The core exam does not, from the supplied evidence, establish advanced Excel expertise, mastery of newer Excel releases, or completion of the Excel 2013 Expert certification. It also does not make unauthorized exam content or memorization a safe substitute for learning. Use the objective document as the boundary of legitimate study, and use practice workbooks to demonstrate that you can perform the tasks.
Should you schedule 77-420 or choose another path?
Make the version and certification decision before studying deeply. Excel 2013 follows Microsoft’s Fixed Lifecycle Policy; Microsoft lists its mainstream support end as 4/11/2018 and extended support end as 4/12/2023. That does not by itself answer whether a centre currently offers 77-420, so verify availability with the official certification provider before paying or booking.
If your objective is specifically a historical MOS Excel 2013 credential, 77-420 is the relevant core designation identified by Certiport. If your employer or school expects a newer Microsoft Office certification, ask which exam code and Office version they require rather than assuming that a 77-420 result transfers to a current exam.
The supplied Microsoft Q&A material includes candidates asking about registration and whether a 77-420 pass could be used toward a newer Excel Expert exam. Those discussions do not provide a current policy ruling. Treat progression, substitution, renewal, and transfer questions as matters to confirm through the current official support or registration channel.
Check the delivery route before making a plan
The available registration discussion shows a candidate asking about registering through Certiport when no nearby proctoring location was available. The evidence does not establish a universal online-delivery option, a Pearson VUE route, or current centre availability for every candidate. Use Certiport’s current registration and testing-centre information to confirm where and how this specific exam can be delivered.
Do not build your schedule around an assumed delivery method. First identify an authorized testing centre or the currently supported registration route, then confirm the appointment’s practical conditions directly with the provider. The official sources supplied here do not verify a current price, duration, passing score, retake rule, or appointment lead time, so those details should be checked rather than guessed.
Confirm the credential’s relevance
Certiport states that candidates who achieve MOS 2013 exam certification earn a digital badge. The badge may be useful when your institution or employer recognizes the MOS 2013 credential, but recognition is an organizational decision. Before scheduling, ask the receiving organization whether it wants the Excel 2013 Core credential, an Expert credential, or a current-version alternative.
What skills are measured?
The official 77-420 outline organizes the work around creating and managing worksheets and workbooks, creating cells and ranges, and creating tables, alongside the broader Excel fundamentals described by Certiport. Study the objective document as an action list: each verb should become something you can carry out in a workbook without step-by-step prompting.
The outline also reaches beyond simple data entry. It includes formatting, organization, workbook views, print and save preparation, and other controls that affect how a workbook is used. A candidate who practises only formulas or chart creation is leaving visible parts of the assessment scope untouched.
No blueprint percentages are included in the supplied verified facts. Do not assign unofficial weightings to the domains or compare bare percentages. Instead, use the complete objective list to identify gaps and give additional practice time to tasks that repeatedly cause errors.
Domain 1.0: Create and Manage Worksheets and Workbooks
The official objective document names “Create and Manage Worksheets and Workbooks” as objective domain 1.0. It includes creating blank or template-based workbooks, importing files, opening non-native files in Excel, and adding, copying, or moving worksheets.
Navigation is part of this domain. The listed tasks include searching for data, inserting hyperlinks, changing worksheet order, using Go To, and using the Name Box. Practise these actions in a workbook with several sheets so that navigation is performed in context rather than as disconnected demonstrations.
The domain also includes formatting worksheet and workbook elements, such as page setup, rows and columns, themes, watermarks, headers and footers, and data validation. Finally, the outline covers configuring workbooks for printing or saving, including print areas, alternate file formats, print scaling, repeating headers and footers, compatibility, and remote save locations.
A useful exercise is to create a small operational workbook with an input sheet, a summary sheet, and a print-ready report. Import or open source data, rename and reorder sheets, set a print area, repeat appropriate headings, apply validation, and save a copy in an alternate format. Check the result after closing and reopening it.
Domain 2.0: Create Cells and Ranges
The official outline names “Create Cells and Ranges” as objective domain 2.0. The covered actions include entering, finding, replacing, copying, pasting, autofilling, and deleting cell data.
Cell and range formatting includes merging, alignment, fonts, Format Painter, text wrapping, number formats, highlighting, cell styles, and WordArt. These tasks test whether you can apply a deliberate visual treatment to the correct selection, not merely whether you can make a worksheet look attractive.
The objectives also include organizing data with conditional formatting, sparklines, transposition, named ranges, outlines, collapsed groups, and subtotals. Practise the difference between changing a value, changing a display format, and changing a rule that responds to values. Those actions can produce similar visual effects while using different tools.
Build a controlled practice sheet with raw entries, calculated results, and a short report area. Use named ranges and subtotals, create a conditional-formatting rule, add a sparkline, transpose a small block, and group rows. Then deliberately select the wrong range and correct it; selection discipline is a practical weakness that ordinary reading will not expose.
Domain 3.0: Create Tables
The official outline names “Create Tables” as objective domain 3.0. Its listed tasks include creating a table, changing its style, controlling banding, showing a total row, filtering, sorting by multiple columns, and removing duplicates.
The important preparation decision is to treat a table as a structured object rather than as ordinary cells with borders. Practise selecting the intended data region, confirming that headers are interpreted correctly, and checking the table’s visual and functional settings after each change.
Use a dataset containing repeated records, blank-looking values, dates, and several sortable fields. Convert it to a table, change the style and banding, display a total row, filter one field, sort by more than one field, and remove duplicates only from a copy. Compare the source and result so that cleanup does not become accidental data loss.
Core Excel areas described by Certiport
Certiport summarizes the Excel 2013 Core skill set as fundamentals involving worksheets and workbooks, cells and ranges, tables, formulas and functions, and charts and objects. The official 77-420 objective facts supplied here provide detailed examples for the first three areas, but they do not provide a complete function list or a complete chart-and-object task list.
Prepare for formulas and functions by practising accurate references, copying formulas across a range, checking results, and recognizing when a displayed number is a formatting issue rather than a calculation issue. For charts and objects, practise creating a clear visual from a prepared dataset, selecting the intended source range, and applying basic placement and formatting controls available in your Excel 2013 environment.
Do not turn unspecified features into invented exam promises. Use the official objective document for the exact task boundary, and make your own skills checklist from the items it names. Certiport’s examples of budgets, performance charts, invoices, and exercise logs are useful practice contexts, not a guarantee that the same scenario will appear.
How should you practise for a project-based assessment?
Practise by completing small workbook projects from a blank file, then repeat them with less guidance. A project should require you to navigate, enter or import data, format ranges, structure a table, organize information, prepare output, and save the result. This mirrors the practical nature of the MOS 2013 assessment more closely than reading feature descriptions or memorizing menu paths.
Use a three-pass method. On the first pass, follow a reference and learn the correct workflow. On the second, rebuild the workbook from a written task list. On the third, use only the objective title and judge whether the finished workbook meets the requested outcome.
Keep an error log with three columns: task, mistake, and prevention. “Could not find the command” requires interface practice; “used the wrong range” requires selection checks; “result changed after sorting” requires understanding references or table structure. This turns vague discomfort into a next study action.
Certiport presents a learn, practise, and certify pathway. Apply that sequence without treating a practice exam score as proof of readiness. The more reliable readiness signal is repeatable performance on unfamiliar but legitimate workbook tasks.
Use version-appropriate practice files
Work in Excel 2013 when possible because the examination objectives identify that product version. If you use another Excel release, record interface differences instead of assuming that every command, default, or menu location is identical.
The supplied Microsoft Q&A page about Joan Lambert’s MOS Excel 2013 study-guide files contains conflicting user experiences about locating downloads and redirects. It is therefore not evidence that a particular practice-file link is currently available. Use only files obtained through a legitimate, currently functioning source, and do not rely on unofficial exam-question repositories or “dumps.”
Practise outcomes, not interface choreography
A menu path can change when you work in another setup, but the required outcome remains concrete: a worksheet is reordered, a range is formatted, a table is filtered, or a print area is configured. After each exercise, inspect the workbook and ask whether the requested result is visible and preserved.
For example, after applying data validation, test an allowed and disallowed entry in a copy. After setting print scaling, inspect the print preview or output available in your environment. After using conditional formatting, change a value to confirm that the rule responds as intended. These checks expose incomplete operations that may look correct at first glance.
A practical study roadmap
A staged roadmap is more useful than an arbitrary countdown. Start with an objective audit, then build competence in workbook structure and cell operations, add tables and presentation tasks, and finish with mixed projects and registration checks. Adjust the pace to your baseline; the supplied sources do not establish an official preparation duration.
Keep one working file for each major exercise and a separate clean copy for timed or independent practice. Naming files clearly helps you compare versions and identify whether an error came from the procedure or from editing the wrong workbook.
Stage 1: Audit the objective list
Download or open the official 77-420 objective document and convert every listed action into a checklist. Mark each item as unfamiliar, guided, independent, or repeatable. Do not mark a task complete because you watched it once; mark it complete when you can perform it and verify the result.
Open Excel 2013 and check which practice environment you actually have. Note whether you can work with multiple sheets, imported files, print settings, alternate formats, and the interface controls named in the objectives. Resolve environment gaps early rather than discovering them near the appointment.
Stage 2: Build workbook and range control
Begin with blank and template-based workbooks, importing or opening files, adding and moving sheets, navigation, data entry, find and replace, copying, pasting, autofill, and deletion. Then add formatting: alignment, fonts, wrapping, number formats, styles, merging, and Format Painter.
At the end of this stage, create a workbook without a tutorial. Include a source sheet, a working sheet, and a presentation sheet. Use Go To, the Name Box, a hyperlink, and a changed worksheet order. Review every sheet for accidental edits before moving on.
Stage 3: Add organization and tables
Next practise conditional formatting, sparklines, transposition, named ranges, outlines, collapsed groups, and subtotals. Follow this with table creation, styles, banding, total rows, filtering, multi-column sorting, and duplicate removal.
Keep the original data untouched while testing cleanup operations. This is both a sound spreadsheet habit and a way to distinguish the intended result from an irreversible mistake. Rebuild the same exercise from a new source file once you can complete it correctly.
Stage 4: Finish presentation, views, and output
Use a project to combine page setup, row and column adjustments, themes, watermarks, headers and footers, data validation, print areas, scaling, repeating headings, compatibility checks, and alternate save formats. Practise workbook views and the other options named in the outline, including formula display, freeze panes, split windows, shortcut keys, simple macros, the Quick Access Toolbar, Ribbon customization, and macro security.
Do not spend all your time making a workbook decorative. Give priority to the requested business result, correct data, readable output, and preserved structure. A polished workbook with an incorrect range is still incorrect.
Stage 5: Run independent mixed projects
Create several unfamiliar projects from short written instructions. One might resemble a budget, another a performance report, and another an invoice or exercise log, reflecting the kinds of situations Certiport uses to describe Excel 2013 testing. Do not copy an online exam item; generate your own data and instructions.
After each project, compare the finished workbook with a checklist rather than with a remembered screen image. Record every hesitation, then repeat only the weak operation the next day before attempting another full project. Readiness means that you can recover from an unfamiliar starting file.
Stage 6: Verify registration and final readiness
Before scheduling, confirm that the official provider still lists the exam route, that the centre or supported delivery option suits you, and that your training software matches the exam version. Confirm identity, appointment, rescheduling, and result procedures directly with the provider because the supplied evidence does not verify current policies.
In the final review, avoid learning large collections of new features. Recheck the objective list, complete one mixed workbook, inspect saved files, and review your error log. If the same task still requires a tutorial, postpone scheduling or allocate focused practice to that task.
Common preparation mistakes and better replacements
Most weak preparation plans fail through incomplete practice rather than lack of study material. Candidates read about commands, practise only familiar worksheets, or trust a remembered interface path. Replace passive review with observable outcomes: create the file, apply the requested change, save it, reopen it, and verify the result.
A second mistake is confusing the core exam with the Expert pathway. Certiport states that becoming a Microsoft Office Excel 2013 Expert requires both Expert required exams, Part One and Part Two. Keep that distinction clear when discussing your credential with an employer or choosing a follow-on goal.
A third mistake is treating unsupported scheduling information as permanent. Exam availability, locations, registration systems, and delivery choices can change. The supplied Microsoft Q&A registration discussion illustrates the kind of uncertainty candidates may encounter, but it is not a current catalogue of all available routes.
Mistake: studying only formulas
Formulas and functions matter, but Certiport’s description also covers workbooks, cells and ranges, tables, charts, and objects, while the objective document includes views, formatting, organization, and output preparation. Use a rotation that touches each objective area instead of repeating the one feature you already enjoy.
Mistake: formatting before selecting carefully
Many workbook errors begin with the wrong selection. Before merging, applying a style, adding conditional formatting, or changing a number format, state the intended range aloud or check it in the Name Box. After the operation, inspect adjacent cells for unintended changes.
Mistake: deleting duplicates in the only copy
Duplicate removal is explicitly listed under table objectives, but the objective does not tell you that every dataset should be altered permanently. Preserve a source copy, define what makes a record duplicate, and verify the resulting row count and values. This prevents a technically correct command from producing an incorrect business result.
Mistake: assuming a practice file is an exam file
The official sources support practice through preparation tools and practice exams, but they do not authorize the use of leaked questions or guarantee that a particular third-party file represents the live assessment. Use legitimate study material to learn skills and create your own variations so that you are not dependent on memorization.
How can you decide that you are ready?
You are ready to consider scheduling when you can complete a mixed, unfamiliar workbook from written instructions, use the named tools without constant searching, and explain how you verified the final result. A single successful exercise is not enough; look for repeatability across different layouts and data types.
Use the following readiness checks: create and manage several worksheets; navigate with Go To and the Name Box; enter, copy, autofill, find, replace, and delete data; apply range formatting; organize information with the listed tools; create and control a table; and configure the workbook for practical output.
Then test recovery. Start with a workbook containing a deliberately misplaced sheet, an incorrectly selected range, and data that needs filtering. Correct the problems without rebuilding everything. A project-based assessment rewards controlled execution, so recovery and checking deserve practice time.
If a task remains slow, separate knowledge from fluency. If you know the intended outcome but cannot locate the command, practise the Excel 2013 interface. If you locate it but affect the wrong cells, practise selection and verification. If the result is wrong, revisit the underlying spreadsheet concept rather than repeating clicks.
Final review checklist
Review the official objectives one final time and flag any item you have never performed. Open your own practice workbook rather than a familiar tutorial file. Complete a short sequence that moves from data entry to organization, formatting, table work, and output preparation.
Check that formulas still calculate, table filters and sorting produce the intended view, headers and footers are appropriate, print settings are deliberate, and the file is saved in the required form for your practice environment. These checks are practical recommendations, not additional official exam requirements.
Questions to resolve with the provider
Confirm current exam availability, authorized registration route, testing location or delivery method, identification requirements, appointment rules, result handling, and any retake or rescheduling policy. None of these current details is established by the supplied facts, and a careful candidate should not rely on an old forum response or an unverified search result.
If your aim is a newer Excel credential or Expert certification, ask the relevant certification authority whether 77-420 has any accepted relationship to that target. The Microsoft Q&A discussion shows that this is a real candidate question, but it does not provide a definitive current equivalency rule.
What should you do next?
Start with the official 77-420 objective document, not with a dump or an assumed exam outline. Build a checklist, open a version-appropriate Excel environment, and produce a small multi-sheet workbook that exercises navigation, cells and ranges, tables, formatting, and output. Your first result will reveal more about your preparation needs than a generic confidence estimate.
If the workbook exposes gaps, schedule practice rather than the exam. If you can repeat the work independently, verify the current registration route and confirm that the credential matches your institution or employer’s requirement. Keep your preparation focused on demonstrable Excel 2013 capability and make every scheduling decision from current provider information.
Remember that the official sources describe a practical, project-based MOS assessment. The most defensible preparation is therefore practical too: learn the feature, apply it to new data, inspect the result, preserve a clean source, and repeat until the workflow is reliable.
Conclusion
Exam 77-420 is best approached as a workbook-production assessment, not a terminology quiz. Use the official objectives to cover the full skill range, practise in Excel 2013 where possible, and measure progress through independent projects that you can check and correct. Because Excel 2013 is a legacy product and the supplied evidence does not establish current appointment conditions, verify exam availability and progression rules directly with Certiport before scheduling. Avoid dumps and unsupported promises; reliable performance on legitimate, unfamiliar tasks is the preparation decision that matters.
Related exams
- 77-725 exam — Microsoft Word 2016 Core: Document Creation, Collaboration and Communication (MOS)
- 77-427 exam — Excel 2013 Expert Part One
- 77-727 exam — Excel 2016: Core Data Analysis, Manipulation, and Presentation
- 77-728 exam — Excel 2016 Expert: Interpreting Data for Insights
- MB-910 exam — Microsoft Dynamics 365 Fundamentals Customer Engagement Apps (CRM)
- MO-101 exam — Microsoft Word Expert (Word and Word 2019)
