Description

Exam Code: 77-427
Related Certification(s): Microsoft Office Specialist (MOS) Excel Expert
Certification Provider: Microsoft
Actual Exam Duration: 90 Minutes
Number of 77-427 practice questions in our database: 12

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

Topic 1: Managing and Sharing Workbooks

• Managing workbook versions and properties
• Configuring workbook security and permissions
• Merging and comparing multiple workbooks

Topic 2: Applying Custom Formatting and Layouts

• Creating and managing conditional formatting rules
• Implementing custom number formats
• Designing professional reports with themes and styles

Topic 3: Creating Advanced Formulas and Functions

• Using lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
• Implementing logical and nested IF functions
• Applying advanced text functions

Topic 4: Working with Advanced Charting and Data Visualizations

• Creating dynamic charts using data ranges
• Using Power View to create interactive reports
• Enhancing data representation with sparklines

Topic 5: Managing Advanced Data Operations

• Importing and transforming data using Power Query
• Utilizing data validation techniques
• Creating and managing PivotTables and PivotCharts