ExamDumpster

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
Try the free samples first
Microsoft logo
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
Open the full exam guide

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.

Duration
50 min
Questions
Performance-based tasks (approximately 7 projects with 5-6 tasks each)
Passing score
700 on a 1-1000 scale
Level
Core
Question types
Task-based performance simulations, Project-based assessments

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-727 questions, answered