<i>MCA Microsoft Office Specialist Excel Study Guide </i>is your roadmap to preparing for taking Exam MO-200 and earning the Excel Associate (Excel and Excel 2019) certification. The following objectives are covered:<br /> <ul> <li>Manage worksheets and workbooks</li> <li>Manage data cells and ranges</li> <li>Manage tables and table data</li> <li>Perform operations by using formulas and functions</li> <li>Manage charts</li> </ul> <p>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.<br /><br />Readers will also have access to Sybex’s superior online test bank, includng hundreds of practice questions, flashcards, and a glossary of important terms.</p>
