Successful candidates for the Microsoft Office Specialist Excel 2016 certification exam have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They know and demonstrate the correct application of the principle features of Excel 2016. Candidates create and edit a workbook with multiple sheets, and they 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 Official Academic Course (MOAC)
The MOAC courseware for Microsoft Office 2016 system are designed to cover all the learning objectives for the MOS exam (77-727: Excel 2016), which is referred to as its “objective domain.”
- Create and manage worksheets and workbooks (30-35%)
- Manage data cells and ranges (15-20%)
- Create tables (15-20%)
- Perform operations with formulas and functions (10-15%)
- Create charts and objects (15-20%)