Why Study with PlanetCert?
The Latest Questions
Practice questions and exam topics aligned with the current exam objectives.
Detailed Explanations
Go beyond the answer. Master the material with comprehensive learning and professional explanations for every concept.
AI-Powered Insights
Personalized preparation guidance that adapts to your performance and identifies weak spots automatically.
Exam Information
Official specifications published by Microsoft
Exam Format
50 min
700
Core
Registration
$100 USD
Certiport Authorized Testing Centers
Validity
Lifetime (does not expire)
77-727 Exam Topics and Domains
77-727 is organized into 5 weighted domains.
1
Create and Manage Worksheets and Workbooks
30-35%
Create worksheets and workbooks
Create a workbookImport data from a delimited text fileAdd a worksheet to an existing workbookCopy and move a worksheet
- Demonstrate ability to create new Excel workbooks
- Import external data from delimited text files
- Manage multiple worksheets within a workbook
- Reorganize worksheet structure effectively
Navigate in worksheets and workbooks
Search for data within a workbookNavigate to a named cell, range, or workbook elementInsert and remove hyperlinks
- Efficiently locate data within complex workbooks
- Navigate using Excel's built-in navigation tools
- Implement hyperlinks for improved workbook usability
Format worksheets and workbooks
Change worksheet tab colorRename a worksheetChange worksheet orderModify page setupInsert and delete columns or rowsChange workbook themesAdjust row height and column widthInsert headers and footers
- Apply professional formatting to worksheets and workbooks
- Configure page setup for printing and presentation
- Optimize worksheet layout for readability and usability
Customize options and views for worksheets and workbooks
Hide or unhide rows and columnsHide or unhide worksheetsCustomize the Quick Access ToolbarChange workbook viewsChange window viewsModify document propertiesChange magnification by using zoom toolsDisplay formulas
- Customize Excel interface for improved productivity
- Control data visibility appropriately
- Optimize view settings for different tasks
Configure worksheets and workbooks for distribution
Set a print areaSave workbooks in alternative file formatsPrint all or part of a workbookSet print scalingDisplay repeating row and column titles on multipage worksheetsInspect a workbook for hidden properties or personal informationInspect a workbook for accessibility issuesInspect a workbook for compatibility issues
- Prepare workbooks for professional distribution
- Configure appropriate print settings
- Ensure workbook compatibility and accessibility
2
Manage Data Cells and Ranges
15-20%
Insert data in cells and ranges
Replace dataCut, copy, or paste dataPaste data by using special paste optionsFill cells by using Auto FillInsert and delete cells
- Efficiently input and modify cell data
- Use advanced paste techniques
- Leverage AutoFill for productivity
Format cells and ranges
Merge cellsModify cell alignment and indentationFormat cells by using Format PainterWrap text within cellsApply number formatsApply cell formatsApply cell styles
- Apply professional formatting to cells and ranges
- Use Excel's formatting tools efficiently
- Maintain consistent visual presentation
Summarize and organize data
Insert sparklinesOutline dataInsert subtotalsApply conditional formatting
- Apply visual analysis tools to data
- Organize data hierarchically
- Use conditional formatting for insights
3
Create Tables
15-20%
Create and manage tables
Create an Excel table from a cell rangeConvert a table to a cell rangeAdd or remove table rows and columns
- Create and manage Excel tables
- Understand table vs range differences
- Modify table structure dynamically
Manage table styles and options
Apply styles to tablesConfigure table style optionsInsert total rows
- Apply professional styling to tables
- Configure table display options
- Use table total rows effectively
Filter and sort tables
Filter recordsSort data on multiple columnsChange sort orderRemove duplicate records
- Filter table data effectively
- Perform complex multi-level sorts
- Clean data by removing duplicates
4
Perform Operations with Formulas and Functions
10-15%
Summarize data by using functions
Insert referencesPerform calculations by using the SUM functionPerform calculations by using MIN and MAX functionsPerform calculations by using the COUNT functionPerform calculations by using the AVERAGE function
- Use basic statistical functions
- Understand cell reference types
- Perform common calculations efficiently
Perform conditional operations by using functions
Perform logical operations by using the IF functionPerform logical operations by using the SUMIF functionPerform logical operations by using the AVERAGEIF functionPerform statistical operations by using the COUNTIF function
- Implement conditional logic in formulas
- Use criteria-based functions
- Perform selective calculations
Format and modify text by using functions
Format text by using RIGHT, LEFT, and MID functionsFormat text by using UPPER, LOWER, and PROPER functionsFormat text by using the CONCATENATE function
- Manipulate text using functions
- Extract and combine text data
- Standardize text formatting
5
Create Charts and Objects
15-20%
Create charts
Create a new chartAdd additional data series to chartsSwitch between rows and columns in source dataAnalyze data by using Quick Analysis
- Create appropriate chart types for data
- Modify chart data sources
- Use Quick Analysis for rapid insights
Format charts
Resize chartsAdd and modify chart elementsApply chart layouts and stylesMove charts to a chart sheet
- Format charts professionally
- Customize chart elements for clarity
- Optimize chart placement and presentation
Insert and format objects
Insert text boxes and shapesInsert imagesModify object propertiesAdd alternative text to objects for accessibility
- Insert and manage graphical objects
- Format objects professionally
- Ensure accessibility compliance
How do I earn this certification?
Passing 77-727 earns the Microsoft Office Specialist: Excel (Office 2016) certification. It sits in the Microsoft Office Specialist track.
Current Level Exams
- 77-725 - Word 2016
- 77-729 - PowerPoint 2016
- 77-730 - Access 2016
- 77-731 - Outlook 2016
Next Level Options
- 77-728 - Excel 2016 Expert Advanced Excel skills including complex formulas, data analysis, and macros
- Microsoft Office Specialist Master 2016 Highest level of Office 2016 certification
Alternative Paths
- MO-200 - Microsoft Excel (Office 365 and Office 2019) Modern version of Excel certification
- MO-201 - Microsoft Excel Expert (Office 365 and Office 2019)Expert-level modern Excel certification
Practice with Precision
The PlanetCert Simulator mirrors the real exam environment with authentic questions and timed pressure.
How to study for this exam?
Use the official PlanetCert Practice Test alongside the study plan below to prepare efficiently for 77-727.
What's changed on this exam?
Current Status
- ACTIVE
- Last content update: 2016-06-24
Updates
Excel 2016 16.0 Exam specifically tests Excel 2016 features and interface • Release date: 2015-09-22
Who should take this exam?
This exam is typically taken by Students seeking to validate Excel skills and Office workers needing Excel proficiency certification.
- Fundamental understanding of Excel environment
- Ability to complete tasks independently
- Experience with Excel 2016 interface and features
- Basic understanding of spreadsheet concepts