{"id":39139,"date":"2021-04-28T20:56:25","date_gmt":"2021-04-28T20:56:25","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=39139"},"modified":"2024-05-09T07:27:16","modified_gmt":"2024-05-09T07:27:16","slug":"exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/","title":{"rendered":"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation"},"content":{"rendered":"<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-58-750x400.png\" alt=\"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation  Online Tutorial\" class=\"wp-image-39199\"\/><\/figure>\n<\/div>\n\n\n<p>Exam 77-727 is for candidates who have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They understand and illustrate how to use Excel 2016&#8217;s main features correctly. Candidates construct and modify a multi-sheet worksheet, and they employ a graphic element to graphically display data. Budgets, financial accounts, team performance charts, sales invoices, and data-entry logs are all examples of workbooks.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam Details <\/strong><\/h3>\n\n\n\n<p>Before getting started with your preparation for <a href=\"https:\/\/www.testpreptraining.ai\/core-data-analysis-manipulation-and-presentation-77-727-certification-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 77-727<\/a>, you should have complete knowledge about the exam details. This would not only give you a clear idea about the exam format but also help you devise a clear and productive study plan to help you with your preparation. This Certification is the roadmap to your success but before that let&#8217;s understand the exam details.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Excel 2016: Core Data Analysis, Manipulation, and Presentation exam consists of 40-60 multiple-choice and multi response questions. <\/li>\n\n\n\n<li>The exam duration is 90 minutes and  is available in a variety of languages.  <\/li>\n\n\n\n<li>Minimum passing score is 700( on a scale of 1-1000) and the cost of the exam is  $100 USD.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td><strong>Exam Name<\/strong>&nbsp;&nbsp;<\/td><td>Excel 2016: Core Data Analysis Manipulation and Presentation<\/td><\/tr><tr><td><strong>Exam Duration<\/strong>&nbsp;<\/td><td>90 mins<\/td><\/tr><tr><td><strong>Exam Type<\/strong>&nbsp;<\/td><td>Microsoft Office Specialist<\/td><\/tr><tr><td><strong>Exam Language<\/strong><\/td><td>&nbsp;English, Chinese (Simplified), Chinese (Traditional), German, Spanish, French, Italian, Japanese, Korean, Norwegian, Dutch, Polish, Portuguese (Brazil), Romanian, Russian, Thai, Turkish<\/td><\/tr><tr><td><strong>Exam Code<\/strong><\/td><td>&nbsp;77-727<\/td><\/tr><tr><td><strong>Exam Format<\/strong>&nbsp;<\/td><td>Multiple Choice and Multi-Response Questions<\/td><\/tr><tr><td><strong>Number of Questions<\/strong>&nbsp;<\/td><td>40-60 Questions<\/td><\/tr><tr><td><strong>Exam Fee<\/strong>&nbsp;<\/td><td>$100 USD<\/td><\/tr><tr><td><strong>Pass Score&nbsp;<\/strong><\/td><td>700 (on a scale of 1-1000)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Scheduling the Exam <\/strong><\/h4>\n\n\n\n<p>Now, let&#8217;s understand the registration process for Exam 77-727.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Registration process <\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>From the  exam details page, select the button to schedule an exam with the exam delivery provider of your choice.<\/li>\n\n\n\n<li>You will be prompted to sign in with a personal Microsoft account. If you already have a certification profile, use the Microsoft account that is associated with it. If you don\u2019t have one, you can create a certification profile with your personal Microsoft account.<\/li>\n\n\n\n<li>Provide your legal name and contact information or verify that it is up to date. Make sure that your name matches what is on the identification you will present at your scheduled exam appointment; if it doesn\u2019t match, you will not be able to sit for the exam.<\/li>\n\n\n\n<li>On the next screen, employees of certain companies and attendees of some Microsoft events can claim discounts. Available discounts are listed at the top of the page. You can also check eligibility for other email addresses you might use (e.g., your work email address; another personal email address). For more detailed information. Once your discounts are claimed, select \u201cSchedule exam\u201d, and you will be redirected to your selected exam delivery provider to schedule your exam.<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Follow the on-screen steps to select a proctoring method (if available), schedule your exam appointment, and complete payment (if applicable).<\/li>\n\n\n\n<li>Once registered, your appointment should appear in the&nbsp;Certification Dashboard. If you are taking an online exam, you will start your exam from here as well.<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Exam Reschedule<\/strong><\/h5>\n\n\n\n<ul class=\"wp-block-list\">\n<li>There is no charge if you reschedule or cancel an exam appointment at least 6 business days prior to your appointment<\/li>\n\n\n\n<li>If you cancel or reschedule your exam within 5 business days of your registered exam time, a fee will be applied.<\/li>\n\n\n\n<li>If you fail to show up for your exam appointment or you don&#8217;t reschedule or cancel your appointment at least 24 hours prior to your scheduled appointment you forfeit your entire exam fee. Business days are Monday Friday, not including global holidays.<\/li>\n\n\n\n<li>Rescheduling or cancelling your scheduled exam appointment can be done through the Certification Dashboard.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation FAQs <\/strong><\/h3>\n\n\n\n<p>Get all your doubts and queries resolved with <a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation-faqs\/\" target=\"_blank\" rel=\"noreferrer noopener\">Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation FAQs<\/a><\/p>\n\n\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-59-750x400.png\" alt=\"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation FAQs\" class=\"wp-image-39200\"\/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Course Outline <\/strong><\/h3>\n\n\n\n<p>The next most critical step is to comprehend the course outline. It acquaints you with the exam&#8217;s structure and goals. Most of the time, a weighting value is applied to these objectives, indicating the proportional relevance of each objective on the tests. Higher-weighted objectives cover more questions on the exam. The 77-727 Outline has five subjects and subtopics.<\/p>\n\n\n\n<p>Therefore, it is advisable to go through the course outline thoroughly and create your study plan around these objectives to achieve the certification keeping in mind their weightage. The Excel 2016: Core Data Analysis, Manipulation, and Presentation Course Outline are as follows:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>1. Create and manage worksheets and workbooks (30-35%)<\/strong><\/h4>\n\n\n\n<p><strong><em>Creating worksheets and workbooks<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Creating a workbook, importing data from a delimited text file, adding a worksheet to an existing workbook, copying and moving a worksheet. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-937b-339e391393ba\" target=\"_blank\" rel=\"noreferrer noopener\">Import or export text (.txt or .csv) files<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/import-or-link-to-data-in-an-excel-workbook-a1952878-7c58-47b1-893d-e084913cc958\" target=\"_blank\" rel=\"noreferrer noopener\">Import or link to data in an Excel workbook<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/move-or-copy-worksheets-or-worksheet-data-47207967-bbb2-4e95-9b5c-3c174aa69328\" target=\"_blank\" rel=\"noreferrer noopener\">Move or copy worksheets or worksheet data<\/a>)<\/p>\n\n\n\n<p>Navigating in worksheets and workbooks<\/p>\n\n\n\n<p>\u2022 Searching for data within a workbook; navigating to a named cell, range, or workbook element; insert and remove hyperlinks. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/work-with-links-in-excel-7fc80d8d-68f9-482f-ab01-584c44d72b3e\" target=\"_blank\" rel=\"noreferrer noopener\">Work with links in Excel<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/find-named-ranges-14513df5-0d79-4cd5-9a03-968905b244e6\" target=\"_blank\" rel=\"noreferrer noopener\">Find named ranges<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/remove-or-turn-off-hyperlinks-027b4e8c-38f8-432c-b57f-6c8b67ebe3b0\" target=\"_blank\" rel=\"noreferrer noopener\">Remove or turn off hyperlinks<\/a>)<\/p>\n\n\n\n<p>Formatting worksheets and workbooks<\/p>\n\n\n\n<p>\u2022 Changing worksheet tab color, renaming a worksheet, changing worksheet order, modifying page setup, inserting and deleting columns or rows, changing workbook themes, adjusting row height and column width, inserting headers and footers. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/rename-a-worksheet-3f1f7148-ee83-404d-8ef0-9ff99fbad1f9\" target=\"_blank\" rel=\"noreferrer noopener\">Rename a worksheet<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-insert-headers-and-footers-3b4da988-f8f7-49be-bae0-ddb95c9ade15\" target=\"_blank\" rel=\"noreferrer noopener\">Insert headers and footers<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-a-background-color-to-a-sheet-tab-440b28f2-3146-4dca-95df-3b9d43acbe59\" target=\"_blank\" rel=\"noreferrer noopener\">Add a background color to a sheet tab<\/a>)<\/p>\n\n\n\n<p><strong><em>Customizing options and views for worksheets and workbooks<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Hiding or unhiding worksheets, hiding or unhiding columns and rows, customizing the Quick Access Toolbar, changing workbook views, changing window views, modifying document properties, changing magnification by using zoom tools, display formulas. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/hide-or-unhide-worksheets-69f2701a-21f5-4186-87d7-341a8cf53344\" target=\"_blank\" rel=\"noreferrer noopener\">Hide or Unhide worksheets<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/protect-a-worksheet-3179efdb-1285-4d49-a9c3-f4ca36276de6\" target=\"_blank\" rel=\"noreferrer noopener\">Protect a worksheet<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-apply-or-delete-a-custom-view-ce722bf9-0b4a-49a5-94ba-438fde18fc2b\" target=\"_blank\" rel=\"noreferrer noopener\">Create, apply, or delete a custom view<\/a>)<\/p>\n\n\n\n<p><strong><em>Configuring worksheets and workbooks for distribution<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Setting a print area, save workbooks in alternative file formats, print all or part of a workbook, set print scaling, display repeating row and column titles on multipage worksheets, inspect a workbook for hidden properties or personal information, inspect a workbook for accessibility issues, inspect a workbook for compatibility issues. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/set-or-clear-a-print-area-on-a-worksheet-27048af8-a321-416d-ba1b-e99ae2182a7e\" target=\"_blank\" rel=\"noreferrer noopener\">Set or clear a print area on a worksheet<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/print-a-worksheet-or-workbook-f4ad7962-b1d5-4eb9-a24f-0907f36c4b94\" target=\"_blank\" rel=\"noreferrer noopener\">Print a worksheet or workbook<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-print-headings-gridlines-formulas-and-more-1e0adb41-cc93-4299-b862-c53ba6d31b54\" target=\"_blank\" rel=\"noreferrer noopener\">Print headings, gridlines, and formulas<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-inspect-files-for-compatibility-issues-a494feda-ebd2-4815-b5aa-df7959e2d3ca#:~:text=Select%20File%20%3E%20Info.,%2C%20select%20Help%2C%20if%20available.\" target=\"_blank\" rel=\"noreferrer noopener\">Inspect files for compatibility issues<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/worksheet-compatibility-issues-f9c80c5b-5afc-40da-a841-b888746abd40\" target=\"_blank\" rel=\"noreferrer noopener\">Worksheet compatibility issues<\/a>)<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>2.<\/strong> <strong>Manage data cells and ranges (15-20%)<\/strong><\/h5>\n\n\n\n<p><strong><em>Insert data in cells and ranges<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Replace data; cut, copy, or paste data; paste data by using special paste options; fill cells by using Auto Fill; insert and delete cells. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71\" target=\"_blank\" rel=\"noreferrer noopener\">Copy and paste specific cell contents<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/paste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad\" target=\"_blank\" rel=\"noreferrer noopener\">Paste options,<\/a><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db\" target=\"_blank\" rel=\"noreferrer noopener\"> Fill data automatically in worksheet cells<\/a>)<\/p>\n\n\n\n<p><strong><em>Format cells and ranges<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Merge cells, modify cell alignment and indentation, format cells by using Format Painter, wrap text within cells, apply number formats, apply cell formats, apply cell styles. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-the-format-painter-4bb415a9-d4e4-42b7-b579-170adc594e40\" target=\"_blank\" rel=\"noreferrer noopener\">Use the Format Painter<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/wrap-text-in-a-cell-2a18cff5-ccc1-4bce-95e4-f0d4f3ff4e84\" target=\"_blank\" rel=\"noreferrer noopener\">Wrap text in a cell<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf\" target=\"_blank\" rel=\"noreferrer noopener\">Merge and unmerge cells<\/a>)<\/p>\n\n\n\n<p><strong><em>Summarize and organize data<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Insert sparklines, outline data, insert subtotals, apply conditional formatting. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/insert-subtotals-in-a-list-of-data-in-a-worksheet-7881d256-b4fa-4f81-b71e-b0a3d4a52b3a\" target=\"_blank\" rel=\"noreferrer noopener\">Insert subtotals in a list of data in a worksheet<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-sparklines-to-show-data-trends-1474e169-008c-4783-926b-5c60e620f5ca\" target=\"_blank\" rel=\"noreferrer noopener\">Use sparklines to show data trends<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/use-conditional-formatting-to-highlight-information-in-excel-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f\" target=\"_blank\" rel=\"noreferrer noopener\">Use conditional formatting to highlight information in Excel)<\/a><\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>3. Create tables (15-20%)<\/strong><\/h5>\n\n\n\n<p><strong><em>Create and manage tables<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Create an Excel table from a cell range, convert a table to a cell range, add or remove table rows and columns. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664\" target=\"_blank\" rel=\"noreferrer noopener\">Create and format tables<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77\" target=\"_blank\" rel=\"noreferrer noopener\">Convert an Excel table to a range of data<\/a>)<\/p>\n\n\n\n<p><strong><em>Manage table styles and options<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Apply styles to tables, configure table style options, insert total rows. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-apply-a-table-style-f1b798e7-fa25-496c-a434-0c2a15bed09f\" target=\"_blank\" rel=\"noreferrer noopener\">Apply a table style<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370\" target=\"_blank\" rel=\"noreferrer noopener\">Format an Excel table<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-and-format-tables-e81aa349-b006-4f8a-9806-5af9df0ac664\" target=\"_blank\" rel=\"noreferrer noopener\">Create and format tables<\/a>)<\/p>\n\n\n\n<p><strong><em>Filter and sort a table<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Filter records, sort data by multiple columns, change sort order, remove duplicate records. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/filter-for-or-remove-duplicate-values-662c153f-cf21-4d7b-a5af-a9390648eb37\" target=\"_blank\" rel=\"noreferrer noopener\">Filter for or remove duplicate values<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2\" target=\"_blank\" rel=\"noreferrer noopener\">Filter for unique values or remove duplicate values<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sort-data-in-a-table-77b781bf-5074-41b0-897a-dc37d4515f27\" target=\"_blank\" rel=\"noreferrer noopener\">Sort data in a table<\/a>)<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>4.<\/strong> <strong>Perform operations with formulas and functions (10-15%)<\/strong><\/h5>\n\n\n\n<p><strong><em>Summarize data by using functions<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Insert references, perform calculations by using the SUM function, perform calculations by using MIN and MAX functions, perform calculations by using the COUNT function, perform calculations by using the AVERAGE function. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-platform\/power-fx\/reference\/function-aggregates\" target=\"_blank\" rel=\"noreferrer noopener\">Average, Max, Min, StdevP, Sum, and VarP functions<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca173\" target=\"_blank\" rel=\"noreferrer noopener\">Overview of formulas in Excel<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-a-formula-in-a-word-or-outlook-table-cbd0596e-ea8a-485e-a35d-b2cb2c4f3e27\" target=\"_blank\" rel=\"noreferrer noopener\">Use a formula in a Word or Outlook table<\/a>)<\/p>\n\n\n\n<p><strong><em>Perform conditional operations by using functions<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Perform logical operations by using the IF function, perform logical operations by using the SUMIF function, perform logical operations by using the AVERAGEIF function, perform statistical operations by using the COUNTIF function. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/sumif-function-169b8c99-c05c-4483-a712-1697a653039b\" target=\"_blank\" rel=\"noreferrer noopener\">SUMIF function<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188\" target=\"_blank\" rel=\"noreferrer noopener\">Excel functions (alphabetical)<\/a>)<\/p>\n\n\n\n<p><strong><em>Format and modify text by using functions<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Format text by using RIGHT, LEFT, and MID functions; format text by using UPPER, LOWER, and PROPER functions; format text by using the CONCATENATE function.  <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d\" target=\"_blank\" rel=\"noreferrer noopener\">CONCATENATE function<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/text-functions-reference-cccd86ad-547d-4ea9-a065-7bb697c2a56e\" target=\"_blank\" rel=\"noreferrer noopener\">Text functions (reference)<\/a>)<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>5.<\/strong> <strong>Create charts and objects (15-20%)<\/strong><\/h5>\n\n\n\n<p><strong><em>Create charts<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Create a new chart, add additional data series, switch between rows and columns in source data, analyze data by using Quick Analysis. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2\" target=\"_blank\" rel=\"noreferrer noopener\">Create a chart from start to finish<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12\" target=\"_blank\" rel=\"noreferrer noopener\">Add a data series to your chart<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/instant-charts-using-quick-analysis-9e382e73-7f5e-495a-a8dc-be8225b1bb78\" target=\"_blank\" rel=\"noreferrer noopener\">Instant charts using Quick Analysis<\/a>)<\/p>\n\n\n\n<p><strong><em>Format graphic elements<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Resize charts, add and modify chart elements, apply chart layouts and styles, move charts to a chart sheet. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/change-the-layout-or-style-of-a-chart-a346e438-d22a-4540-aa87-bce9feb719cf\" target=\"_blank\" rel=\"noreferrer noopener\">Change the layout or style of a chart<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2\" target=\"_blank\" rel=\"noreferrer noopener\">Create a chart from start to finish<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/present-data-in-a-chart-58516b99-55fc-4f45-ac81-cc6868a18a8a\" target=\"_blank\" rel=\"noreferrer noopener\">Present data in a chart<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/format-elements-of-a-chart-b6c787d5-f90a-41d2-a901-9d3ed9f0dbf0\" target=\"_blank\" rel=\"noreferrer noopener\">Format elements of a chart<\/a>)<\/p>\n\n\n\n<p><strong><em>Insert and format objects<\/em><\/strong><\/p>\n\n\n\n<p>\u2022 Insert text boxes and shapes, insert images, modify object properties, add alternative text to objects for accessibility. <strong>(Microsoft Documentation:<\/strong> <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-alternative-text-to-a-shape-picture-chart-smartart-graphic-or-other-object-44989b2a-903c-4d9a-b742-6a75b451c669\" target=\"_blank\" rel=\"noreferrer noopener\">Add alternative text to a shape, picture, chart, SmartArt graphic, or other object<\/a>, <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593\" target=\"_blank\" rel=\"noreferrer noopener\">Make your Excel documents accessible to people with disabilities<\/a>)<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Preparatory Guide<\/strong><\/h3>\n\n\n\n<p>Exam preparation is a difficult process. It necessitates a great deal of perseverance, consistency, and devotion. It is the key to a prosperous and prosperous future. The Excel 2016: Core Data Analysis, Manipulation, and Presentation test, on the other hand, is not something that can be completed in a single sitting. It takes extensive planning, as well as time, effort, and concentrated attention. Using the Commercial Plumbing Inspector (P2) training and other study tools, our Preparatory Guide will assist you along your trip and prepare you effectively.<\/p>\n\n\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"2000\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-60.png\" alt=\"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Preparatory Guide \" class=\"wp-image-39201\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-60.png 800w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-60-160x400.png 160w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-1 Review the Exam Objectives<\/strong><\/h4>\n\n\n\n<p>Exam objectives should be reviewed thoroughly to ensure that nothing is overlooked. As previously said, checking through the course outline is critical while studying for any test to ensure that everything is covered. Furthermore, familiarising oneself with the test objectives aids in the faster and more accurate comprehension of information. Given the extensive material covered by this test, it is recommended that you consult the Official Exam Website. 77-727 The exam includes the following five topics:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create and manage worksheets and workbooks<\/li>\n\n\n\n<li>Manage data cells and ranges <\/li>\n\n\n\n<li>Create tables<\/li>\n\n\n\n<li>Perform operations with formulas and functions <\/li>\n\n\n\n<li>Create charts and objects <\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-2 Discover your Learning Resources <\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>Study Guide<\/em><\/strong> <\/li>\n<\/ul>\n\n\n\n<p>The <a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel 2016: Core Data Analysis, Manipulation, and Presentation Study Guide<\/a> will provide you complete clarity about the exam questions and how to approach them while preparing you from the scratch.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>Reference Books<\/em><\/strong><\/li>\n<\/ul>\n\n\n\n<p>Your best companions are books. Without books, every test preparation is inadequate. To expand your knowledge, you should constantly seek for legitimate and reputable publications authored by skilled authors. Furthermore, they may supply you with deep insights that the study guides may not cover, giving you an advantage over the competition.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>Self-paced learning on Microsoft Learn<\/em><\/strong><\/li>\n<\/ul>\n\n\n\n<p>On the test information page, Microsoft provides a selected set of free online learning pathways for each certification to assist you in your preparation. Microsoft Learn includes interactive step-by-step and bite-size courses and modules for self-paced learning. Furthermore, it aids in the development of technical abilities that will help you expand your knowledge and capacity to solve problems. They&#8217;re browser-based courses that you may do at your own leisure.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>Instructor-led training<\/em><\/strong><\/li>\n<\/ul>\n\n\n\n<p>Microsoft offers instructor-led training with advice and support from technical subject matter experts if you&#8217;re seeking for in-depth, organised training. This offer includes online or in-person seminars and workshops delivered by Microsoft Certified Trainers that are based on Microsoft Official Courses that are kept up-to-date and aligned to help you prepare for certification.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><em>Hire a Microsoft Certified Trainer<\/em><\/strong><\/li>\n<\/ul>\n\n\n\n<p>Furthermore, some workplaces also host a Microsoft Certified Trainer for in-person training. The worldwide&nbsp;training partner network from Microsoft makes it possible that a trainer can deliver a specific course for your team.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-3 Join an Online Community<\/strong><\/h4>\n\n\n\n<p>It&#8217;s always a good idea to join an online community. Staying focused is easier when you&#8217;re surrounded by individuals who share your aims. They also make it easier to grasp ideas and study exam objectives in a more engaging and friendly manner. Furthermore, online forums allow you to keep up with the newest updates and connect with industry experts and professionals while also providing you with the appropriate exposure for your skills. Joining online communities will increase your self-esteem and confidence, as well as assist you much on your quest.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Step-4 Practice Tests are your way ahead  <\/strong><\/h4>\n\n\n\n<p>Finally, taking as many Exam 77-727 practice exams as possible is the most critical step. Practice examinations, no matter how well you prepare, are always missing. Practice tests assist you in evaluating your preparation and determining your strengths and weaknesses. You may use this as a starting point for organizing the remainder of your research by focusing on key topics. You can also improve your speed and accuracy while increasing your confidence. To get this certification, try to surpass yourself on each consecutive test. <a href=\"https:\/\/www.testpreptraining.ai\/core-data-analysis-manipulation-and-presentation-77-727-certification-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Take the  Excel 2016: Core Data Analysis, Manipulation, and Presentation Free Practice Test Now!<\/a><\/p>\n\n\n<div class=\"wp-block-image is-style-default\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/core-data-analysis-manipulation-and-presentation-77-727-certification-exam\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-61.png\" alt=\"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation Practice Tests\n\" class=\"wp-image-39202\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-61.png 960w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-61-750x117.png 750w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Exam 77-727 is for candidates who have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They understand and illustrate how to use Excel 2016&#8217;s main features correctly. Candidates construct and modify a multi-sheet worksheet, and they employ a graphic element to graphically display data. Budgets, financial accounts, team performance&#8230;<\/p>\n","protected":false},"author":1,"featured_media":39199,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[1226],"tags":[5087,5085,5088,5089,5086],"class_list":["post-39139","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","tag-exam-77-727-course-outline","tag-exam-77-727-exam-details","tag-exam-77-727-faqs","tag-exam-77-727-preparatory-guide","tag-exam-77-727-study-guide"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Get ready to prepare for Exam 77-727 with the latest practice tests. Try the Free Practice Test now and ace your exam!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Get ready to prepare for Exam 77-727 with the latest practice tests. Try the Free Practice Test now and ace your exam!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-09T07:27:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-58.png\" \/>\n\t<meta property=\"og:image:width\" content=\"750\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/\",\"name\":\"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-04-28T20:56:25+00:00\",\"dateModified\":\"2024-05-09T07:27:16+00:00\",\"description\":\"Get ready to prepare for Exam 77-727 with the latest practice tests. Try the Free Practice Test now and ace your exam!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation - Testprep Training Tutorials","description":"Get ready to prepare for Exam 77-727 with the latest practice tests. Try the Free Practice Test now and ace your exam!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/","og_locale":"en_US","og_type":"article","og_title":"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation - Testprep Training Tutorials","og_description":"Get ready to prepare for Exam 77-727 with the latest practice tests. Try the Free Practice Test now and ace your exam!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2024-05-09T07:27:16+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/04\/image-58.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/","name":"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-04-28T20:56:25+00:00","dateModified":"2024-05-09T07:27:16+00:00","description":"Get ready to prepare for Exam 77-727 with the latest practice tests. Try the Free Practice Test now and ace your exam!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/exam-77-727-excel-2016-core-data-analysis-manipulation-and-presentation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam 77-727: Excel 2016: Core Data Analysis, Manipulation, and Presentation"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/39139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=39139"}],"version-history":[{"count":16,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/39139\/revisions"}],"predecessor-version":[{"id":62647,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/39139\/revisions\/62647"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media\/39199"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=39139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=39139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=39139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}