MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide. Eric Butow
the PIN, return to www.wiley.com/go/sybextestprep, find your book, and click register, or login and follow the link to register a new account or add this book to an existing account.
Exam objectives are subject to change at any time without prior notice and at Microsoft’s sole discretion. Please visit the Microsoft Certifications website (https://docs.microsoft.com/en-us/learn/certifications/) for the most current listing of exam objectives.
Objective Map
Objective | Chapter |
Word for Office 365 or Office 2019 | |
Section 1: Manage documents | |
1.1 Navigate within documents | 1 |
1.2 Format documents | 1,2 |
1.3 Save and share documents | 1 |
1.4 Inspect documents for issues | 1 |
Section 2: Insert and format text, paragraphs, and sections | |
2.1 Insert text and paragraphs | 2,5 |
2.2 Format text and paragraphs | 2,3,4,5 |
2.3 Create and configure document sections | 2 |
Section 3: Manage tables and lists | |
3.1 Create tables | 3 |
3.2 Modify tables | 3 |
3.3 Create and modify lists | 3 |
Section 4: Create and manage references | |
4.1 Create and manage reference elements | 4 |
4.2 Create and manage reference tables | 4 |
Section 5: Insert and format graphic elements | |
5.1 Insert illustrations and text boxes | 5 |
5.2 Format illustrations and text boxes | 5 |
5.3 Add text to graphic elements | 5 |
5.4 Modify graphic elements | 5 |
Section 6: Manage document collaboration | |
6.1 Add and manage comments | 6 |
6.2 Manage change tracking | 6 |
Excel for Office 365 or Office 2019 | |
Section 1: Manage worksheets and workbooks | |
1.1 Import data into workbooks | 7 |
1.2 Navigate within workbooks | 7 |
1.3 Format worksheets and workbooks | 7,8,9,10,11 |
1.4 Customize options and views | 7 |
1.5 Configure content for collaboration | 7 |
Section 2: Manage data cells and ranges | |
2.1 Manipulate data in worksheets | 8 |
2.2 Format cells and ranges
|