Prepare with the best for your Microsoft Office 2019 Excel Certification Exam. With a focus on skill assessment and a performance-based format this practice exam is sure to prepare you for your certification and provide you a competitive edge in today's academic and professional environments.

Successful candidates for the Microsoft Office Specialist Excel 2019 certification exam will have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principle features of Excel 2019. Candidates will 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.

GMetrix has prepared exam-focused training to help you be successful in passing your Office 2019 exams. The Office 2019 practice test products map directly to exam objectives. In addition to "standard mode," Office 2019 practice exams include Project Mode which emulates real-life usage similar to the project mode of the certification exams.

Topics

• Create Worksheets and Workbooks
• Navigate in Worksheets and Workbooks
• Format Worksheets and Workbooks
• Customize Options and Views for Worksheets and Workbooks
• Configure Worksheets and Workbooks for Distribution
• Insert Data in Cells and Ranges
• Format Cells and Ranges
• Summarize and Organize Data
• Create and Manage Tables
• Manage Table Styles and Options
• Filter and Sort a Table
• Summarize Data by using Functions
• Perform Conditional Operations by using Functions
• Format and Modify Text by using Functions
• Create Charts
• Format Charts
• Insert and Format Objects

Includes

• 2 Practice Exams
• 3 Skills Reviews
• 2 Concept Reviews
• Study Guide

Requirements

• Windows Vista, Windows 7, Windows 8, Windows 8.1, or Windows 10
• Full installation of Excel 2019 (not compatible with Office Mobile or Office Online)
• GMetrix SMS current version 6.1 installed
• High-speed Internet connection
• Prior coursework or experience with Excel 2019 is recommended. 

Certification

This practice test bundle is preparation for the official Excel Associate (Excel and Excel 2019) Exam MO-200 certification.