ExamDumpster

77-427

Excel 2013 Expert practice test

425 Microsoft MO-201 and 77-427 practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.

Full access

$99

  • All 425 questions across MO-201 and 77-427, with explanations
  • Study, timed and flashcard modes
  • Progress saved, resume any time
Try the free samples first
Microsoft logo
Total questions
425
Free samples
20
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)
Open the full exam guide

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.

Duration
50 min
Questions
20-35 tasks
Passing score
700 on a 1-1000 scale
Level
Expert

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 simulator

Timed mode

A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.

Open in the simulator

Flashcards

Question on the front, answer on the back. Good for the last week before the exam.

Open in the simulator

77-427 questions, answered