The Microsoft 77-420 exam is part of the Microsoft Office Specialist (MOS) certification program, which validates a candidate's proficiency in using Microsoft Excel 2013. It covers various tasks and features within Excel to ensure the candidate can effectively use the software in a professional setting.

The Microsoft 77-420 exam, also known as Excel 2013, is designed to measure a candidate's ability to create and manage worksheets and workbooks, create cells and ranges, create tables, apply formulas and functions, and create charts and objects.

The number of questions on the Microsoft 77-420 exam can vary, but typically there are around 40-60 questions.

The passing score for the Microsoft 77-420 exam is 700 out of 1000.

The competency level required for the Microsoft 77-420 exam is intermediate to advanced proficiency in Microsoft Excel 2013.

The question format of the Microsoft 77-420 exam includes multiple-choice questions, drag and drop, and performance-based tasks that simulate real-world Excel tasks.

You can take the Microsoft 77-420 exam at authorized testing centers or online through a proctored exam service.

The Microsoft 77-420 exam is offered in multiple languages, including English, Spanish, Chinese, and more.

The cost of the Microsoft 77-420 exam varies by region but generally ranges from $100 to $150.

The target audience for the Microsoft 77-420 exam includes students, office professionals, and anyone who uses Microsoft Excel 2013 in their daily tasks and wants to validate their skills.

The average salary of a Microsoft 77-420 certified professional varies by location and experience but generally ranges from $40,000 to $60,000 annually.

The testing providers for the Microsoft 77-420 exam include Certiport and Pearson VUE.

The recommended experience for the Microsoft 77-420 exam includes hands-on experience with Microsoft Excel 2013 and familiarity with its features and functions.

There are no formal prerequisites for the Microsoft 77-420 exam, but it is recommended that candidates have a good understanding of Microsoft Excel 2013.

The expected retirement date for the Microsoft 77-420 exam has passed, as it was retired on June 30, 2021.

The Microsoft 77-420 exam is part of the Microsoft Office Specialist (MOS) certification track, which includes other exams for different Microsoft Office applications.

The topics covered in the Microsoft 77-420 exam include creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects.

Sample questions for the Microsoft 77-420 exam can be found on the official Microsoft certification website or through various online study resources and practice tests.

The difficulty level of the Microsoft 77-420 exam is considered intermediate to advanced, requiring a solid understanding of Microsoft Excel 2013 and its features.