{"id":12255,"date":"2021-02-08T11:00:50","date_gmt":"2021-02-08T05:30:50","guid":{"rendered":"https:\/\/www.testpreptraining.com\/blog\/?p=12255"},"modified":"2023-03-14T19:09:36","modified_gmt":"2023-03-14T13:39:36","slug":"mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet","status":"publish","type":"post","link":"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/","title":{"rendered":"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet"},"content":{"rendered":"\n<p>Microsoft Excel is one of the most widely used tools in the business world for data management, analysis, and visualization. Excel is a powerful application that allows users to store and manipulate data, create charts and graphs, and perform complex calculations. However, mastering all the features and functions of Excel can be a daunting task, especially for those who are just getting started with the application.<\/p>\n\n\n\n<p>That&#8217;s where this cheat sheet comes in handy. This MO-200 cheat sheet provides a quick reference guide for all the essential Excel functions, shortcuts, and tips that will help you become more efficient and productive in using the application. Whether you are a beginner or an experienced Excel user, this cheat sheet is designed to help you save time and simplify your work.<\/p>\n\n\n\n<p>In this blog post, we will walk you through the key features of the MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet. We will cover everything from basic functions such as creating, editing, and formatting spreadsheets, to more advanced topics like data analysis and visualization. By the end of this post, you will have a comprehensive understanding of how to use Excel more effectively and efficiently. So, let&#8217;s get started!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft Exam MO-200: Overview<\/strong><\/h3>\n\n\n\n<p><a href=\"https:\/\/www.testpreptraining.ai\/mo-200-microsoft-excel-excel-and-excel-2019-mo-200-certification-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Exam MO-200: Microsoft Excel (Excel and Excel 2019)<\/a>\u00a0covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Microsoft Excel is one of the most important computer programmes in workplaces across the globe. It is a powerful tool for businesses as it performs functions ranging from creating spread sheets to data analysis. Using Excel for business has no limits; therefore more and more employers are looking out for individuals who have a diverse set and knowledge. This makes a certification in Microsoft Excel a necessity.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Microsoft Excel (Excel and Excel 2019) Glossary <\/strong><\/h4>\n\n\n\n<p>Here is a glossary of terms related to Microsoft Excel (Excel and Excel 2019):<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Active cell: The cell that is currently selected or in focus in an Excel worksheet.<\/li><li>AutoFill: A feature in Excel that allows users to fill a series of cells with a pattern, such as sequential numbers or dates, by dragging the fill handle.<\/li><li>Workbook: A file that contains one or more worksheets, charts, and other data in Excel.<\/li><li>Worksheet: A single page in an Excel workbook where data is entered, organized, and analyzed.<\/li><li>Cell: The intersection of a row and a column in an Excel worksheet, which contains data, formulas, or functions.<\/li><li>Formula: A mathematical equation or expression that performs calculations on data in Excel.<\/li><li>Function: A predefined formula in Excel that performs a specific task, such as summing a range of cells or finding the average.<\/li><li>Chart: A visual representation of data in Excel, such as a bar graph, line chart, or pie chart.<\/li><li>PivotTable: A powerful data analysis tool in Excel that summarizes and manipulates large amounts of data.<\/li><li>Conditional formatting: A feature in Excel that allows users to apply formatting to cells based on specific criteria, such as highlighting cells with values above or below a certain threshold.<\/li><\/ol>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exam preparation resources for MO-200: Microsoft Excel (Excel and Excel 2019) Exam<\/strong><\/h4>\n\n\n\n<p>Here are some official resources for preparing for the MO-200: Microsoft Excel (Excel and Excel 2019) exam:<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Microsoft Certification Exam MO-200: Microsoft Excel: This is the official exam page on the Microsoft website. It provides an overview of the exam, the skills measured, and the registration process. You can also find links to preparation resources such as study guides, practice tests, and training courses.<a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/mo-200\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/docs.microsoft.com\/en-us\/learn\/certifications\/exams\/mo-200<\/a><\/li><li>Microsoft Excel Exam MO-200 Study Guide: This study guide is available on the official Microsoft website and provides a detailed breakdown of the skills measured on the MO-200 exam. It includes sample questions and answers, as well as links to additional resources for exam preparation.<a href=\"https:\/\/query.prod.cms.rt.microsoft.com\/cms\/api\/am\/binary\/RE4pYu7\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/query.prod.cms.rt.microsoft.com\/cms\/api\/am\/binary\/RE4pYu7<\/a><\/li><li>Microsoft Excel Exam MO-200 Practice Test: This official practice test is designed to help you prepare for the MO-200 exam. It provides a simulation of the actual exam and includes 40 multiple-choice questions. You can take the test online and receive immediate feedback on your performance.<a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/mo-200-exam.aspx\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.microsoft.com\/en-us\/learning\/mo-200-exam.aspx<\/a><\/li><li>Microsoft Excel Training: The Microsoft website provides a range of training courses that cover different aspects of Excel. These courses are designed to help you improve your Excel skills and prepare for the MO-200 exam. Some of the courses are free, while others require a fee.<a href=\"https:\/\/support.microsoft.com\/en-us\/training\/excel-training-9bc05390-5950-401b-bd27-141ef24705c8\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/support.microsoft.com\/en-us\/training\/excel-training-9bc05390-5950-401b-bd27-141ef24705c8<\/a><\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Cheat Sheet for Microsoft Exam MO-200<\/strong><\/h2>\n\n\n\n<p>This Cheat Sheet is designed to help you get ready for the exams. We shall now walk you through with all the learning resources to enrich your revisions and add this much valued credential to your resume.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"750\" height=\"400\" src=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/TIBCO-Spotfire-X-Certified-Professional-exam-1.png\" alt=\"Microsoft MO-200 cheat sheet\" class=\"wp-image-12319\" srcset=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/TIBCO-Spotfire-X-Certified-Professional-exam-1.png 750w, https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/TIBCO-Spotfire-X-Certified-Professional-exam-1-300x160.png 300w\" sizes=\"(max-width: 750px) 100vw, 750px\" \/><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Review the Exam Objectives<\/strong><\/h3>\n\n\n\n<p>The Course domains and subtopics are a foundation for your preparation. Therefore clarity about them is of great importance. It helps you build confidence and also plan your preparations. This exam covers the following domains<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage worksheets and workbooks (10-15%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Import data into workbooks<\/strong>&nbsp;(<strong>Microsoft Documentation:<\/strong>&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/service-excel-workbook-files\" target=\"_blank\">Get data from Excel workbook files<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>To begin with, import data from .txt files (<strong>Microsoft Reference:<\/strong>&nbsp;<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 ) files<\/a>)<\/li><li>Secondly, Import data from .csv files (<strong>Microsoft Reference:<\/strong>&nbsp;<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 (.csv) files<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Navigate within workbooks<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/2011\/10\/18\/two-tips-for-faster-worksheet-navigation\/\" target=\"_blank\" rel=\"noreferrer noopener\">Two tips for faster worksheet navigation<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Further, Search for data within a workbook (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/find-or-replace-text-and-numbers-on-a-worksheet-0e304ca5-ecef-4808-b90f-fdb42f892e90\" target=\"_blank\" rel=\"noreferrer noopener\">Find or replace text and numbers on a worksheet<\/a>)<\/li><li>Moreover, Navigate to named cells, ranges, or workbook elements (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/find-named-ranges-14513df5-0d79-4cd5-9a03-968905b244e6#:~:text=You%20can%20find%20a%20named,range%20you%20want%20to%20find.\" target=\"_blank\" rel=\"noreferrer noopener\">Find named ranges<\/a>)<\/li><li>Then, Insert and remove hyperlinks (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Format worksheets and workbooks<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/ways-to-format-a-worksheet-d5efbdb5-b79b-475a-8c56-99aad944b030\" target=\"_blank\" rel=\"noreferrer noopener\">Ways to format a worksheet<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Subsequently, Modify page setup (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/troubleshoot\/excel\/set-page-setup-attributes\" target=\"_blank\" rel=\"noreferrer noopener\">Set page setup attributes for more than one sheet in Excel<\/a>)<\/li><li>Also, Adjust row height and column width (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46#:~:text=the%20contents%20(AutoFit)-,Select%20the%20column%20or%20columns%20that%20you%20want%20to%20change,boundary%20between%20two%20column%20headings.\" target=\"_blank\" rel=\"noreferrer noopener\">Change the column width and row height<\/a>)<\/li><li>Further, Customize headers and footers (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/insert-a-header-or-footer-b87ee4df-abc1-41f8-995b-b39f6d99c7ed\" target=\"_blank\" rel=\"noreferrer noopener\">Insert a header or footer<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Customize options and views<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-change-or-customize-a-view-f693f3d9-0037-4fa0-9376-3a57b6337b71\" target=\"_blank\" rel=\"noreferrer noopener\">Create, change, or customize a view<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Likewise, Customize the Quick Access toolbar (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/customize-the-quick-access-toolbar-43fff1c9-ebc4-4963-bdbd-c2b6b0739e52\" target=\"_blank\" rel=\"noreferrer noopener\">Customize the Quick Access Toolbar<\/a>)<\/li><li>Additionally, Display and modify workbook content in different views (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Furthermore, Freeze worksheet rows and columns (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f#:~:text=Freeze%20columns%20and%20rows,%3E%20Freeze%20Panes%20%3E%20Freeze%20Panes.\" target=\"_blank\" rel=\"noreferrer noopener\">Freeze the first two columns<\/a>)<\/li><li>Moreover, Change window views (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-in\/help\/4027860\/windows-10-view-display-settings\" target=\"_blank\" rel=\"noreferrer noopener\">View display settings in Windows 10<\/a>)<\/li><li>Also, Modify basic workbook properties (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/view-or-change-the-properties-for-an-office-file-21d604c2-481e-4379-8e54-1dd4622c6b75\" target=\"_blank\" rel=\"noreferrer noopener\">View or change the properties for an Office file<\/a>)<\/li><li>Then, Display formulas (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/display-or-hide-formulas-f7f5ab4e-bf24-4efc-8fc9-0c1b77a5356f\" target=\"_blank\" rel=\"noreferrer noopener\">Display or hide formulas<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Configure content for collaboration<\/strong>&nbsp;(<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/microsoft-365\/solutions\/collaborate-on-documents?view=o365-worldwide\" target=\"_blank\" rel=\"noreferrer noopener\">Collaborate with guests on a document<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Set a print area (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Save workbooks in alternative file formats (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/save-a-workbook-in-another-file-format-6a16c862-4a36-48f9-a300-c2ca0065286e\" target=\"_blank\" rel=\"noreferrer noopener\">Save a workbook in another file format<\/a>)<\/li><li>Configure print settings (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/troubleshoot\/windows-server\/printing\/use-group-policy-to-control-ad-printer\" target=\"_blank\" rel=\"noreferrer noopener\">Use Group Policy settings to control printers in Active Directory<\/a>)<\/li><li>Inspect workbooks for issues (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/remove-hidden-data-and-personal-information-by-inspecting-documents-presentations-or-workbooks-356b7b5d-77af-44fe-a07f-9aa4d085966f#:~:text=Open%20the%20workbook%20you%20want,and%20then%20click%20Inspect%20Document.\" target=\"_blank\" rel=\"noreferrer noopener\">Remove hidden data and personal information by inspecting documents, presentations, or workbooks<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage data cells and ranges (20-25%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Manipulate data in worksheets<\/strong><\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Paste data by using special paste options (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/paste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad\" target=\"_blank\" rel=\"noreferrer noopener\">Paste options<\/a>)<\/li><li>Fill cells by using Auto Fill<\/li><li>Insert and delete multiple columns or rows (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/insert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246\" target=\"_blank\" rel=\"noreferrer noopener\">Insert or delete rows, and columns<\/a>)<\/li><li>Insert and delete cells (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/insert-or-delete-rows-and-columns-6f40e6e4-85af-45e0-b39d-65dd504a3246\" target=\"_blank\" rel=\"noreferrer noopener\">Insert or delete rows, and columns<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Format cells and ranges<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/highlight-patterns-and-trends-with-conditional-formatting-eea152f5-2a7d-4c1a-a2da-c5f893adb621\" target=\"_blank\" rel=\"noreferrer noopener\">Highlight patterns and trends with conditional formatting<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Merge and unmerge cells (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/merge-and-unmerge-cells-5cbd15d5-9375-4540-907f-c673a93fcedf#:~:text=To%20unmerge%20cells%20immediately%20after,click%20Home%20%3E%20Merge%20%26%20Center.\" target=\"_blank\" rel=\"noreferrer noopener\">Merge and unmerge cells<\/a>)<\/li><li>Modify cell alignment, orientation, and indentation (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/align-or-rotate-text-in-a-cell-8bf8177a-d2e8-4f5c-a707-d51625fd7758\" target=\"_blank\" rel=\"noreferrer noopener\">Align or rotate text in a cell<\/a>)<\/li><li>Format cells by using Format Painter (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Wrap text within cells (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Then, Apply number formats (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-and-apply-a-custom-number-format-6c308025-35da-4047-9481-c146a12063df\" target=\"_blank\" rel=\"noreferrer noopener\">Create and apply a custom number format<\/a>)<\/li><li>Moreover, Apply cell formats from the Format Cells dialog box (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/troubleshoot\/excel\/format-cells-settings#:~:text=Applying%20Borders&amp;text=Select%20the%20cells%20that%20you,box%2C%20click%20the%20Border%20tab.\" target=\"_blank\" rel=\"noreferrer noopener\">Applying Borders<\/a>)<\/li><li>Further, Apply cell styles (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22\" target=\"_blank\" rel=\"noreferrer noopener\">Apply, create, or remove a cell style<\/a>)<\/li><li>Clear cell formatting (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/clear-cells-of-contents-or-formats-9ff6b8ff-1afd-495f-8ad8-8c1f6f82a9d6\" target=\"_blank\" rel=\"noreferrer noopener\">Clear cells of contents or formats<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Define and reference named ranges<\/strong><\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Define a named range (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64\" target=\"_blank\" rel=\"noreferrer noopener\">Define and use names in formulas<\/a>)<\/li><li>Name a table<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Summarize data visually<\/strong>&nbsp;(<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/visual-db-tools\/summarize-query-results-visual-database-tools?view=sql-server-ver15\" target=\"_blank\" rel=\"noreferrer noopener\">Summarize Query Results (Visual Database Tools)<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Insert Sparklines (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-sparklines-da9555cd-56f8-41d5-895b-2e40ac58ec50\" target=\"_blank\" rel=\"noreferrer noopener\">Create sparklines<\/a>)<\/li><li>Apply built-in conditional formatting (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f#:~:text=Quick%20formatting-,Select%20one%20or%20more%20cells%20in%20a%20range%2C%20table%2C%20or,and%20then%20select%20a%20format.\" target=\"_blank\" rel=\"noreferrer noopener\">Use conditional formatting to highlight information<\/a>)<\/li><li>Remove conditional formatting<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage tables and table data (15-20%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Create and format tables<\/strong><\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Create Excel tables from cell ranges (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Apply table styles (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Convert tables to cell ranges (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/convert-an-excel-table-to-a-range-of-data-0b326ff1-1764-4ebe-84ea-786265d41c77#:~:text=Click%20anywhere%20in%20the%20table,group%2C%20click%20Convert%20to%20Range.&amp;text=Right%2Dclick%20the%20table%2C%20then,table%20back%20to%20a%20range.\" target=\"_blank\" rel=\"noreferrer noopener\">Convert to Range<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Modify tables<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-or-modify-tables-or-indexes-by-using-a-data-definition-query-d935e129-229b-48d8-9f2d-1d4ee87f418e\" target=\"_blank\" rel=\"noreferrer noopener\">Create or modify tables or indexes by using a data-definition query<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Add or remove table rows and columns (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/video-add-and-delete-table-rows-and-columns-490e418e-cb57-40da-8d5b-b722a5da891f#:~:text=Press%20Backspace%2C%20or%20select%20the,choose%20the%20option%20you%20want.\" target=\"_blank\" rel=\"noreferrer noopener\">Add a column<\/a>)<\/li><li>Configure table style options (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370\" target=\"_blank\" rel=\"noreferrer noopener\">Format an Excel table<\/a>)<\/li><li>Insert and configure total rows (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/total-the-data-in-an-excel-table-6944378f-a222-4449-93d8-474386b11f20\" target=\"_blank\" rel=\"noreferrer noopener\">Total the data in an Excel table<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Filter and sort table data<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Filter records (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/dynamics365\/business-central\/ui-enter-criteria-filters\" target=\"_blank\" rel=\"noreferrer noopener\">Sorting, Searching, and Filtering<\/a>)<\/li><li>Sort data by multiple columns (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Perform operations by using formulas and functions (20-25%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Insert references<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-citations-in-a-word-document-ab9322bb-a8d3-47f4-80c8-63c06779f127#:~:text=Add%20citations%20to%20your%20document,citation%20you%20want%20to%20use.\" target=\"_blank\" rel=\"noreferrer noopener\">Add citations to your document<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Insert relative, absolute, and mixed references (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9\" target=\"_blank\" rel=\"noreferrer noopener\">Switch between relative, absolute, and mixed references<\/a>)<\/li><li>Reference named ranges and named tables in formulas (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64\" target=\"_blank\" rel=\"noreferrer noopener\">Define and use names in formulas<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Calculate and transform data<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/get-transform-in-excel-881c63c6-37c5-4ca2-b616-59e18d75b4de\" target=\"_blank\" rel=\"noreferrer noopener\">Get &amp; Transform in Excel<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Perform calculations by using the AVERAGE (), MAX (), MIN (), and SUM () functions (<strong>Microsoft Documentation:<\/strong>&nbsp;<a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/maker\/canvas-apps\/functions\/function-aggregates\" target=\"_blank\" rel=\"noreferrer noopener\">Average, Max, Min, StdevP, Sum, and VarP functions in Power Apps<\/a>)<\/li><li>Count cells by using the COUNT (), COUNTA (), and COUNTBLANK () functions<\/li><li>Perform conditional operations by using the IF () function (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2\" target=\"_blank\" rel=\"noreferrer noopener\">IF function<\/a>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Format and modify text<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/customize-or-create-new-styles-d38d6e47-f6fc-48eb-a607-1eb120dec563\" target=\"_blank\" rel=\"noreferrer noopener\">Customize or create new styles<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Moreover, Format text by using RIGHT (), LEFT (), and MID () functions<\/li><li>Also, Format text by using UPPER (), LOWER (), and LEN () functions (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Subsequently, Format text by using the CONCAT () and TEXTJOIN () functions (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c\" target=\"_blank\" rel=\"noreferrer noopener\">TEXTJOIN function<\/a>)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Manage charts (20-25%)<\/strong><\/h4>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Create charts<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Additionally, Create charts (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-a-chart-with-recommended-charts-cd131b77-79c7-4537-a438-8db20cea84c0\" target=\"_blank\" rel=\"noreferrer noopener\">Create a chart with recommended charts<\/a>)<\/li><li>Then, Create chart sheets<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Modify charts<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/change-the-chart-type-of-an-existing-chart-c686d8c2-b294-43c0-b744-f54000f51454\" target=\"_blank\" rel=\"noreferrer noopener\">Change the chart type of an existing chart<\/a>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Add data series to charts (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/add-a-data-series-to-your-chart-25340cfb-3fa3-428c-82cf-79983125df12#:~:text=Add%20a%20data%20series%20to%20a%20chart%20on%20a%20chart,Design%20tab%2C%20click%20Select%20Data.\" target=\"_blank\" rel=\"noreferrer noopener\">Add a data series to your chart<\/a>)<\/li><li>Switch between rows and columns in source data (<strong>Microsoft Reference:<\/strong>&nbsp;<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/change-how-rows-and-columns-of-data-are-plotted-in-a-chart-2be5cea4-715a-4637-9a67-73b99c8dc5e7\" target=\"_blank\" rel=\"noreferrer noopener\">Change how rows and columns of data are plotted in a chart<\/a>)<\/li><li>Add and modify chart elements (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Format charts<\/strong>&nbsp;(<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/h6>\n\n\n\n<ul class=\"wp-block-list\"><li>Apply chart layouts (<strong>Microsoft Reference:<\/strong>&nbsp;<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>)<\/li><li>Apply chart styles<\/li><li>Add alternative text to charts for accessibility (<strong>Microsoft Reference:<\/strong>&nbsp;<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 objects<\/a>)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Discover Learning Resources<\/strong><\/h3>\n\n\n\n<p>There are many resources available for preparation. Indeed, you should be very careful while choosing the resources as they will determine how well will you pass the exam. Let us have a look at handful of resources.<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong><em><a href=\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-study-guide\/\" target=\"_blank\" rel=\"noreferrer noopener\">Prepare for Microsoft MO-200 exam using the Study Guide!<\/a><\/em><\/strong><\/h5>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Paperbacks and hardcovers<\/strong><\/h4>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright is-resized\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/06\/ShowCover-1-322x400.jpg\" alt=\"\" width=\"135\" height=\"168\"\/><\/figure><\/div>\n\n\n\n<p>Books are the best valued resources for preparation. you can refer to multiple books that covers the same syllabus and has a lot of practice questions. You can refer to paperbacks or hardcovers, in whatever way you\u2019re comfortable in. but make sure to never compromise on quality of the content. You can even refer to the Microsoft MO-200 exam e-books available on many informative sites.<\/p>\n\n\n\n<p>We advise you to refer the book-&nbsp;<strong><a href=\"https:\/\/www.microsoftpressstore.com\/store\/mos-study-guide-for-microsoft-excel-exam-mo-200-9780136627159\" target=\"_blank\" rel=\"noreferrer noopener\">&nbsp;MOS Study Guide for Microsoft Excel Exam MO-200 by Joan Lambert<\/a>.&nbsp;<\/strong>This book is part of the Microsoft Study Guide series and is highly recommended. &nbsp;<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Online classes and instructor-led training<\/strong><\/h4>\n\n\n\n<p>These classes and trainings are prepared by the experts in the subject matter. You can refer to many educational sites that provide with quality training sessions coupled with regular doubt sessions and test series. These Microsoft MO-200 training sessions can be really interactive and helps in developing interest along with the crystal-clear clarity in the concepts. Microsoft offers its own training course for the preparation of this exam. The training course offered can be taken up in two modes, either online or through instructor led training. These Courses will help you ace the exam and we recommend you to definitely go for them.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Online Tutorials and Study Guide<\/strong><\/h4>\n\n\n\n<p>The best way to enhance your knowledge is by referring&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-200-microsoft-excel-excel-and-excel-2019\/\" target=\"_blank\">Online Tutorials. <\/a>These Tutorials provide in depth understanding about the exam and its concepts. Additionally, it also covers exam details and policies. Also, following a <a rel=\"noreferrer noopener\" href=\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-study-guide\/\" target=\"_blank\">Microsoft MO-200 Study Guide<\/a> ensures that you are on a right track throughout the journey of learning.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/tutorial\/exam-mo-200-microsoft-excel-excel-and-excel-2019\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/4.-Querying-Data-with-Transact-SQL-70-761-1.png\" alt=\"Microsoft MO-200 online tutorials\" class=\"wp-image-12321\" srcset=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/4.-Querying-Data-with-Transact-SQL-70-761-1.png 961w, https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/4.-Querying-Data-with-Transact-SQL-70-761-1-300x47.png 300w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Evaluate yourself with Practice Tests<\/strong><\/h3>\n\n\n\n<p>Practising is your way ahead while preparing. This exam is practical oriented hence you need enough hands on experience and lots of practising. While preparing it\u2019s also important to analyse your knowledge. Self-Evaluation is necessary and this can be done by attempting practice tests. With Microsoft MO-200 Practice test&nbsp;help you evaluate your preparations and also identify your weaker areas. Work upon strengthening them by focusing your preparations in the right direction. More the practice tests you attempt more you become thorough with the preparations.&nbsp;<a href=\"https:\/\/www.testpreptraining.ai\/mo-200-microsoft-excel-excel-and-excel-2019-mo-200-free-practice-test\" target=\"_blank\" rel=\"noreferrer noopener\">Lets Start Using Microsoft MO-200 Practice Test Now!<\/a><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/mo-200-microsoft-excel-excel-and-excel-2019-mo-200-free-practice-test\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/4.-Querying-Data-with-Transact-SQL-70-761.png\" alt=\"Microsoft MO-200 free practice tests\" class=\"wp-image-12320\" srcset=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/4.-Querying-Data-with-Transact-SQL-70-761.png 961w, https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/4.-Querying-Data-with-Transact-SQL-70-761-300x47.png 300w\" sizes=\"(max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>Earn a Competitive Edge over other by earning the Microsoft MO-200 exam credential.&nbsp;<a href=\"https:\/\/www.testpreptraining.ai\/mo-200-microsoft-excel-excel-and-excel-2019-mo-200-certification-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Start preparing for your exam NOW!<\/a><\/strong><\/h5>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is one of the most widely used tools in the business world for data management, analysis, and visualization. Excel is a powerful application that allows users to store and manipulate data, create charts and graphs, and perform complex calculations. However, mastering all the features and functions of Excel can be a daunting task,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":12318,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[260],"tags":[2017,2020,2018],"class_list":["post-12255","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft","tag-microsoft-mo-200-cheat-sheet","tag-microsoft-mo-200-exam-resources","tag-microsoft-mo-200-exam-revisions"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet - Blog<\/title>\n<meta name=\"description\" content=\"Prepare with cheat Sheet and Advanced Learning Resources for Microsoft Exam MO-200 Microsoft Excel (Excel and Excel 2019). Try Free Test Now!\" \/>\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\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet - Blog\" \/>\n<meta property=\"og:description\" content=\"Prepare with cheat Sheet and Advanced Learning Resources for Microsoft Exam MO-200 Microsoft Excel (Excel and Excel 2019). Try Free Test Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-02-08T05:30:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-14T13:39:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/TIBCO-Spotfire-X-Certified-Professional-exam.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=\"author\" content=\"TestPrepTraining\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TestPrepTraining\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/\",\"name\":\"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet - Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#website\"},\"datePublished\":\"2021-02-08T05:30:50+00:00\",\"dateModified\":\"2023-03-14T13:39:36+00:00\",\"author\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c\"},\"description\":\"Prepare with cheat Sheet and Advanced Learning Resources for Microsoft Exam MO-200 Microsoft Excel (Excel and Excel 2019). Try Free Test Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/blog\/\",\"name\":\"Learning Resources\",\"description\":\"Testprep Training Blogs\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c\",\"name\":\"TestPrepTraining\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g\",\"caption\":\"TestPrepTraining\"},\"description\":\"Testprep Training offers a wide range of practice exams and online courses for Professional certification exam curated by field experts and working professionals. Evaluate your skills and build confidence to appear for the exam.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet - Blog","description":"Prepare with cheat Sheet and Advanced Learning Resources for Microsoft Exam MO-200 Microsoft Excel (Excel and Excel 2019). Try Free Test Now!","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\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/","og_locale":"en_US","og_type":"article","og_title":"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet - Blog","og_description":"Prepare with cheat Sheet and Advanced Learning Resources for Microsoft Exam MO-200 Microsoft Excel (Excel and Excel 2019). Try Free Test Now!","og_url":"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/","og_site_name":"Blog","article_published_time":"2021-02-08T05:30:50+00:00","article_modified_time":"2023-03-14T13:39:36+00:00","og_image":[{"width":750,"height":400,"url":"https:\/\/www.testpreptraining.ai\/blog\/wp-content\/uploads\/2021\/02\/TIBCO-Spotfire-X-Certified-Professional-exam.png","type":"image\/png"}],"author":"TestPrepTraining","twitter_card":"summary_large_image","twitter_misc":{"Written by":"TestPrepTraining","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/","url":"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/","name":"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet - Blog","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/blog\/#website"},"datePublished":"2021-02-08T05:30:50+00:00","dateModified":"2023-03-14T13:39:36+00:00","author":{"@id":"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c"},"description":"Prepare with cheat Sheet and Advanced Learning Resources for Microsoft Exam MO-200 Microsoft Excel (Excel and Excel 2019). Try Free Test Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/blog\/mo-200-microsoft-excel-excel-and-excel-2019-cheat-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"MO-200: Microsoft Excel (Excel and Excel 2019) Cheat Sheet"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/blog\/#website","url":"https:\/\/www.testpreptraining.ai\/blog\/","name":"Learning Resources","description":"Testprep Training Blogs","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/b46daaf932dbfb07cbe7db807006780c","name":"TestPrepTraining","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cd4f7acc79865d9ba457114e386c039833599aae3707598a92eda256c6a5278?s=96&d=mm&r=g","caption":"TestPrepTraining"},"description":"Testprep Training offers a wide range of practice exams and online courses for Professional certification exam curated by field experts and working professionals. Evaluate your skills and build confidence to appear for the exam."}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts\/12255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/comments?post=12255"}],"version-history":[{"count":7,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts\/12255\/revisions"}],"predecessor-version":[{"id":30267,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/posts\/12255\/revisions\/30267"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/media\/12318"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/media?parent=12255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/categories?post=12255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/blog\/wp-json\/wp\/v2\/tags?post=12255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}