77-420
Excel 2013
77-420 Excel 2013 Core Exam Guide
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 suits students, office professionals, and anyone whose work depends on structured spreadsheets, tables, formulas, charts, and presentation-ready output. This guide helps you decide whether your current Excel environment matches the exam, which objective areas need deliberate practice, how to sequence study, and what to verify before arranging an exam appointment.
What does exam 77-420 validate?
Exam 77-420 is the Microsoft Office Specialist Excel 2013 Core exam, identified by Certiport within the MOS 2013 examination lineup. It assesses whether you can complete practical Excel work in the application rather than merely describe commands or recall terminology.
Certiport describes the Excel 2013 assessment as project-based and performance-based. The candidate creates and edits a workbook with multiple sheets for different purposes and situations. The official examples include professional-looking budgets, team performance charts, sales invoices, and exercise logs.
That format changes the preparation decision. Reading about a feature is useful only as a starting point; you must be able to locate it, apply it to the correct range or worksheet, and preserve the intended result in a working workbook. Practice should therefore reproduce complete spreadsheet tasks, not consist only of isolated definition questions.
The certification is evidence of ability with the Excel 2013 feature set named in the official objectives. It is not evidence that you know every feature in a newer Excel release, and it should not be presented as a current-version Excel credential without checking the target employer’s or institution’s requirements.
Who should consider this certification?
The exam is most relevant to candidates who need a formal validation of Excel 2013 workplace or academic skills and who can practise in an Excel 2013-compatible environment. It is a sensible target when a school, employer, training programme, or existing MOS pathway specifically calls for Excel 2013 Core.
A student may use the objectives to structure classroom practice around workbook creation, data organisation, formulas, and charts. An administrative or operations employee may use the same outline to identify gaps in recurring tasks such as preparing invoices, cleaning lists, producing summaries, or setting up printable reports.
Candidates moving toward the Excel 2013 Expert pathway should distinguish the Core exam from the Expert requirements. Certiport states that becoming a Microsoft Office Excel 2013 Expert requires passing both Excel 2013 Expert Part One and Excel 2013 Expert Part Two. Passing 77-420 alone is not the same as completing that Expert requirement.
If your main goal is a current Excel certification, first confirm which exam the organisation recognises. Excel 2013 reached the end of extended support on April 12, 2023, according to Microsoft’s lifecycle page. That does not by itself answer whether 77-420 is available or accepted for your purpose; check the current Certiport information and the body requesting the credential before investing in preparation.
Which skills are measured?
The official objective document groups 77-420 around workbooks and worksheets, cells and ranges, and tables, while the Certiport overview also identifies formulas and functions, charts, and objects as core skill areas. The detailed outline is the best study checklist because it turns those broad labels into observable actions.
The supplied official research does not provide percentage weights for the objective domains. Do not assign your own percentages or assume that one domain is worth more than another. Use the full objective document to assess coverage, then allocate study time according to your diagnostic results and the consequences of errors in your own work.
Create and Manage Worksheets and Workbooks
The official 77-420 outline names “Create and Manage Worksheets and Workbooks” as objective domain 1.0. Its tasks include creating blank or template-based workbooks, importing files, opening non-native files in Excel, and adding, copying, or moving worksheets.
You are also expected to navigate efficiently. The outline includes searching for data, inserting hyperlinks, changing worksheet order, using Go To, and using the Name Box. Workbook presentation and control matter as well: objectives include page setup, rows and columns, themes, watermarks, headers and footers, and data validation.
The domain also covers customising the working environment. The objective list includes the Quick Access Toolbar, Ribbon, macro security, workbook views, simple macros, formula display, freeze panes, shortcut keys, and split windows. Finally, it includes preparing workbooks for printing or saving, including print areas, alternate file formats, print scaling, repeating headers and footers, compatibility, and remote save locations.
Create Cells and Ranges
The official outline names “Create Cells and Ranges” as objective domain 2.0. It includes entering, finding, replacing, copying, pasting, autofilling, and deleting cell data, followed by formatting actions such as merging, alignment, fonts, Format Painter, text wrapping, number formats, highlighting, cell styles, and WordArt.
The objectives also include organising information with conditional formatting, sparklines, transposition, named ranges, outlines, collapsed groups, and subtotals. Practise these operations on changing data rather than on a single memorised example so that you learn to select the correct source range, destination range, and display option.
Create Tables
The official outline names “Create Tables” as objective domain 3.0. It covers creating tables, changing table styles, applying banding, adding total rows, filtering, sorting by multiple columns, and removing duplicates.
A useful practice file should include headers, repeated values, blank-looking cells, dates, and numeric fields. After each operation, inspect whether the table range, filter state, sort order, totals, and duplicate-removal result still match the task. This catches selection errors that a quick visual glance can miss.
Formulas, functions, charts, and objects
Certiport identifies applying formulas and functions and creating charts and objects among the fundamentals demonstrated by MOS Excel 2013 candidates. The supplied detailed facts do not list every formula, function, chart type, or object task, so prepare from the official 77-420 objective document rather than assuming a broader or narrower list.
Your practice should connect calculation and communication. Build a small workbook in which source data feeds calculated results, a table or summary organises the information, and a chart presents the relevant comparison. Then edit the source data and confirm that formulas, totals, references, and chart presentation continue to behave as intended.
How should you diagnose your starting point?
Begin with a timed, application-based diagnostic before reading a study guide from cover to cover. Create a small multi-sheet workbook from a written brief, then record every hesitation, incorrect result, navigation delay, and formatting repair. This reveals whether your main problem is Excel knowledge, task interpretation, or inefficient execution.
Use a fresh workbook and ordinary source data. Include at least one worksheet for raw information, one for calculations or summaries, and one for presentation. Attempt workbook navigation, cell and range editing, table operations, formatting, formula work, a chart, and print preparation if those actions are in your objective document.
Classify each weakness in a simple register: cannot perform, can perform with instructions, can perform slowly, or can perform reliably. The first two categories need teaching and repetition. The third needs short, focused drills. The fourth should be retested later under a different scenario rather than treated as permanently mastered.
A diagnostic is not a prediction of your result. It is a study-allocation tool. If you already work daily in Excel, do not skip it: workplace habits can conceal gaps in less frequently used areas such as print scaling, named ranges, workbook views, or data validation.
What Excel environment should you practise in?
Practise with Excel 2013 features and terminology wherever possible, because 77-420 is tied to the Excel 2013 product. Avoid making a newer Excel installation your only practice environment when menu locations, defaults, or available features differ from the version named by your exam provider.
Excel 2013 follows Microsoft’s Fixed Lifecycle Policy. Microsoft lists its start date as 1/9/2013 8:00:00 AM, mainstream end date as 4/11/2018 6:59:59 AM, and extended end date as 4/12/2023 6:59:59 AM. These lifecycle facts are important context, but they do not establish current registration availability or substitute for checking Certiport.
Before scheduling, confirm the exact exam identifier, the authorised provider, the software version used for delivery, and any local appointment conditions. A Microsoft Q&A registration discussion shows a candidate asking about Certiport and Pearson VUE for 77-420, but the supplied response does not establish a universal delivery policy. Treat provider information as something to verify, not something to infer from an old forum thread.
Do not build your plan around a promised delivery language, remote option, price, appointment duration, or score requirement unless the current official registration information states it. The supplied research includes a historical MOS 2013 language table, but it does not provide a current candidate-specific scheduling decision.
How should you study the workbook domain?
Study workbook management before advanced presentation because it establishes the file structure used by later exercises. Practise creating a workbook from a blank file and from a template, importing or opening source material, adding worksheets, copying and moving sheets, and changing their order without losing track of the active sheet.
Next, rehearse navigation on a workbook that is large enough to require deliberate movement. Search for values, use Go To, identify a range through the Name Box, insert a hyperlink, and move between worksheets. The goal is controlled selection: know what is selected before you format, copy, delete, or replace anything.
Then make a workbook usable for other people. Work through row and column changes, themes, headers and footers, watermarks, page setup, print areas, scaling, repeated headers, and alternate save formats. Compare the worksheet view with the resulting print or print-preview representation where your practice environment allows it.
Finish this domain with view and control tasks. Configure freeze panes and split windows on a data sheet, display formulas when checking calculations, review workbook views, and practise the specified simple macro and macro-security actions only in a safe training file. Never enable unknown macros or use an untrusted workbook merely to imitate an exam task.
How should you practise cells, ranges, and tables?
Use one changing dataset to practise selection, editing, formatting, and organisation in sequence. This prevents the common mistake of learning each command separately while failing to understand how a change affects the surrounding workbook. Save checkpoints so you can compare the intended state with the state after each operation.
For cells and ranges, practise entering and deleting values, finding and replacing data, copying and pasting, and autofilling. Follow those drills with merged cells, alignment, fonts, Format Painter, wrapping, number formats, highlighting, cell styles, and WordArt. After every formatting action, check whether the selection was the whole intended range rather than only the active cell.
Use a second pass to organise the same data. Apply conditional formatting, create a sparkline where appropriate, transpose a small range, define and use a named range, group and collapse rows or columns, and create subtotals. Record the reason for each feature; a feature used without a clear target is more likely to create a visually impressive but functionally confusing sheet.
For tables, begin with a clean header row. Create the table, change its style, test banding, enable a total row, filter a field, sort by more than one column, and remove duplicates from a copy of the source data. Verify the row count and key values after each destructive action. Keep an untouched source sheet so that you can repeat the exercise without rebuilding the data.
How should you handle formulas, charts, and objects?
Treat formulas and charts as connected parts of a workbook rather than separate decoration. Start with clearly labelled source data, calculate a useful result, summarise it, and create a chart or object that supports the stated purpose. Then change an input and trace the consequences through the workbook.
Build formula confidence by checking references, ranges, copied formulas, and displayed results. Use formula display as a checking aid when appropriate, and inspect the source cells when a result looks wrong. A correct-looking number can still come from an incorrect range, a misplaced absolute reference, or a formula copied farther than intended.
For charts, make the source selection deliberate. Identify the category labels and value series before inserting the chart, then adjust the chart so its title, labels, legend, and placement communicate the intended message. Practise editing an existing chart as well as creating one, because project work commonly requires refinement rather than a first attempt only.
Objects and visual elements should serve the workbook’s purpose. Keep presentation changes consistent with the brief, and check whether an object overlaps data, print boundaries, or headers. Do not spend study time on attractive effects that are absent from the official objectives while neglecting a named task such as data validation or print configuration.
What preparation mistakes cost candidates time?
The most damaging mistakes are usually process mistakes: practising in the wrong Excel version, ignoring the objective document, selecting the wrong range, and failing to verify the saved workbook. Correct these before adding more study materials. Project-based assessment rewards accurate completion of the requested result, not familiarity with a preferred personal workflow.
Passive watching is not enough. A video can show where a command is located, but it does not prove that you can choose the correct cells, interpret a brief, recover from an incorrect action, or complete a multi-sheet result. After learning a feature, close the reference and reproduce the task from a short written instruction.
Do not memorise a sequence without understanding the object being changed. For example, a formatting instruction may apply to a range, table, row, column, chart, worksheet, or workbook. Confirm the active object before applying the command, then inspect the result. This habit prevents many errors caused by acting on the last selection left on screen.
Avoid destructive practice without recovery points. Removing duplicates, replacing data, moving worksheets, changing formats, or saving in another format can alter later work. Keep source copies and use meaningful file names. A clean practice routine lets you repeat weak tasks instead of spending the session reconstructing lost data.
Do not use exam dumps, leaked questions, or memorisation claims as a substitute for skill. They do not establish that you can complete a legitimate project, and relying on them can leave obvious gaps in workbook navigation, data organisation, and verification. Practise with original scenarios and the published objectives instead.
A practical four-stage study roadmap
A staged plan works better than attempting every Excel feature at once. Move from orientation to controlled drills, then to integrated projects, and finally to verification. Adjust the length of each stage to your diagnostic results; the sequence is a practical recommendation, not an official exam timetable.
Stage one: map the objectives and prepare the environment. Obtain the official 77-420 objective document, identify the Excel version available to you, and create a skills register covering each named task. Complete the diagnostic workbook and mark tasks that require instruction, repetition, or speed work.
Stage two: build dependable operations. Work through workbook and worksheet management, navigation, cells and ranges, tables, and the listed formatting and organisation tasks. Use short exercises with immediate checks. Do not progress simply because an exercise feels familiar; repeat it with changed data, sheet names, and target ranges.
Stage three: integrate the skills. Create several original multi-sheet projects based on realistic purposes such as a budget, an invoice, a performance summary, or an exercise log. These examples reflect the types of scenarios Certiport uses to describe the Excel 2013 project, but they are not claims about the exact exam content. Include source data, calculations, structured data, visual output, and print or save preparation when relevant to the objectives.
Stage four: simulate and repair. Start with a written brief and a clean workbook. Work without step-by-step instructions, keep a record of decisions, and inspect the completed file against every requirement. Afterward, repair the weakest two or three skills deliberately. A second project using different data is more informative than repeating the same file from memory.
Before scheduling, use your register to confirm that you can perform every objective action without a guide. Also verify the current registration route, testing-centre or delivery information, identification requirements, and any provider instructions directly with the authorised source. These details can change and are not established by the supplied research.
How can you practise under project conditions?
Write tasks as outcomes, not menu instructions. “Prepare a printable monthly summary with filtered source data and a chart” is better practice than “click this button, then that button,” because it forces you to decide which worksheet, range, or object should change.
Use a repeatable project routine: read the brief, inspect the starting workbook, identify dependencies, perform the structural work, enter or transform data, apply calculations, format for the stated purpose, configure output, save, and verify. This order reduces rework because later presentation decisions depend on stable data and structure.
Add a verification pass that is separate from the build pass. Check sheet names and order, table boundaries, filters and sort state, formulas and results, conditional formatting, chart source and labels, print settings, headers and footers, and the final file format or location required by the exercise.
When you make an error, do not immediately restart. Identify whether the cause was a wrong selection, wrong command, wrong option, or misunderstood requirement. Correct it, then repeat the same skill on a new range. This develops recovery ability without pretending that real exam content can be predicted.
What should you verify before registration?
Confirm the exam’s current status and registration route before paying or arranging travel. The supplied official material identifies Certiport as the MOS 2013 pathway and lists a “Find a Testing Center” route, while a Microsoft Q&A discussion does not confirm Pearson VUE as an alternative. Use the current Certiport information for the actual appointment decision.
Check that the provider’s available software and exam identifier match 77-420: Excel 2013 Core. Ask the testing centre about the practical conditions that affect preparation, including whether the assessment is delivered in an authorised centre, what identification is required, and which candidate instructions apply. Do not rely on an old forum answer for current policy.
If your institution or employer requires a particular credential, ask whether it wants MOS Excel 2013 Core, an Expert certification, or a newer Excel examination. The 77-420 result may be relevant to a legacy requirement while being unsuitable for a current-version skills framework.
Record the official links you used, the date you checked them, and the questions still awaiting confirmation. This simple audit trail prevents an outdated search result or an unrelated exam code from driving your scheduling choice.
What should you do after completing the exam?
Use the result in line with the requirement that led you to 77-420. Certiport states that candidates who achieve MOS 2013 exam certification earn a digital badge for display in résumés, email, and social media profiles. Whether that badge is useful depends on the audience and on how current Excel expertise is expected to be.
Keep practising beyond the certificate. Rebuild a workbook from an unfamiliar brief, update formulas after a structural change, clean a table without damaging source data, and produce a readable chart and printable output. These activities turn the objective list into durable workplace habits.
If you intend to pursue an Expert credential or a newer Excel exam, confirm the current prerequisite or pathway with the relevant certification owner rather than assuming that a 77-420 pass automatically transfers. The supplied Microsoft Q&A discussion shows that candidates ask this question, but it does not provide an authoritative universal equivalency.
For a resit decision, return to evidence: review the skills register, identify tasks that failed or took excessive effort, and practise those tasks in new projects. Do not simply repeat the same memorised exercise or purchase more material without changing the underlying practice method.
Your next actions
Download and read the official 77-420 objective document, check the current Certiport information, and confirm whether Excel 2013 Core is the credential you actually need. Then complete a diagnostic multi-sheet workbook and turn its errors into a prioritised study register.
After the diagnostic, schedule study around the weakest objective areas rather than around a generic number of hours. Practise the named operations in Excel 2013, combine them in original projects, and finish each project with a verification pass. Only then revisit registration details and arrange an appointment through the currently authorised route.
This approach keeps the decision grounded in evidence: 77-420 is a project-based Excel 2013 assessment, its outline provides concrete workbook, cell, range, and table tasks, and current delivery or acceptance details must be checked directly before scheduling.
Conclusion
Exam 77-420 preparation should culminate in reliable workbook completion, not recognition of isolated commands. Use the official objectives as a checklist, practise in the relevant Excel environment, build and verify multi-sheet projects, and confirm current registration and credential requirements with Certiport or the organisation requesting the certification. That process gives you a defensible basis for deciding whether to schedule now, study specific gaps first, or pursue a different Excel credential.
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)