77-727
Excel 2016: Core Data Analysis, Manipulation, and Presentation practice test
155 Microsoft 77-727 practice questions with explanations, in study, timed and flashcard modes.
Full access
$99
- All 155 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Questions
- 155
- Free samples
- –
- Versions
- 1
- Updated
- Aug 2026
Exam simulator
Practice 77-727 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
77-727, by the numbers.
Official specifications published by Microsoft.
- Duration
- 50 min
- Questions
- Performance-based tasks (approximately 7 projects with 5-6 tasks each)
- Passing score
- 700 on a 1-1000 scale
- Exam fee
- $100

Exam guide
Everything about 77-727.
77-727 · Microsoft · Office 2016
What is 77-727?
The 77-727 exam checked core Excel 2016 skills for the Microsoft Office Specialist (MOS) certification. It was retired on June 30, 2026, when the whole MOS 2016 series ended. Newer MOS Excel exams now cover Microsoft 365 Apps. Students, job seekers and office staff took it to prove their spreadsheet skills. A cell range is a block of cells, such as A1:C10, that a formula or a format acts on. For example, you may turn a list into an Excel table, then sort and filter it. This practice test covers worksheets and workbooks, cells and ranges, tables, formulas and charts.
What you'll practise
- Create, navigate and format worksheets and workbooks, and set them up for printing.
- Insert, format and summarize data in cells and ranges.
- Create Excel tables, apply table styles, and sort and filter the data.
- Summarize data and run conditional calculations with functions such as SUM, IF and COUNTIF.
- Create and format charts, and insert objects such as pictures and text boxes.
Requirements
- No formal prerequisites: anyone could book the exam while it was offered.
- Recommended: a basic understanding of Excel and of spreadsheet concepts.
- Recommended: plenty of hands-on practice with Excel 2016.
Who it's for
- Students who wanted to prove their Excel skills to schools or employers.
- Office workers, administrative staff and data entry specialists.
- Learners reviewing Excel basics before a current MOS exam.
Exam details
Published by Microsoft, plus what is in our question bank.
What does 77-727 cover?
5 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-727 earns the Microsoft Office Specialist: Excel (Office 2016) in the Microsoft Office Specialist track.
How to study for this exam?
Use the 77-727 practice test alongside the official material and the study plan below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
- Last content update
- Jun 24, 2016
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