MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide
Excel Associate Exam MO-200
Eric Butow
- English
- ePUB (adapté aux mobiles)
- Disponible sur iOS et Android
MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide
Excel Associate Exam MO-200
Eric Butow
Ă propos de ce livre
MCA Microsoft Office Specialist (Office 365 and Office 2019) STUDY GUIDE
Your complete guide to preparing for the Microsoft Office Specialist Excel exam
The MCA Microsoft Office Specialist (Office 365 and Office 2019) Study Guide: Excel Associate Exam MO-200 is your one-stop resource for preparing you to earn the Excel Associate certification. The exam measures your competencies in the fundamentals of Excel. This guide starts you off with an assessment test to measure what you already know and what you still need to learn. Then you move into professional scenarios and examples, practical exercises, and challenging chapter review questions. Finally, you can reinforce and retain what you've learned with the Sybex online learning environment and test bank. Get prepared for the Excel Associate Exam with Sybex.
Coverage of 100% of all exam objectives in this Study Guide means you'll be ready to:
- Create and manage worksheets and workbooks
- Apply formulas and functions
- Populate tables with data
- Create and edit a workbook with multiple sheets
- Add a graphic element to represent data visually
Interactive learning environment
Take your exam prep to the next level with Sybex's superior interactive online study tools. To access our learning environment, simply visit www.wiley.com/go/sybextestprep, register your book to receive your unique PIN, and instantly gain one year of FREE access after activation to:
- Interactive test bank with a practice exam to help you identify areas where further review is needed. Get more than 90% of the answers correct, and you're ready to take the certification exam.
- 100 electronic flashcards to reinforce learning and last-minute prep before the exam.
- Comprehensive glossary in PDF format gives you instant access to the key terms so you are fully prepared.
Foire aux questions
Informations
Chapter 1
Managing Worksheets and Workbooks
- Manage worksheets and workbooks
- Import data into workbooks
- Import data from .txt files
- Import data from .csv files
- Navigate within workbooks
- Search for data within a workbook
- Navigate to named cells, ranges, or workbook elements
- Insert and remove hyperlinks
- Format worksheets and workbooks
- Modify page setup
- Adjust row height and column width
- Customize headers and footers
- Customize options and views
- Customize the Quick Access toolbar
- Display and modify workbook content in different views
- Freeze worksheet rows and columns
- Change window views
- Modify basic workbook properties
- Display formulas
- Configure content for collaboration
- Set a print area
- Save workbooks in alternative file formats
- Configure print settings
- Inspect workbooks for issues
- Import data into workbooks
Importing Data into Workbooks
.xls
filename extension that dates all the way back to MSâDOS days, so you can obviously open those files. However, if you open an older XLS file, you may experience some issues with formatting..txt
file extension and in commaâseparated values (CSV) format with the .csv
file extension. These two formats are what Microsoft focuses on in the MOâ200 exam..txt
or .csv
extension as you save updates to it.Table des matiĂšres
- Cover
- Table of Contents
- Title Page
- Copyright
- Dedication
- Acknowledgments
- About the Author
- About the Technical Editor
- Table of Exercises
- Introduction
- 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
- Appendix: Answers to Review Questions
- Index
- Online Test Bank
- End User License Agreement