77-427
Excel 2013 Expert practice test
425 Microsoft MO-201 and 77-427 practice questions with explanations, in study, timed and flashcard modes.
Full access
$99
- All 425 questions across MO-201 and 77-427, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Total questions
- 425
- Free samples
- –
- Versions
- 2
- Updated
- Oct 2026
77-427 is retired as of Jun 30, 2024. It is replaced by MO-211. The question bank stays available for reference.
Exam simulator
Practice 77-427 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
77-427, by the numbers.
Official specifications published by Microsoft.
- Duration
- 50 min
- Questions
- 20-35 tasks
- Passing score
- 700 on a 1-1000 scale
- Exam fee
- $150
- In the bank
- MO-201 (270), 77-427 (155)

Exam guide
Everything about 77-427.
77-427 · Microsoft · v1.0
What is 77-427?
77-427 was part one of Microsoft's Excel 2013 Expert certification for advanced Excel users. It was retired in June 2024, and MO-211 is the Excel Expert exam that replaced it. Financial analysts, accountants and Excel power users took it. Conditional formatting changes how a cell looks based on its value, such as turning overdue dates red. You might build a PivotTable that totals sales by region and month. Its practice questions focus on date and statistical functions, PivotTables, conditional formatting and protecting shared workbooks.
What you'll practise
- Set workbook options, and protect and share workbooks and worksheets.
- Apply custom number formats, data validation and advanced conditional formatting.
- Prepare workbooks for other languages and for accessibility.
- Write formulas with logical, lookup, date and time, and statistical functions.
- Build advanced charts, such as charts with trendlines or two axes.
- Create and change PivotTables and Excel tables.
Requirements
- No formal prerequisites: anyone could book the exam while it was offered.
- Recommended: two to three years of Excel experience and an advanced grasp of its features.
- Recommended: the Excel 2013 Core certification (77-420) first.
Who it's for
- Financial and data analysts who build complex workbooks.
- Accountants, project managers and Excel power users.
- Office trainers and consultants who teach advanced Excel.
Exam details
Published by Microsoft, plus what is in our question bank.
What does 77-427 cover?
4 weighted domains. Open a domain for its topics, and a topic for its objectives. Practice questions are tagged to these.
How do I earn this certification?
Passing 77-427 earns the Microsoft Office Specialist: Excel 2013 Expert in the Microsoft Office Specialist (MOS) track.
How to study for this exam?
Use the 77-427 practice test alongside the official material below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- RETIRED→ MO-211
- Last content update
- Dec 31, 2023
- Announced
- Jan 15, 2024
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator