MCA Microsoft Office Specialist Study Guide: Excel Associate Exam MO-200 is your roadmap to preparing for taking the MO-200 exam and earning the Excel Associate (Excel and Excel 2019) certification. The following objectives are covered:
- Manage worksheets and workbooks
- Manage data cells and ranges
- Manage tables and table data
- Perform operations by using formulas and functions
- Manage charts
Major topics include the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. This Study Guide also 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.
Readers will also have access to Sybex’s superior online test bank, includng hundreds of practice questions, flashcards, and a glossary of important terms.
Table of contents
Chapter 1: Managing Worksheets and Workbooks Chapter 2: Using Data Cells and Ranges Chapter 3: Working with Tables and Table Data Chapter 4: Performing Operations by Using Formulas and Functions Chapter 5: Managing Charts