Following is the Microsoft 77-420 Exam Format

• Length of Examination: 45 minutes
• Language: English, Arabic, Simplified Chinese, Traditional Chinese, German, Greek, Spanish, French, Italian, Japanese, Korean, Norwegian, Dutch, Polish, Portuguese Brazillian, Russian, Vietnamese
• Passing score: 700/1000
• Number of Questions: 40-60
• Format: Multiple choices, multiple answers

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

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.

• 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.

• 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.

• 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.

• 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.

Don't lose your heart even if you fail 77-420 exam five times, success is coming. Under the circumstances, choice is more important than effort. Valid study method or a shortcut will be your way out of this situation. Valid 77-420:Excel 2013 exam torrent will be the right choice for you. You need a successful exam score to gain back your faith. An excellent pass will chase your gloomy mood away. Our 77-420 exam questions and answers will help you go through the exam which may be the key to your Microsoft Office Specialist (MOS) certification. We provide you not only the high passing-rate 77-420:Excel 2013 exam torrent materials but also satisfying customer service.

Our Exam Torrent is Easy-to-read Layout and Humanization design

To satisfy different kinds of users' study habits we publish three versions for each exam subject materials. Our 77-420:Excel 2013 exam torrent materials are easy-to-read and simple-to-operate. You can choose absolutely clear PDF version which is printable easily. Also our soft test engine and app test engine can have extra functions which 77-420 exam questions answers not only provide you valid questions answers but also simulate the real test scene and set timed practicing. These software or APP version makes candidates master test rhythm better. It is really humanized.

Microsoft 77-420 Exam Introduction

The Microsoft Office Specialist certification is for specialists who can design and manage worksheets and workbooks with Microsoft Office Excel 2013 and who have experience with previous versions of Microsoft Office Excel. They must also be able to perform tasks such as creating tables, applying formulas and functions, creating graphs and objects. Microsoft Exam 77-420 is an update to Microsoft Office Excel 2010.

Career Opportunities

The successful completion of the Microsoft 77-420 exam will lead you to the Microsoft Office Specialist (MOS) certification. Having it on your CV is validation that you have gained the expertise necessary to completely use Microsoft applications at the ‘power user’ level. The test helps the candidates validate how knowledgeable and skilled they are in designing professional-looking budgets, exercise logs, sales invoices, team performance charts, and so on.

Regularly Updated with New Questions of Microsoft company

We have one-hand information resource, we always know exam change details in the first time so that our 77-420:Excel 2013 exam questions and answers will update with the real questions change accurately. Candidates shouldn't worry our products will be old. If our products are old, we can say no 77-420 exam torrent on sale is new. We pay high attention on products quality. We are engaged in improving the passing rate of our products every day. We request our experts to regularly update 77-420:Excel 2013 exam dumps time to time.

Latest Exam Torrent is edited based on Real 77-420 Exam

All 77-420:Excel 2013 exam torrent materials are collected and edited based on past real questions and latest real questions materials. Products not only can make you know the key knowledge and lay a solid foundation but also are valid to help you pass exam for sure. Also we require all education experts have more than 8 years' experience in IT field and more than 3 years' experience in Microsoft exam materials field.

24 Hour Professional Customer Service Support Available

Our 77-420:Excel 2013 exam torrent materials are applicable in all exam all over the world. Our buyers are from everywhere of the world. Because of time difference we provide 24 hour professional customer service support all the year round even on large official holiday. Once you purchase our 77-420 exam questions answers you can receive products in a minute. It is automatically sent via email, you don't worry that it will need too much time. Every contact or email about 77-420:Excel 2013 dumps torrent will be replied in two hours. We request service staff "be nice, be patient, be careful, be responsible" to every candidate. We sincerely hope everyone have a nice shopping experience in our website.

With so many years' development our high-quality 77-420:Excel 2013 exam torrent and satisfying customer service gain excellent fame from all buyers so that we are now the leading position in this field. If you decide to purchase 77-420 exam questions answers, don't hesitate to choose us. You will be happy for your choice.

After purchase, Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)