Description

Exam Name: Microsoft Office Specialist – Excel 2016 Core
Exam Code: 77-725
Related Certification(s): Microsoft Office Specialist (MOS): Excel 2016 Core
Certification Provider: Microsoft
Actual Exam Duration: 90 Minutes
Number of 77-725 practice questions in our database: 35

Expected 77-725 Exam Topics, as suggested by Microsoft:

Topic 1: Creating and Managing Worksheets and Workbooks

• Creating a new workbook and importing data
• Navigating through workbooks and worksheets efficiently
• Formatting worksheets and managing multiple sheet views
• Customizing Excel environment options
• Configuring print settings and saving workbooks in different formats

Topic 2: Managing Cells and Ranges

• Formatting cells using number, text, and custom styles
• Using Find & Replace, sorting, and filtering data
• Applying conditional formatting for dynamic data visualization
• Using Named Ranges for efficient referencing

Topic 3: Creating Tables in Excel

• Formatting data as a table and applying Table Styles
• Sorting and filtering data within tables
• Using structured references for calculations in tables
• Converting tables back into ranges for advanced modifications

Topic 4: Performing Operations with Formulas and Functions

• Using logical functions like IF, AND, OR
• Applying lookup functions such as VLOOKUP and HLOOKUP
• Using text functions (LEFT, RIGHT, MID, CONCATENATE)
• Performing statistical and mathematical calculations (SUMIF, AVERAGEIF)
• Troubleshooting errors using IFERROR and auditing tools

Topic 5: Creating Charts and Objects

• Inserting and modifying charts, including line, bar, and pie charts
• Customizing chart elements such as titles, legends, and data labels
• Using Sparklines for trend visualization
• Inserting and formatting objects such as shapes, SmartArt, and pictures

Topic 6: Managing Data and Advanced Features

• Removing duplicates and consolidating data
• Using data validation rules for controlled data entry
• Creating drop-down lists and enforcing input constraints
• Using Flash Fill and AutoFill for data entry automation

Topic 7: Working with PivotTables and PivotCharts

• Creating PivotTables for data analysis
• Summarizing data using PivotTables and calculated fields
• Filtering and sorting data within PivotTables
• Creating PivotCharts to visualize PivotTable data

Topic 8: Sharing and Protecting Workbooks

• Managing workbook permissions and protecting sheets
• Tracking changes and using comments for collaboration
• Inspecting workbooks for accessibility and compatibility
• Finalizing documents for secure sharing