We're so confident of our products that we provide no hassle product exchange.
Microsoft 77-420 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Excel 2013 |
| Exam Number: | 77-420 |
| Exam Price: | Exam fees vary by location (MOS exams typically around USD 100–120) |
| Available Languages: | Other localized languages (varies by region), English |
| Exam Format: | Performance-based tasks in live Excel 2013 application |
| Related Certifications: | Microsoft Office Specialist: Excel Expert (77-427 & 77-428) |
| Certificate Validity Period: | MOS certifications do not expire, but relevance may diminish as software versions change |
| Exam Duration: | Not officially published (MOS performance-based exam is typically 50–90 minutes) |
| Passing Score: | Microsoft does not publicly disclose exact passing score |
| Real Exam Qty: | Approximately 30 performance-based tasks |
| Sample Questions: | Microsoft 77-420 Sample Questions |
| Exam Way: | Conducted through approved test centers or online proctoring where available |
| Pre Condition: | Familiarity with Excel functionality and basic spreadsheet skills |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/ |
How to Register For Exam 77-420: Microsoft Excel 2013?
Exam Register Link: https://www.certiport.com/locator
Reference: https://www.microsoft.com/en-us/learning/exam-77-420.aspx
There are Candidates must know the topics before they start of preparation.
Our Microsoft 77-420 -dumps will include the following topics:
- Apply formulas and functions
- Create tables
- Create and manage worksheets and workbooks
- Create cells and ranges
- Create charts and objects
Benefits of Passing Test 77-420
Nailing the Microsoft 77-420 exam will undoubtedly grant you a lot of additional perks, especially for your career. Overall, it is a highly sought-after certification by a lot of companies giving you all the leverage when it comes to negotiating your salary and other benefits that you might enjoy. Here are some of the advantages that you can expect after passing this exam and earning your certificate:
- It allows you to take on more advanced tests and become a specialist in Excel 2013 or even a specialist in Office 2013.
- You will have an advantage over most clerical workers as you have proof of your proficiency in using Excel for all tasks and jobs that require a fundamental understanding of the application;
- You’ll become qualified for most clerical jobs that require proficiency in Microsoft Excel as being certified as a competent Excel user shows that you can create and edit spreadsheets that feature professional-looking budgets, charts, data tabulation, exercise logs, sale invoices, and so on;
Conclusion
Becoming a certified passer of the Microsoft 77-420 demonstrates your knowledge and proficiency in the fundamental features found in all Excel applications. Having the related qualification tells your current and future employers that you can be relied upon in accomplishing the multiple tasks that require an Excel Spreadsheet, which allows you to charge up your career in clerical work, accounting and finance, and so on.
Microsoft 77-420 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Apply Formulas and Functions | - Format and modify text with functions - Utilize cell references in formulas - Use conditional logic in functions - Summarize data with functions |
| Topic 2: Create and Manage Worksheets and Workbooks | - Create workbooks and worksheets - Navigate worksheets and workbooks - Format worksheets and workbooks - Customize options and views - Configure print and save settings |
| Topic 3: Create Cells and Ranges | - Insert data in cells and ranges - Order and group cells and ranges - Format cells and ranges |
| Topic 4: Create Charts and Objects | - Insert and format objects - Create charts - Format charts |
| Topic 5: Create Tables | - Create a table - Modify tables - Filter and sort tables |
By Deirdre
