What skills are measured in the Microsoft 77-727 exam?

The Microsoft 77-727 exam covers several topics that are described in detail below:

• Creating Tables (15-20%)

  In the third section of the Microsoft 77-727 exam, the learners will cover creating and managing tables. Under it, the test takers should develop competency in matters, such as using cell range to create an Excel table; conversing tables to cell range; removing rows & columns in a table. Managing options & table styles is another subsection covered within the topic. This captures applying & configuring styles in tables and inserting total rows. Lastly, the candidates should understand filtering & sorting a table. The skills covered within this subtopic include filtering records; sorting data using multiple columns; changing sorting order; removing duplicate records.

• Managing Data Ranges & Data Cells (15-20%)

  The second topic explores inserting data in ranges and cells. These include replacing data; cutting, copying, or pasting data; using options for special pasting to paste data; using AutoFill to fill cells; inserting and deleting cells. The second area to be addressed within this module is formatting ranges & cells. This is about issues, such as merging cells; modifying cell alignment; using Format Painter to format cells; wrapping texts in cells; applying number formats; applying cell formats; applying cell styles. And lastly, the subtopic titled summarizing and organizing data is covered. This entails inserting Sparkline; outlining data; inserting subtotals; applying conditional formatting.

• Creating and Managing Worksheets & Workbooks (30-35%)

  The first domain addresses creating worksheets along with workbooks. This captures creating a workbook; importing data from a text file that is delimited; adding worksheets to the existing workbook; copying as well as moving a worksheet. It also explores navigating worksheets & workbooks. This deals with searching for data in a workbook; navigating named range, workbook, or cell element; inserting and removing hyperlinks. The third aspect covered within this section is formatting worksheets & workbooks. This involves changing tab colour in a worksheet; renaming a worksheet; changing the order of a worksheet; modifying page setup; inserting and deleting columns/rows; changing workbook themes; adjusting column width and row height; inserting headers in addition to footers. The fourth segment covered in this subject area tackles customizing options and viewing a worksheet & a workbook. The issues addressed here include hiding or showing worksheets; hiding or showing rows & columns; customizing QAT (Quick Access Toolbar); changing views of a worksheet. Other areas measured within the topic are changing views of a window; modifying document properties; changing magnification using zoom tools; displaying formulas. The last objective is configuring worksheets & workbooks for distribution. The subsection includes such skills as setting a print space; using alternative formats to save workbook files; printing parts of a workbook or the whole workbook; setting printing scaling; multipage worksheets; displaying repetitive row titles and column titles; inspecting workbooks for any hidden properties; inspecting a workbook for issues associated with accessibility and compatibility.

• Performing Operations Using Functions & Formulas (10-15%)

  The fourth objective covers using the functions to summarize data. This regards inserting references and using the SUM, MIN, MAX, COUNT, as well as AVERAGE functions to perform calculations. This is followed by using the functions to perform operations involving conditions. This addresses using IF, SUMIF, and AVERAGEIF to execute logical operations as well as using the COUNTIF function to perform statistical operations. This topic also covers using the MID, LEFT, RIGHT, LOWER, PROPER, UPPER, and CONCATENATE functions to format text.

• Creating Charts & Objects (15-20%)

  As you move to the last topic of the Microsoft 77-727 exam, you cover creating new charts; adding extra data series; switching source data columns & rows; using Quick Analysis to analyze data. This is followed by formatting graphic elements. This focuses on resizing charts; adding & modifying chart elements; applying chart styles & chart layouts; moving charts to chart sheets. Finally, inserting & formatting objects is another area covered in the last domain of the test. This tackles issues, such as inserting text boxes & shapes; inserting images; modifying object properties; adding alternative text for accessibility.

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

Microsoft Office Specialist (MOS) 2016 certification exams introduce a new performance-based format for improved testing of a candidate’s knowledge, skills, and abilities using the MOS 2016 programs:

• The MOS 2016 exam format incorporates multiple projects.
• MOS 2016 exam task instructions generally do not include the command name, as in previous versions. For example, function names are avoided and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.

Part of the requirements for: Microsoft Office Specialist: Microsoft Excel 2016

Download exam skills outline

Introduction to Microsoft 77-727: Excel 2016-Core Data Analysis, Manipulation, and Presentation Exam

Candidates for Microsoft 77-727: Excel 2016-Core Data Analysis, Manipulation, and Presentation Exam are seeking to prove fundamental networking knowledge and skills. Before taking this exam, exam aspirants ought to have a solid fundamental information of the concepts shared in preparation guide.

It is suggested that professionals accustomed to the ideas and also the technologies represented here by taking relevant training courses. Candidates are expected to have some hands-on experience with tasks such as create and edit a workbook with multiple sheets, and they use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

After passing this exam, candidates get a certificate from Microsoft that helps them to demonstrate their proficiency in MS Excel 2016 to their clients and employers.

Professional after sale service staff

With "reliable credit" as the soul of our 77-727 study tool, "utmost service consciousness" as the management philosophy, we endeavor to provide customers with high quality service. Our customer service staff, who are willing to be your little helper and answer your any questions about our Core Data Analysis, Manipulation, and Presentation qualification test, fully implement the service principle of customer-oriented service activities, aiming at comprehensive, coordinated and sustainable cooperation relationship with every users. Any puzzle about our 77-727 test torrent will receive timely and effective response, just leave a message on our official website or send us an e-mail at your convenience.

Microsoft 77-727 is an exam that checks an individual's capacity to handle functionalities within an Office Excel 2016 setup. It denotes that the candidate is competent in working with various workbook features such as multiple sheets, graphic elements, financial statements, data-entry logs, performance charts, and the like.

Simulation test available

Nowadays, seldom do the exam banks have such an integrated system to provide you a simulation test. You will gradually be aware of the great importance of stimulating the actual exam after learning about our 77-727 study tool. Because of this function, you can easily grasp how the practice system operates and be able to get hold of the core knowledge about the Core Data Analysis, Manipulation, and Presentation exam. In addition, when you are in the real exam environment, you can learn to control your speed and quality in answering questions and form a good habit of doing exercise, so that you're going to be fine in the Core Data Analysis, Manipulation, and Presentation exam.

Under the hatchet of fast-paced development, we must always be cognizant of social long term goals and the direction of the development of science and technology. Adapt to the network society, otherwise, we will take the risk of being obsoleted. Our Core Data Analysis, Manipulation, and Presentation qualification test help improve your technical skills and more importantly, helping you build up confidence to fight for a bright future in tough working environment. Our professional experts devote plenty of time and energy to developing the 77-727 study tool. You can trust us and let us be your honest cooperator in your future development. Here are several advantages about our Core Data Analysis, Manipulation, and Presentation exam for your reference. We sincere suggest you to spare some time to have a glance over the following items.

DOWNLOAD DEMO

Reliable exam bank

Our 77-727 test torrent keep a look out for new ways to help you approach challenges and succeed in passing the Core Data Analysis, Manipulation, and Presentation exam. An ancient Chinese proverb states that "The journey of a thousand miles starts with a single step". To be recognized as the leading international exam bank in the world through our excellent performance, our Core Data Analysis, Manipulation, and Presentation qualification test are being concentrated on for a long time and have accumulated mass resources and experience in designing study materials. There is plenty of skilled and motivated staff to help you obtain the Core Data Analysis, Manipulation, and Presentation exam certificate that you are looking forward. We have faith in our professional team and our 77-727 study tool, and we also wish you trust us wholeheartedly.