1. Home
  2. Microsoft
  3. 77-427 Exam Syllabus

Microsoft 77-427 Exam Syllabus

Microsoft 77-427 Exam

Excel 2013 Expert Part One

Total Questions: 62

What is Included in the Microsoft 77-427 Exam?

Authentic information about the syllabus and an effective study guide is essential to go through the Microsoft 77-427 exam in the first attempt. The study guide of Study4Exam provides you with comprehensive information about the syllabus of the Microsoft 77-427 exam. You should get this information at the start of your preparation because it helps you make an effective study plan. We have designed this Microsoft Office Specialist certification exam preparation guide to give the exam overview, practice questions, practice test, prerequisites, and information about exam topics that help to go through the Microsoft Excel 2013 Expert Part One (2022) exam. We recommend you to the preparation material mentioned in this study guide to cover the entire Microsoft 77-427 syllabus. Study4Exam offers 3 formats of Microsoft 77-427 exam preparation material. Each format provides new practice questions in PDF format, web-based and desktop practice exams to get passing marks in the first attempt.

Microsoft 77-427 Exam Overview :

Exam Name Excel 2013 Expert Part One
Exam Code 77-427
Actual Exam Duration 90 minutes
Expected no. of Questions in Actual Exam 60
Official Information https://www.microsoft.com/en-us/learning/exam-77-427.aspx
See Expected Questions Microsoft 77-427 Expected Questions in Actual Exam
Take Self-Assessment Use Microsoft 77-427 Practice Test to Assess your preparation - Save Time and Reduce Chances of Failure

Microsoft 77-427 Exam Topics :

Section Weight Objectives
Manage and share workbooks Manage workbook changes
  • track changes, manage comments, identify errors, troubleshoot with tracing, display all changes, retain all changes
Apply custom formats and layouts Apply advanced conditional formatting and filtering
  • write custom conditional formats, use functions to format cells, create advanced filters, manage conditional formatting rules Prepare a workbook for internationalization and accessibility
  • modify tab order among workbook elements and objects, display data in multiple international formats, modify worksheets for use with accessibility tools, utilize international symbols, manage multiple options for +Body and +Heading fonts

 
Create advanced formulas Look up data with functions
  • utilize the LOOKUP function, utilize the VLOOKUP function, utilize the HLOOKUP function, utilize the TRANSPOSE function Apply advanced date and time functions
  • utilize the NOW and TODAY functions, use functions to serialize dates and times
Create advanced charts and tables Create advanced chart elements
  • add trendlines to charts, create dual axis charts, create custom chart templates, view chart animations
Create and manage PivotTables
  • create new PivotTables, modify field selections and options, create a slicer, group records, utilize calculated fields, format data, utilize PowerPivot, manage relationships

Updates in the Microsoft 77-427 Exam Syllabus:

Microsoft 77-427 exam questions and practice test are the best ways to get fully prepared. Study4exam's trusted preparation material consists of both practice questions and practice test. To pass the actual Microsoft Office Specialist 77-427 exam on the first attempt, you need to put in hard work on these Microsoft 77-427 questions that provide updated information about the entire exam syllabus. Besides studying actual questions, you should take the Microsoft 77-427 practice test for self-assessment and actual exam simulation. Revise actual exam questions and remove your mistakes with the Excel 2013 Expert Part One 77-427 exam practice test. Online and windows-based formats of the 77-427 exam practice test are available for self-assessment.