Main Exam Specifications and Topics Covered

Microsoft Office Excel 2013 is a platform that allows users to organize, manage, analyse, and share information conveniently. These tasks are put into life through fundamental Excel features namely cells, columns, rows, worksheets, worktables, charts, and objects, among others. To better grasp the ins and outs of this program and its specifics, candidates should master the objectives of Microsoft 77-420 discussed below. Do take note that there's no specific percentage for each main domain.

• Cells and Ranges

  After mastering workbooks and worksheets, it's time to pick up cells and ranges. Cells, in particular, are the rectangular boxes where you input data. Some of the cell functions one has to know to include replacing data, copying and pasting information, expanding data in a column, and taking advantage of the AutoFill tool.

  Subsequently, candidates should learn more about how to format cells. This topic focuses on merging cells, changing fonts, altering alignment, applying number format, and adding styles. These functionalities are basic ones. To further expand the skill set, one has to dig deeper into some advanced aspects such as conditional formatting, transposing rows and columns, integrating sparklines, and making named ranges.

• Workbooks and Worksheets

  Starting with Microsoft Office Excel 2013 can be challenging but definitely manageable with proper navigation and continuous practice. Applicants should commence by familiarizing with the primary user interface. This also includes the use of templates, creating a blank workbook or a spreadsheet file, importing files, moving and copying worksheets, and the ability to open non-native files appropriately.

  There are a lot of things that one needs to learn further, such as how to navigate through the worksheets and workbooks, search for data, modify the order of worksheets, insert hyperlinks, maximize Name Box features, and use Go to. And when formatting worksheets and workbooks, some of the factors to take into account are tab color, page setup, themes, size, watermarks, headers, and footers. This section also helps candidates in customizing views and related options such as hiding columns and rows, freezing panes, splitting the window, and the like. To cap off this domain, applicants must study how to configure both worksheets and workbooks when printing or saving a file.

• Tables

  Excel tables act as the vessel of various data to help organize information in the spreadsheets. Inside these tables, there are different yet interrelated data. When creating a table, one needs to consider various factors, particularly moving from one table to another, modifying cells in a table, defining titles, incorporating styles, and banding columns and rows. Candidates should also make sure to polish their abilities in filtering records, sorting data, altering sort order, and even eliminating duplicates.

• Objects and Charts

  Now, we're down to the last section that is about creating charts and formatting objects. Making a chart can be done conveniently if one has learnt the ropes of creating graphs, switching rows and columns, handling Quick Analysis, adding legends, changing layouts, and changing parameters. In addition, candidates should be able to competently insert and modify an object by inserting text boxes, images, borders, styles, and colors.

• Functions and Formulas

  Applying key formulas as well as functions in cell ranges is highly relevant. Therefore, applicants has to know more about choosing the order of operations, along with the use of references, especially absolute, relative, and mixed. When summarizing data using functions, the things that candidates need to master are SUM, COUNT, AVERAGE, MIN, and MAX. Likewise, having the ability to utilize conditional logic ( including SUMIF, AVERAGEIF, and COUNTIF functions) is also imperative. And to easily alter text, one should get to grips with the following ― RIGHT, LEFT, MID, UPPER, LOWER, TRIM, and CONCATENATE functions.

Reference: https://www.microsoft.com/en-us/learning/exam-77-420.aspx

Next Certification to Pursue After Acing the Microsoft 77-420 Exam

Once you're done with 77-420, it's time to consider taking other tests related to the expert-level Microsoft Office Specialist 2013 Master. Another great way to polish these skills is through the Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification (MO-200 test should be passed) or the Microsoft Office Specialist: Excel 2013 Expert certificate (exams 77-427 and 77-428 are required). Otherwise, one can expand the knowledge base and sit for related tests from the Microsoft Office Specialist Program. Some of the options are Microsoft Word 2013 (exam 77-418), Microsoft PowerPoint 2013 (exam 77-422), and Microsoft Outlook 2013 (exam 77-423), and such.

Many young IT working people have their life attitude of upward and extraordinary, (77-420 brain dumps) they regard IT certification Microsoft Microsoft Office Specialist (MOS) as an important & outstanding advantage while they have better opportunities. However Microsoft 77-420 exam become an obstacle to going through the IT exams. They are urgent to gain a valid Excel 2013 brain dumps or Excel 2013 dumps pdf so that they can go through a pass and then do something interesting. Although there is so much information about Excel 2013 brain dumps or Excel 2013 dumps pdf, they find it difficult to find the valid and reliable website about IT real test. Now it is your good chance. Our Braindumpsit is the leading provider which offers you the best, valid and accurate Excel 2013 brain dumps & Excel 2013 dumps pdf. We can help you pass exam surely.

In the past several years our Excel 2013 brain dumps totally assisted more than 100000+ candidates to sail through the examinations, our passing rate of Excel 2013 dumps pdf is high up to 98.54%. Most of candidates would purchase IT exam cram from us second times. Customers think highly of our 77-420 brain dumps. We aim to make sure all our brain dumps pdf are high-quality because we have more than ten years' experienced education staff and professional IT staff. That's why our Excel 2013 brain dumps can have good reputation in this area. Besides, we not only offer valid & high-quality IT exam cram but also our service is also praise by most candidates.

