About Microsoft 77-420 Exam
The Microsoft 77-420: Microsoft Excel 2013 exam is a core-level test that validates the specialists’ fundamental knowledge of the Excel environment. It also proves their skills and competence in completing tasks utilizing Excel. The professionals are required to show the correct usage of its principal features. The exam does not have any official prerequisites, but the applicants need to have the expertise in creating and editing a workbook with multiple sheets for a variety of situations and purposes. The intended audience for the test is clerical workers, instructors, bookkeepers, and students, among others. Microsoft 77-420 is a qualifying exam for the Microsoft Office Specialist 2013 Master and the Microsoft Office Specialist: Excel 2013 certificates.
The Microsoft 77-420 certification test can be taken as a proctored exam or in person at any of the Pearson VUE testing centers across the world. To register for the exam, the applicants must pay the fee of $100. This test comes with a range of questions in various formats. The exam is available in the English, Japanese, Korean, Chinese (Traditional as well as Simplified), Spanish, Portuguese (Brazil), Greek, Italian, German, French, Norwegian, Dutch, Polish, Russian, Arabic (Saudi Arabia), and Vietnamese languages. Microsoft does not provide any official training resources specified for this test. However, the specialists can find some helpful tools on the Internet. Be sure to use them to gain the necessary skills for successful exam passing.
The Microsoft 77-420 test includes various subject areas. It is recommended that the examinees get acquainted with them as early as possible. The highlights of the domains covered in the test include:
Creating and Managing Worksheets and Workbooks: The first part requires that the test takers demonstrate their skills in developing new blank workbooks, developing workbooks with templates, directly opening the non-native files in Excel, and importing files. It also covers their abilities to add more worksheets to already existing workbooks as well as move and copy worksheets. Moreover, this section measures the competence of the applicants in searching for data in a workbook, altering the worksheet order, utilizing Name Box, inserting hyperlinks, and using Go To. Furthermore, the professionals should be able to show their expertise in altering the tab color of the worksheet, altering page setups, altering workbook themes, deleting and inserting rows and columns, adjusting column width and row height, setting data validation, inserting footers, and headers, and inserting watermarks. In addition, the applicants need to have abilities to hide worksheets, hide rows and columns, manage macro security, customize Quick Access toolbar, alter workbook view, and change workbook views. This area also focuses on the capability of the examinees to record simple macros, use zoom, add values to the workbook properties, display formulas, assign shortcut keys, freeze panes, and split windows. It is also important to have the competence in saving workbooks in other file formats, setting print areas, printing individual worksheets, repeating footers, and headers, and setting print scaling. It also measures one’s ability to maintain backward compatibility, save files to other remote locations, and configure workbooks for print.
Creating Ranges and Cells: The next subject area checks the skills of the examinees in appending data to worksheets, using the AutoFill tool, inserting and deleting cells, and expanding data across various columns. It also focuses on the ability of the test takers to mere cells, change font & font styles, modify cell indentation and alignment, use Format Painter, and apply Number format. Moreover, it measures their proficiency in wrapping text in cells, changing text to WordArt, and applying cell styles. In addition, this section covers the expertise required to apply conditional formatting, transpose rows and columns, insert sparklines, create an outline, create name ranges, insert subtotals, and collapse a group of data within outlines.
Creating Tables: This domain assesses the competence of the applicants in moving between ranges and tables, defining titles, and adding and removing cells in tables. It also covers the skills required to apply styles to tables, insert total rows, band columns, and rows, and remove styles from the tables. In addition, the individuals should demonstrate their ability to sort data on various columns, filter records, remove duplicates, and change sort order.
Applying Functions and Formulas: This topic covers the capability of the individuals to use references, including absolute, mixed, and relative ones. It also focuses on the abilities to reference cell ranges within formulas and define the order of operations. Moreover, it requires your proficiency in using the SUM and COUNT functions as well as utilizing the MAX & MIN functions and the AVERAGE function. Furthermore, the applicants have to show their expertise in using the SUMIF function, COUNTIF function, and AVERAGEIF function. In addition, it requires that the examinees have the competence in using the LEFT, MID, and RIGHT functions, LOWER & UPPER functions as well as using the TRIM and CONCATENATE functions.
Creating Objects & Charts: The last module measures the ability of the examinees to create graphs and charts, add extra data series, and use Quick Analysis. They should also be able to add legends, modify graph and chart parameters, resize graphs and charts, position graphs and charts, and apply chart styles and layouts. In addition, the learners need to demonstrate their skills in inserting text boxes, adding borders to objects, inserting SmartArt, changing object colors, positioning objects, adding effects and styles to objects, and modifying object properties.
The candidates who pass the Microsoft 77-420 exam will earn the Microsoft Office Specialist: Excel 2013 certificate. It validates that the professionals have the competence in applying the major features of Excel 2013. Some of the job roles that these individuals can explore with this certification include an Office Manager, an Executive Assistant, an Administrative Assistant, an Operations Analyst, a Data Analyst, a Staff Accountant, and a Business Analyst, among others. The average salary outlook for these positions is $53,000 per annum.