Eric Butow

MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide (eBook, PDF)

Word Exam MO-100, Excel Exam MO-200, and PowerPoint Exam MO-300

• Format: PDF

Produktbeschreibung

Master one of the most essential skill sets for the contemporary office As Microsoft Office becomes ever more ubiquitous in modern offices across the world, competence and familiarity with its intricacies is more important than ever. Now you can set yourself apart from the pack and prove your skills with the Microsoft Office Specialist certification. The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide : Word Associate Exam MO-100, Excel Associate Exam MO-200, and PowerPoint Associate Exam MO-300 delivers a comprehensive roadmap to achieving the certification with easy-to-follow instruction for each of the three required proficiencies: Word, Excel, and PowerPoint. You'll enjoy access to chapter review questions and Exam Essentials, a feature that identifies critical subject areas. Discover practical, hands-on exercises that prepare you for real-world roles and jobs, and gain valuable experience as you reinforce key Microsoft Office skills that you'll be expected to demonstrate in job interviews and your day-to-day professional life. Learn to manage and create text documents in Word, perform operations with formulas in Excel, and create engaging slideshows and presentations in PowerPoint. This practical book also provides: * Fully updated information for the latest Microsoft Office Specialist certification exams covering Microsoft Office 365 * Access to new career opportunities with a professional certification that's relevant to virtually any office environment * Access to the Sybex online study tools, with chapter review questions, full-length practice exams, hundreds of electronic flashcards, and a glossary of key terms The MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide offers crystal-clear organization, comprehensive coverage, and easy-to-understand instruction. It's perfect for anyone who hopes to prove their skills with the Microsoft Office Specialist certification or to improve their mastery of Microsoft Office 365.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: John Wiley & Sons
• Seitenzahl: 704
• Erscheinungstermin: 2. Juni 2021
• Englisch
• ISBN-13: 9781119718512
• Artikelnr.: 62077194

Autorenporträt

ABOUT THE AUTHOR ERIC BUTOW is the author of 41 books on technology topics and has developed and taught networking, computing, and usability courses for Ed2Go, Virtual Training Company, California State University, Sacramento, and Udemy. He has been using Office since 1994. He's served as a technical writer for companies like Intel, Wells Fargo, Cisco Systems, and Hewlett-Packard. He is the founder and owner of Butow Communications Group in Jackson, California.

Inhaltsangabe

Introduction xxi

Assessment Test xxviii

Answers to Assessment Test xl

Part I Word Exam MO-100 1

Chapter 1 Working with Documents 3

Navigating Within Documents 4

Searching for Text 4

Linking to Locations Within Documents 8

Moving to Specific Locations and Objects in Documents 9

Showing and Hiding Formatting Symbols and Hidden Text 10

Formatting Documents 13

Setting Up Document Pages 14

Applying Style Settings 15

Inserting and Modifying Headers and Footers 17

Configuring Page Background Elements 18

Saving and Sharing Documents 20

Saving Documents in Alternative File Formatting 20

Changing Basic Document Properties 21

Modifying Print Settings 23

Sharing Documents Electronically 24

Inspecting Documents for Issues 26

Locating and Removing Hidden Properties and Personal Information 26

Finding and Fixing Accessibility Issues 28

Locating and Correcting Compatibility Issues 29

Summary 30

Key Terms 31

Exam Essentials 31

Review Questions 33

Chapter 2 Inserting and Formatting Text 35

Adding and Replacing Text 36

Finding and Replacing Text 36

Inserting Symbols and Special Characters 40

Formatting Text and Paragraphs 42

Adding Text Effects 42

Applying Formatting by Using Format Painter 43

Setting Line and Paragraph Spacing and Indentation 43

Applying Built-In Styles to Text 46

Clearing Formatting 47

Creating and Configuring Document Sections 50

Formatting Text in Multiple Columns 50

Inserting Page, Section, and Column Breaks 52

Changing Page Setting Options for a Section 53

Summary 56

Key Terms 57

Exam Essentials 57

Review Questions 58

Chapter 3 Managing Tables and Lists 61

Creating Tables 62

Converting Text to Tables 64

Switching Tables to Text 65

Creating Tables by Specifying Rows and Columns 66

Modifying Tables 68

Sorting Table Data 68

Configuring Cell Margins and Spacing 70

Merging and Splitting Cells 73

Resizing Tables, Rows, and Columns 75

Splitting Tables 80

Configuring a Repeating Row Header 82

Creating and Formatting Lists 85

Structuring Paragraphs as Numbered and Bulleted Lists 85

Changing Bullet Characters and Number Formatting 86

Defining Custom Bullet Characters and Number Formatting 88

Increasing and Decreasing List Levels 91

Restarting and Continuing List Numbering 92

Setting Starting Number Values 94

Summary 95

Key Terms 96

Exam Essentials 96

Review Questions 97

Chapter 4 Building References 99

Creating and Managing Referencing Elements 100

Inserting Footnotes and Endnotes 100

Modifying Footnote and Endnote Properties 103

Creating and Modifying Bibliography Citation Sources 104

Inserting Citations for Bibliographies 107

Working with Referencing Tables 109

Inserting Tables of Contents 109

Customizing Tables of Contents 110

Adding Bibliographies 112

Summary 113

Key Terms 113

Exam Essentials 114

Review Questions 115

Chapter 5 Adding and Formatting Graphic Elements 117

Inserting Illustrations and Text Boxes 118

Adding Shapes 118

Inc