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

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

Topic 1: Creating and Managing Worksheets and Workbooks

• Creating, saving, and printing workbooks
• Managing worksheet visibility and protection
• Using templates and modifying workbook properties

Topic 2: Formatting Data and Worksheets

• Applying cell styles, themes, and conditional formatting
• Adjusting column width, row height, and text alignment
• Using find and replace, spell check, and AutoCorrect

Topic 3: Performing Calculations with Formulas and Functions

• Creating formulas using absolute and relative references
• Applying SUM, AVERAGE, IF, and LOOKUP functions
• Using nested functions for complex calculations

Topic 4: Analyzing Data with Charts and Tables

• Creating and modifying charts (bar, line, pie, etc.)
• Formatting chart elements and applying layouts
• Creating and filtering Excel tables

Topic 5: Managing Data with PivotTables and PivotCharts

• Creating PivotTables and customizing field settings
• Using slicers to filter PivotTable data
• Generating PivotCharts for data visualization