MO-200: Microsoft Excel (Excel and Excel 2019)
Languages: English, English (Malaysia), Dutch, French, German, Indonesian (Indonesia), Korean, Portuguese (Brazil), Spanish, Italian, Russian, Japanese, Polish, Greek (Greece), Chinese (Simplified), Chinese (Traditional), Arabic (Saudi Arabia)
Retirement date: none
This exam measures competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data entry logs.
Price based on the country in which the exam is proctored.
for Microsoft Excel (Excel and Excel 2019)You need a free license key for Office 2019, Professional, Home and Business 2019. Depending on your model, you can activate the tool for 32-bit and 64-bit. In short, they are focusing on demand.
The quick way to learn Microsoft Excel 2019! This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data. Automated workflow: Excel 2019 now connects better to Microsoft Flow, which allows you to create automated workflows in which data are retrieved from other applications and then stored and/or manipulated in Excel. The dataflow can be further programmed to automatically send to or share those data with other people or third-party applications. Exam MO-200: Microsoft Excel (Excel and Excel 2019) This exam covers the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs. Microsoft Office 2019 for Students and Faculty. Download the all-new Office 2019 for Windows. or Mac, or upgrade from Office 2016, all at little to no cost.
All objectives of the exam are covered in depth so you'll be ready for any question on the exam.
Microsoft have introduced the following new built-in functions in Excel 2019. Note that these functions have been available in Microsoft's subscription service, Office 365, since 2016.
Ms Excel 2019 Online
| Text Functions | ||||||||
|---|---|---|---|---|---|---|---|---|
| CONCAT | Joins together two or more text strings. Concat Function Example
In the above spreadsheet on the right, the text strings in cells A1, B1 and C1 can be joined together, using the Concat function, as follows: which gives the resulting text string C:UsersJeff | |||||||
| TEXTJOIN | Joins together two or more text strings, separated by a delimiter. Textjoin Function Example
In the above spreadsheet on the right, the text strings in cells A1, B1 and C1 can be joined together, separated by the delimiter ', using the Textjoin function as follows: which gives the resulting text string C:UsersJeff | |||||||
| Logical Functions | ||||||||
|---|---|---|---|---|---|---|---|---|
| IFS | Tests a number of supplied conditions and returns a result corresponding to the first condition that evaluates to TRUE. Ifs Function Example
In the above spreadsheet on the right, the ifs function can be used to divide the value in cell A1 by the first non-zero value in cells B1-C1: which gives the result 10. (I.e. the value in cell A1 divided by the value in cell C1.) | |||||||
| SWITCH | Compares a number of supplied values to a supplied test expression and returns a result corresponding to the first value that matches the test expression. Switch Function Example
In the above spreadsheet on the right, the switch function is used to return a season relating to the number in cell A1. =SWITCH( A1, 1, 'Spring', 2, 'Summer', 3, 'Autumn', 4, 'Winter' ) which gives the result 'Summer'. | |||||||
Microsoft Excel Versions
| Statistical Functions | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MAXIFS | Returns the largest value from a subset of values in a list that are specified according to one or more criteria. Maxifs Function Example
In the above spreadsheet on the right, the maximum exam score recorded in Group 1, can be found by using the Maxifs function as follows: which gives the result 77%. | |||||||||||||||||||||||||||||||||||||||
| MINIFS | Returns the smallest value from a subset of values in a list that are specified according to one or more criteria. Minifs Function Example
In the above spreadsheet on the right, the minimum exam score recorded in Ggroup 2, can be found by using the Minifs function as follows: which gives the result 73%. | |||||||||||||||||||||||||||||||||||||||
Return to the ExcelFunctions.net Home Page