Firstly, many candidates who purchased our 77-420 brain dumps said that we replied news and email fast. Yes, we have professional service staff working as a 24-7 on-line service. We request any on-line news or emails about 77-420 brain dumps or Excel 2013 dumps pdf should be replied and handled successfully in two hours. Be polite, patience and hospitable are the basic professional quality of our customer service staff.

Secondly, we guarantee you 100% pass the IT certification Excel 2013 exam for sure if you purchase our 77-420 brain dumps or Excel 2013 dumps pdf. Most candidates can pass exam once, but if you fail the exam we will serve for you until you pass. We have one-year service warranty; we will send you the update version of Excel 2013 brain dumps all the time within one year. If you fail the exam and give up, you want a refund we will refund the full money you paid us about Excel 2013 dumps pdf. We guarantee your money and information safety. No Pass No Pay! Please rest assured!

Thirdly, we have three versions of 77-420 brain dumps. Many candidates are not sure how to choose it. The great majority of customers choose the APP on-line test engine version of Excel 2013 brain dumps because it is multifunctional and stable in use. Also some customers are purchasing for their companies they will choose all the three versions of Excel 2013 brain dumps so that they can satisfy all people's characters.

Fourthly, as for the payment of 77-420 brain dumps or Excel 2013 dumps pdf, normally we just only support Credit Card with a credit card. The debit card is only available for only a very few countries. Credit Card is widely used in international trade business and is safe and stable for both buyer and seller. Also if you fail exam with our Excel 2013 brain dumps and apply for refund, it is also convenient for you.

All in all, our Excel 2013 brain dumps & Excel 2013 dumps pdf will certainly assist you go through exam and gain success of IT certification Microsoft Microsoft Office Specialist (MOS). If you give us trust we will give you a pass. Braindumpsit 77-420 brain dumps will be your lucky choice.

Exam Topics

The most important part of the Microsoft 77-420 exam is its topics, and you need to master them if you want to succeed in this certification test. These domains are as follows:

• Creating Cells & Ranges

  To find solutions to the problems covered in this domain, it is important to have the skills in inserting data in ranges and cells as well as formatting and grouping them. The individuals should be able to append data to worksheets, insert and delete cells, expand data across the given columns, use an AutoFill tool, copy and paste data, and merge cells. The skills that you need to possess include the application of highlighting, conditional formatting, and Number format, wrapping of the text within cells, usage of Format Painter, and creation of outline. It is also essential to be able to insert spark lines, change text to WordArt, apply call styles, and transpose rows and columns.

• Creating Objects & Charts

  Under this last subject area, there are specific skills that will be measured. They cover the ways of creating a chart and formatting it as well as inserting and formatting an object. The potential candidates will be evaluated on their ability to create graphs and charts, add additional data series, use Quick Analysis, add legends, and position graphs and charts. If you know how to apply chart styles and layouts, modify graph and chart parameters, resize graphs and charts, and insert text boxes, you will be able to answer the questions from this section correctly. Moreover, you should now about the insertion of SmartArt, change of object colors, positioning of objects, modification of the object properties, addition of effects and styles to objects and borders to objects, as well as insertion of images.

• Creating Tables

  The third section evaluates the students’ ability to create, modify, sort, and filter tables, as well as move between ranges and tables. The learners should have the skills in defining titles, removing and adding cells within tables, removing styles from tables, and inserting total rows. You should also have knowledge of how to band columns and rows, apply styles to tables, filter records, remove duplicates, change the sort order, and sort data on multiple columns.

• Applying Formulas & Functions

  This is the fourth topic of the exam that includes a number of specific skills that will be tested. They include the utilization of cell references and ranges in functions and formulas, summarization of data with functions, and utilization of conditional logic in functions. The individuals should able to format and modify text with functions as well as utilize references (absolute, mixed, relative) and COUNTIF, MAX, SUMIF, AVERAGE, and MIN functions. The functions also contain LEFT, MID, and RIGHT, CONCATENATE, LOWER and UPPER, and TRIM. Additionally, the applicants should be able to define the order of operations and reference cell ranges in formulas.

• Creating & Managing Workbooks & Worksheets

  The first topic of the Microsoft 77-420 exam includes the subsections that cover the details of the creation of workbooks and worksheets, their formatting, and navigation through workbooks and worksheets. You should also know how to customize the views and options and configure worksheets and workbooks to save or print. To answer the questions related to this area, the potential candidates should be able to set a print area, set print scaling, print individual worksheets, save workbooks in the alternative file formats, maintain backward compatibility, hide worksheets, use zoom, split the window, assign shortcut keys, display formulas, add values to the workbook properties, record simple macros, change workbook views, and so on.

Microsoft 77-420 Exam Syllabus Topics: