{"id":885,"date":"2025-05-22T07:09:47","date_gmt":"2025-05-22T07:09:47","guid":{"rendered":"https:\/\/www.skilr.com\/tutorial\/?page_id=885"},"modified":"2025-05-22T07:09:48","modified_gmt":"2025-05-22T07:09:48","slug":"exam-mo-200-microsoft-excel-office-2019","status":"publish","type":"page","link":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/","title":{"rendered":"Exam MO-200: Microsoft Excel (Office 2019)"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-1024x576.jpg\" alt=\"Exam MO-200: Microsoft Excel (Office 2019)\" class=\"wp-image-888\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-1024x576.jpg 1024w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-300x169.jpg 300w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg 1000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p>The MO-200: Microsoft Excel (Office 2019) certification is designed for individuals seeking to validate their proficiency in using the core features and tools within Excel 2019. This exam targets users who are skilled in leveraging Excel to solve real-world problems in business and data environments. Candidates are expected to demonstrate expertise in the following areas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Workbook and Worksheet Management<\/strong>\n<ul class=\"wp-block-list\">\n<li>Efficiently create, manage, and navigate through workbooks and worksheets.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Cell and Range Management<\/strong>\n<ul class=\"wp-block-list\">\n<li>Define, format, and organize data within cells and ranges.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Table Creation and Management<\/strong>\n<ul class=\"wp-block-list\">\n<li>Convert data ranges into tables and utilize table tools for analysis.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Formulas and Functions<\/strong>\n<ul class=\"wp-block-list\">\n<li>Apply built-in functions and create custom formulas to perform data calculations.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Chart and Object Integration<\/strong>\n<ul class=\"wp-block-list\">\n<li>Design and integrate visual elements such as charts, graphs, and objects to enhance data presentation.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>&#8211; Sample Workbook Applications<\/strong><\/h3>\n\n\n\n<p>Throughout the <a href=\"https:\/\/www.skilr.com\/prepare-for-microsoft-excel-excel-and-excel-2019-mo-200-exam\" target=\"_blank\" rel=\"noreferrer noopener\">exam<\/a>, candidates may encounter tasks related to the creation and editing of common business documents, such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Budget spreadsheets with professional formatting<\/li>\n\n\n\n<li>Financial reports and statements<\/li>\n\n\n\n<li>Charts tracking team or organizational performance<\/li>\n\n\n\n<li>Itemized sales invoices<\/li>\n\n\n\n<li>Logs for data collection and entry<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>&#8211; Candidate Profile<\/strong><\/h3>\n\n\n\n<p>Ideal candidates for this exam should:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Have completed approximately 150 hours of formal training and hands-on practice using Microsoft Excel 2019.<\/li>\n\n\n\n<li>Possess industry-level associate competency in spreadsheet creation and data analysis.<\/li>\n\n\n\n<li>Be prepared for entry-level roles in positions requiring Excel proficiency, such as administrative support, data analysis, or financial operations.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Exam Details<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"861\" height=\"467\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-22-122301.png\" alt=\"Microsoft Excel (Office 2019)\" class=\"wp-image-889\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-22-122301.png 861w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Screenshot-2025-05-22-122301-300x163.png 300w\" sizes=\"auto, (max-width: 861px) 100vw, 861px\" \/><\/figure>\n<\/div>\n\n\n<p>The Exam MO-200: Microsoft Excel (Office 2019) is classified at an intermediate difficulty level and is primarily intended for individuals in business user roles. Candidates will be given 50 minutes to complete the assessment, which will be proctored and closed book, meaning reference materials are not allowed during the exam session. Additionally, the exam may include interactive components that require hands-on engagement with Excel features and tools.<\/p>\n\n\n\n<p>To accommodate a global audience, the MO-200 exam is available in multiple languages, including English, Dutch, French, German, Spanish, Italian, Portuguese (Brazil), Russian, Japanese, Korean, Indonesian (Indonesia), Polish, Greek (Greece), Arabic (Saudi Arabia), Vietnamese (Vietnam), Chinese (Simplified and Traditional), and English (Malaysia). This broad language support ensures accessibility for candidates from diverse linguistic backgrounds.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Course Outline<\/strong><\/h2>\n\n\n\n<p>The <a href=\"https:\/\/www.skilr.com\/prepare-for-microsoft-excel-excel-and-excel-2019-mo-200-exam\" target=\"_blank\" rel=\"noreferrer noopener\">Microsoft MO-200 Exam<\/a> covers the following topics:<\/p>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>1. Learn how to manage worksheets and workbooks (10-15%)<\/strong><\/h5>\n\n\n\n<p><strong>Importing data into workbooks<\/strong>\u00a0(<strong>Microsoft Documentation:<\/strong>\u00a0<a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/service-excel-workbook-files\" target=\"_blank\" rel=\"noreferrer noopener\">Get data from Excel workbook files<\/a>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Import data from .txt files (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Import data from .csv files (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Navigating within workbooks<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Search for data within a workbook (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Navigate to named cells, ranges, or workbook elements (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Insert and remove hyperlinks (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Formatting worksheets and workbooks<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Modify page setup (<strong>Microsoft Documentation:<\/strong>\u00a0<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>\n\n\n\n<li>Adjust row height and column width (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Customize headers and footers (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Customizing options and views<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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\">\n<li>Customize the Quick Access toolbar (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Display and modify workbook content in different views (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Freeze worksheet rows and columns (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Change window views (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Modify basic workbook properties (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Display formulas (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Configuring content for collaboration<\/strong>\u00a0(<strong>Microsoft Documentation:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Set a print area (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Save workbooks in alternative file formats (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Configure print settings (<strong>Microsoft Documentation:<\/strong>\u00a0<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>\n\n\n\n<li>Inspect workbooks for issues (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>2. Managing data cells and ranges (20-25%)<\/strong><\/h5>\n\n\n\n<p><strong>Manipulating data in worksheets<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Paste data by using special paste options (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Fill cells by using Auto Fill<\/li>\n\n\n\n<li>Insert and delete multiple columns or rows (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Insert and delete cells (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<h6 class=\"wp-block-heading\"><strong>Formatting cells and ranges<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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\">\n<li>Merge and unmerge cells (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Modify cell alignment, orientation, and indentation (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Format cells by using Format Painter (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Wrap text within cells (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Apply number formats (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Apply cell formats from the Format Cells dialog box (<strong>Microsoft Documentation:<\/strong>\u00a0<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>\n\n\n\n<li>Apply cell styles (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Clear cell formatting (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Defining and referencing named ranges<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Define a named range (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Name a table<\/li>\n<\/ul>\n\n\n\n<p><strong>Summarizing data visually<\/strong>\u00a0(<strong>Microsoft Documentation:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Insert Sparklines (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Apply built-in conditional formatting (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Remove conditional formatting<\/li>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>3. Understand about managing tables and table data (15-20%)<\/strong><\/h5>\n\n\n\n<p><strong>Creating and formatting tables<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create Excel tables from cell ranges (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Apply table styles (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Convert tables to cell ranges (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Modifying tables<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add or remove table rows and columns (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Configure table style options (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Insert and configure total rows (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Filtering and sorting table data<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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<ul class=\"wp-block-list\">\n<li>Filter records (<strong>Microsoft Documentation:<\/strong>\u00a0<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>\n\n\n\n<li>Sort data by multiple columns (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.skilr.com\/prepare-for-microsoft-excel-excel-and-excel-2019-mo-200-exam\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-3.jpg\" alt=\"Exam MO-200\" class=\"wp-image-890\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-3.jpg 961w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-3-300x47.jpg 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h5 class=\"wp-block-heading\"><strong>4. Performing operations by using formulas and functions (20-25%)<\/strong><\/h5>\n\n\n\n<p><strong>Inserting references<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Insert relative, absolute, and mixed references (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Reference named ranges and named tables in formulas (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Calculating and transforming data<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Perform calculations by using the AVERAGE (), MAX (), MIN (), and SUM () functions (<strong>Microsoft Documentation:<\/strong>\u00a0<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>\n\n\n\n<li>Count cells by using the COUNT (), COUNTA (), and COUNTBLANK () functions<\/li>\n\n\n\n<li>Perform conditional operations by using the IF () function (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Formatting and modifying text<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Format text by using RIGHT (), LEFT (), and MID () functions<\/li>\n\n\n\n<li>Formatting text by using UPPER (), LOWER (), and LEN () functions (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Format text by using the CONCAT () and TEXTJOIN () functions (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<h5 class=\"wp-block-heading\"><strong>5. Learn how to manage charts (20-25%)<\/strong><\/h5>\n\n\n\n<p><strong>Creating charts<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Create charts (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Create chart sheets<\/li>\n<\/ul>\n\n\n\n<p><strong>Modifying charts<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Add data series to charts (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Switch between rows and columns in source data (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Add and modify chart elements (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<p><strong>Formatting charts<\/strong>\u00a0(<strong>Microsoft Reference:<\/strong>\u00a0<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>)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Apply chart layouts (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n\n\n\n<li>Apply chart styles<\/li>\n\n\n\n<li>Add alternative text to charts for accessibility (<strong>Microsoft Reference:<\/strong>\u00a0<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>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ftoc-heading-12-2\"><strong>Microsoft MO-200 Exam FAQs<\/strong><\/h2>\n\n\n\n<p><strong><em><a href=\"https:\/\/www.skilr.com\/tutorial\/microsoft-mo-200-exam-faqs\/\" target=\"_blank\" rel=\"noreferrer noopener\">Click Here for FAQs!<\/a><\/em><\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.skilr.com\/tutorial\/microsoft-mo-200-exam-faqs\/\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-1-1024x576.jpg\" alt=\"FAQS: Microsoft Excel (Office 2019)\" class=\"wp-image-891\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-1-1024x576.jpg 1024w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-1-300x169.jpg 300w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-1-scaled.jpg 1000w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Microsoft Certification Exam Policies<\/strong><\/h3>\n\n\n\n<p>To ensure fairness and maintain the credibility of its certifications, Microsoft enforces strict <a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/certification-exam-policies\" target=\"_blank\" rel=\"noreferrer noopener\">testing policies<\/a> for both online and in-person exams.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>MOS Exam Retake Policy:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Candidates must wait 24 hours before retaking a failed MOS exam. After a second failure, the wait increases to 48 hours. There is no limit to the number of retakes, though retaking a passed exam is usually unnecessary unless specifically required.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>Rescheduling and Cancellation:<\/strong>\n<ul class=\"wp-block-list\">\n<li>Exams can be rescheduled or canceled for free if done at least six business days in advance. Changes made within five days may incur fees, while cancellations within 24 hours or no-shows result in a lost exam fee. Exceptions may apply for emergencies with proper documentation.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Microsoft MO-200 Exam Study Guide<\/strong><\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"667\" height=\"1000\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-2-scaled.jpg\" alt=\"Exam MO-200\" class=\"wp-image-892\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-2-scaled.jpg 667w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-2-200x300.jpg 200w\" sizes=\"auto, (max-width: 667px) 100vw, 667px\" \/><\/figure>\n<\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Understand the Exam Objectives<\/strong><\/h3>\n\n\n\n<p>Begin your preparation by thoroughly reviewing the official <a href=\"https:\/\/www.skilr.com\/prepare-for-microsoft-excel-excel-and-excel-2019-mo-200-exam\" target=\"_blank\" rel=\"noreferrer noopener\">exam objectives<\/a> outlined by Microsoft. These objectives define the core skills and knowledge areas you\u2019ll be tested on, such as managing worksheets and workbooks, working with cells and ranges, creating tables, applying formulas and functions, and using charts and objects. Understanding these topics gives you a clear roadmap of what to focus on, helping you identify areas where you are strong and others that may require more attention. Microsoft often updates its objectives to align with real-world business applications, so be sure you\u2019re referencing the latest version available.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Use Official Microsoft Learning Resources<\/strong><\/h3>\n\n\n\n<p>Microsoft provides a range of <a href=\"https:\/\/learn.microsoft.com\/en-us\/credentials\/certifications\/mos-excel-2019\/?practice-assessment-type=certification\" target=\"_blank\" rel=\"noreferrer noopener\">official training<\/a> materials specifically tailored to their certification exams. These include self-paced learning modules, interactive tutorials, and downloadable content, all available on platforms like Microsoft Learn. These resources are developed by Microsoft experts and align directly with the skills measured in the MO-200 exam. By following the official content, you ensure your preparation is accurate, up-to-date, and aligned with the expectations of the certification. Make it a habit to complete each module thoroughly, take notes, and revisit difficult concepts for reinforcement.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Join Study Groups and Online Communities<\/strong><\/h3>\n\n\n\n<p>Connecting with others, preparing for the MO-200 exam can significantly enhance your learning experience. Study groups\u2014whether on platforms like Reddit, LinkedIn, Discord, or Microsoft Tech Community\u2014allow you to discuss complex topics, share tips, and ask questions in real time. These communities often share insights into tricky exam topics, helpful resources, and strategies that others have successfully used. Engaging in discussion not only deepens your understanding but also keeps you motivated and accountable throughout your preparation journey.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Take MO-200 Practice Tests<\/strong><\/h3>\n\n\n\n<p>Once you\u2019re comfortable with the content, begin taking practice exams that simulate the real MO-200 experience. These tests help you assess your readiness, identify weak areas, and get familiar with the exam format and timing. Aim to complete several full-length practice tests under timed conditions to build confidence and improve time management. After each attempt, carefully review your incorrect answers to understand your mistakes and reinforce learning. You can find high-quality practice exams from official sources or reputable third-party providers who specialize in Microsoft certifications.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Hands-On Practice<\/strong><\/h3>\n\n\n\n<p>Excel is a practical tool, and the best way to master it is through consistent hands-on use. As you study, recreate sample projects like financial reports, sales invoices, and performance dashboards. Try using formulas, pivot tables, and charting tools just as you would in a real-world scenario. This approach solidifies your theoretical understanding and ensures you&#8217;re capable of applying your knowledge in a live environment, just like you\u2019ll need to during the exam.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.skilr.com\/microsoft-excel-excel-and-excel-2019-mo-200-free-practice-test\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-4.jpg\" alt=\"Exam MO-200\" class=\"wp-image-893\" srcset=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-4.jpg 961w, https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-4-300x47.jpg 300w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>The MO-200: Microsoft Excel (Office 2019) certification is designed for individuals seeking to validate their proficiency in using the core features and tools within Excel 2019. This exam targets users who are skilled in leveraging Excel to solve real-world problems in business and data environments. Candidates are expected to demonstrate expertise in the following areas:&#8230;<\/p>\n","protected":false},"author":2,"featured_media":888,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[95],"tags":[370,468,366,372,367,466,371,70,465,378,464,467],"class_list":["post-885","page","type-page","status-publish","has-post-thumbnail","hentry","category-microsoft","tag-excel-certification","tag-excel-certification-training","tag-excel-charts","tag-excel-exam-guide","tag-excel-formulas","tag-excel-office-2019","tag-excel-pivot-tables","tag-m4f","tag-microsoft-excel-tutorial","tag-microsoft-office-specialist","tag-mo-200","tag-mo-200-tutorial"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exam MO-200: Microsoft Excel (Office 2019) - Skilr Tutorial<\/title>\n<meta name=\"description\" content=\"Learn essential skills for Exam MO-200: Microsoft Excel (Office 2019) with this comprehensive tutorial covering formulas, charts, and more.\" \/>\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.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exam MO-200: Microsoft Excel (Office 2019) - Skilr Tutorial\" \/>\n<meta property=\"og:description\" content=\"Learn essential skills for Exam MO-200: Microsoft Excel (Office 2019) with this comprehensive tutorial covering formulas, charts, and more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/\" \/>\n<meta property=\"og:site_name\" content=\"Skilr Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-22T07:09:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/\",\"name\":\"Exam MO-200: Microsoft Excel (Office 2019) - Skilr Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg\",\"datePublished\":\"2025-05-22T07:09:47+00:00\",\"dateModified\":\"2025-05-22T07:09:48+00:00\",\"description\":\"Learn essential skills for Exam MO-200: Microsoft Excel (Office 2019) with this comprehensive tutorial covering formulas, charts, and more.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#primaryimage\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg\",\"contentUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg\",\"width\":1000,\"height\":563,\"caption\":\"Exam MO-200: Microsoft Excel (Office 2019)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.skilr.com\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exam MO-200: Microsoft Excel (Office 2019)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#website\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/\",\"name\":\"Skilr Tutorial\",\"description\":\"An Initiative By CTI Jabalpur\",\"publisher\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.skilr.com\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#organization\",\"name\":\"Skilr\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg\",\"contentUrl\":\"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg\",\"width\":330,\"height\":134,\"caption\":\"Skilr\"},\"image\":{\"@id\":\"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exam MO-200: Microsoft Excel (Office 2019) - Skilr Tutorial","description":"Learn essential skills for Exam MO-200: Microsoft Excel (Office 2019) with this comprehensive tutorial covering formulas, charts, and more.","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.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/","og_locale":"en_US","og_type":"article","og_title":"Exam MO-200: Microsoft Excel (Office 2019) - Skilr Tutorial","og_description":"Learn essential skills for Exam MO-200: Microsoft Excel (Office 2019) with this comprehensive tutorial covering formulas, charts, and more.","og_url":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/","og_site_name":"Skilr Tutorial","article_modified_time":"2025-05-22T07:09:48+00:00","og_image":[{"width":1000,"height":563,"url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/","url":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/","name":"Exam MO-200: Microsoft Excel (Office 2019) - Skilr Tutorial","isPartOf":{"@id":"https:\/\/www.skilr.com\/tutorial\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#primaryimage"},"image":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#primaryimage"},"thumbnailUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg","datePublished":"2025-05-22T07:09:47+00:00","dateModified":"2025-05-22T07:09:48+00:00","description":"Learn essential skills for Exam MO-200: Microsoft Excel (Office 2019) with this comprehensive tutorial covering formulas, charts, and more.","breadcrumb":{"@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#primaryimage","url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg","contentUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2025\/05\/Exam-MO-200-Microsoft-Excel-Office-2019-scaled.jpg","width":1000,"height":563,"caption":"Exam MO-200: Microsoft Excel (Office 2019)"},{"@type":"BreadcrumbList","@id":"https:\/\/www.skilr.com\/tutorial\/exam-mo-200-microsoft-excel-office-2019\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.skilr.com\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Exam MO-200: Microsoft Excel (Office 2019)"}]},{"@type":"WebSite","@id":"https:\/\/www.skilr.com\/tutorial\/#website","url":"https:\/\/www.skilr.com\/tutorial\/","name":"Skilr Tutorial","description":"An Initiative By CTI Jabalpur","publisher":{"@id":"https:\/\/www.skilr.com\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.skilr.com\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.skilr.com\/tutorial\/#organization","name":"Skilr","url":"https:\/\/www.skilr.com\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg","contentUrl":"https:\/\/www.skilr.com\/tutorial\/wp-content\/uploads\/2022\/07\/skilr-logo.svg","width":330,"height":134,"caption":"Skilr"},"image":{"@id":"https:\/\/www.skilr.com\/tutorial\/#\/schema\/logo\/image\/"}}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/comments?post=885"}],"version-history":[{"count":4,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/885\/revisions"}],"predecessor-version":[{"id":897,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/pages\/885\/revisions\/897"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/media\/888"}],"wp:attachment":[{"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/media?parent=885"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/categories?post=885"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skilr.com\/tutorial\/wp-json\/wp\/v2\/tags?post=885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}