MCA Microsoft Office Specialist Excel Study Guideis your roadmap to preparing for taking Exam MO-200 and earning the Excel Associate (Excel and Excel 2019) certification. The following objectives are covered:Manage worksheets and workbooksManage data cells and rangesManage tables and table dataPerform operations by using formulas and functionsManage chartsMajor 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,...