Overview

This practice test is designed to help students master the material covered in the MO-201: Microsoft Excel Expert (Office 2019) certification exam. The test consists of four sections, each focusing on a specific topic: managing workbook options and settings, managing and formatting data, creating advanced formulas and macros, and managing advanced charts and tables. The first section covers how to customize the Ribbon and Excel Options, manage worksheets and workbooks, and use Excel's auditing tools. Students will also learn how to apply protection to worksheets and workbooks, use the Views tools to display data in different ways, and customize the Quick Access Toolbar. In the second section, students will learn how to format data using advanced techniques such as conditional formatting, custom number formats, and data validation. They will also learn how to use Excel's data analysis tools, including scenarios and goal seeking, and how to work with Sparklines and Data Bars to create impactful visualizations. In the third section, students will learn how to create complex formulas and functions using techniques such as nested functions and array formulas. They will also explore how to use Excel's auditing tools and data analysis tools to troubleshoot errors in formulas and functions. Students will also learn how to create macros using the Macro Recorder and the Visual Basic Editor to automate repetitive tasks and increase productivity. In the fourth section, students will learn how to create advanced charts such as combo charts and waterfall charts, and how to use PivotTables, PivotCharts, and Power Query to analyze and visualize data. They will also learn how to manage large datasets efficiently using Excel's data modeling features, including relationships, hierarchies, and DAX formulas. By the end of this practice test, students will be well-prepared to take and pass the MO-201: Microsoft Excel Expert (Office 2019) certification exam. They will have gained a deep understanding of advanced Excel tools and techniques, and be able to use them to increase their productivity and efficiency in the workplace.

Skills

Reviews