Details

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

Word Exam MO-100, Excel Exam MO-200, and PowerPoint Exam MO-300
1. Aufl.

von: Eric Butow
38,99 €
Verlag:	Wiley
Format:	PDF
Veröffentl.:	02.06.2021
ISBN/EAN:	9781119718512
Sprache:	englisch
Anzahl Seiten:	704

In den Warenkorb

Als Gutschein

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

Titelbeschreibung

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: <ul> <li>Fully updated information for the latest Microsoft Office Specialist certification exams covering Microsoft Office 365 </li> <li>Access to new career opportunities with a professional certification that’s relevant to virtually any office environment </li> <li>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 </li> </ul> 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.

Inhaltsverzeichnis

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 Including Pictures 120 Inserting 3D Models 121 Adding SmartArt Graphics 122 Placing Screenshots and Screen Clippings 123 Inserting Text Boxes 125 Formatting Illustrations and Text Boxes 127 Applying Artistic Effects 127 Adding Picture Effects and Picture Styles 128 Removing Picture Backgrounds 131 Formatting Graphic Elements 132 Setting Up SmartArt Graphics 134 Working with 3D Models 136 Adding and Organizing Text 137 Formatting Text in Text Boxes 137 Adding Text in Shapes 139 Changing SmartArt Graphic Content 141 Modifying Graphic Elements 142 Positioning Objects 142 Wrapping Text Around Objects 143 Adding Alt Text to Objects 146 Summary 148 Key Terms 148 Exam Essentials 148 Review Questions 149 Chapter 6 Working with Other Users on Your Document 151 Adding Comments 152 Inserting Comments 152 Reviewing and Replying to Comments 153 Resolving Comments 154 Deleting Comments 155 Tracking Your Changes 157 Turning On Track Changes 157 Reviewing Tracked Changes 158 Accepting and Rejecting Tracked Changes 159 Locking and Unlocking Change Tracking 162 Summary 165 Key Terms 165 Exam Essentials 165 Review Questions 166 Part II Excel Exam MO-200 169 Chapter 7 Managing Worksheets and Workbooks 171 Importing Data into Workbooks 172 Bringing in Data from TXT Files 173 Importing Data from CSV Files 174 Navigating Within Workbooks 178 Searching for Data Within a Workbook 178 Navigating to Named Cells, Ranges, or Workbook Elements 180 Inserting and Removing Hyperlinks 182 Formatting Worksheets and Workbooks 190 Modifying Page Settings 190 Adjusting Row Height and Column Width 192 Customizing Headers and Footers 200 Customizing Options and Views 206 Customizing the Quick Access Toolbar 207 Displaying and Modifying Workbook Content in Different Views 211 Freezing Worksheet Rows and Columns 214 Changing Window Views 216 Modifying Basic Workbook Properties 218 Displaying Formulas 219 Configuring Content for Collaboration 222 Setting a Print Area 222 Saving Workbooks in Other File Formats 224 Configuring Print Settings 224 Inspecting Workbooks for Issues 225 Summary 229 Key Terms 229 Exam Essentials 229 Review Questions 231 Chapter 8 Using Data Cells and Ranges 233 Manipulating Data in Worksheets 234 Pasting Data by Using Special Paste Options 234 Filling Cells by Using Auto Filling 238 Inserting and Deleting Multiple Columns or Rows 240 Adding and Removing Cells 242 Formatting Cells and Ranges 245 Merging and Unmerging Cells 245 Modifying Cell Alignment, Orientation, and Indentation 246 Formatting Cells by Using Format Painter 249 Wrapping Text Within Cells 250 Using Number Formatting 252 Applying Cell Formatting from the Format Cells Dialog Box 253 Working with Cell Styles 254 Clearing Cell Formatting 256 Defining and Referencing Named Ranges 258 Defining a Named Range 258 Naming a Table 263 Summarizing Data Visually 265 Inserting Sparklines 265 Applying Built-In Conditional Formatting 269 Removing Conditional Formatting 271 Summary 275 Key Terms 275 Exam Essentials 275 Review Questions 277 Chapter 9 Working with Tables and Table Data 279 Creating and Formatting Tables 280 Creating Excel Tables from Cell Ranges 280 Applying Table Styles 282 Converting Tables to Cell Ranges 283 Modifying Tables 285 Adding or Remove Table Rows and Columns 285 Configuring Table Style Options 288 Inserting and Configuring Total Rows 289 Filtering and Sorting Table Data 292 Filtering Records 292 Sorting Data by Multiple Columns 296 Summary 298 Key Terms 299 Exam Essentials 299 Review Questions 300 Chapter 10 Performing Operations by Using Formulas and Functions 303 Inserting References 304 Inserting Relative, Absolute, and Mixed References 305 Referencing Named Ranges and Named Tables in Formulas 307 Calculating and Transforming Datas 310 Performing Calculations Using the AVERAGE(), MAX(), MIN(), and SUM() Functions 310 Perform Conditional Operations by Using the IF() Function 321 Formatting and Modifying Text 325 Formatting Text Using the RIGHT(), LEFT(), and MID() Functions 325 Formatting Text Using the UPPER(), LOWER(), and LEN() Functions 329 Formatting Text Using the CONCAT() and TEXTJOIN() Functions 333 Summary 336 Key Terms 337 Exam Essentials 337 Review Questions 338 Chapter 11 Managing Charts 341 Creating Charts 342 Building Charts 342 Working with Chart Sheets 344 Modifying Charts 348 Adding Data Series to Charts 348 Switching Between Rows and Columns in Source Data 351 Adding and Modifying Chart Elements 352 Formatting Charts 355 Using Chart Layouts 356 Applying Chart Styles 364 Adding Alternative Text to Charts for Accessibility 366 Summary 368 Key Terms 368 Exam Essentials 369 Review Questions 370 Part III PowerPoint Exam MO-300 373 Chapter 12 Creating Presentations 375 Modifying Slide Masters, Handout Masters, and Note Masters 377 Changing the Slide Master Theme or Background 378 Modifying Slide Master Content 383 Creating Slide Layouts 384 Modify Slide Layouts 389 Modifying the Handout Master 393 Modifying the Notes Master 400 Changing Presentation Options and Views 406 Changing the Slide Size 406 Displaying Presentations in Different Views 408 Setting Basic File Properties 410 Configuring Print Settings for Presentations 411 Printing All or Part of a Presentation 411 Printing Notes Pages 413 Printing Handouts 414 Printing in Color, Grayscale, or Black and White 415 Configuring and Presenting Slideshows 417 Creating Custom Slideshows 417 Configuring Slideshow Options 422 Rehearsing Slideshow Timing 423 Setting Up Slideshow Recording Options 427 Presenting Slideshows by Using Presenter View 430 Preparing Presentations for Collaboration 436 Mark Presentations as Final 437 Protecting Presentations by Using Passwords 438 Inspecting Presentations for Issues 439 Adding and Managing Comments 441 Preserving Presentation Content 446 Exporting Presentations to Other Formats 447 Summary 456 Key Terms 457 Exam Essentials 457 Review Questions 459 Chapter 13 Managing Slides 461 Inserting Slides 462 Importing Word Document Outlines 462 Inserting Slides from Another Presentation 465 Inserting Slides and Selecting Slide Layouts 467 Inserting Summary Zoom Slides 469 Duplicating Slides 474 Modifying Slides 475 Hiding and Unhiding Slides 476 Modifying Individual Slide Backgrounds 477 Inserting Slide Headers, Footers, and Page Numbers 480 Ordering and Grouping Slides 484 Creating Sections 484 Modifying the Slide Order 486 Renaming Sections 488 Summary 489 Key Terms 490 Exam Essentials 490 Review Questions 491 Chapter 14 Inserting and Formatting Text, Shapes, and Images 493 Formatting Text 495 Applying Formatting and Styles to Text 495 Formatting Text in Multiple Columns 501 Creating Bulleted and Numbered Lists 502 Inserting Links 504 Inserting Hyperlinks 504 Inserting Section Zoom Links and Slide Zoom Links 505 Inserting and Formatting Images 509 Resizing and Cropping Images 511 Applying Built-In Styles and Effects to Images 513 Inserting Screenshots and Screen Clippings 515 Inserting and Formatting Graphic Elements 518 Inserting and Changing Shapes 518 Drawing by Using Digital Ink 520 Adding Text to Shapes and Text Boxes 523 Resizing Shapes and Text Boxes 525 Formatting Shapes and Text Boxes 527 Applying Built-In Styles to Shapes and Text Boxes 529 Adding Alt Text to Graphic Elements for Accessibility 532 Ordering and Grouping Objects on Slides 534 Ordering Shapes, Images, and Text Boxes 534 Aligning Shapes, Images, and Text Boxes 535 Grouping Shapes and Images 537 Displaying Alignment Tools 538 Summary 539 Key Terms 540 Exam Essentials 540 Review Questions 541 Chapter 15 Inserting Tables, Charts, SmartArt, 3D Models, and Media 543 Inserting and Formatting Tables 544 Creating and Inserting Tables 544 Inserting and Deleting Table Rows and Columns 545 Applying Built-In Table Styles 548 Inserting and Modifying Charts 551 Creating and Inserting Charts 551 Modifying Charts 554 Inserting and Formatting SmartArt Graphics 560 Inserting SmartArt Graphics 560 Converting Lists to SmartArt Graphics 560 Adding and Modifying SmartArt Graphic Content 563 Inserting and Modifying 3D Models 565 Inserting 3D Models 565 Modifying 3D Models 567 Inserting and Managing Media 568 Inserting Audio and Video Clips 568 Creating and Inserting Screen Recordings 576 Configuring Media Playback Options 581 Summary 584 Key Terms 585 Exam Essentials 585 Review Questions 587 Chapter 16 Applying Transitions and Animations 589 Applying and Configuring Slide Transitions 590 Applying Basic and 3D Slide Transitions 590 Configuring Transition Effects 592 Animating Slide Content 596 Animating Text and Graphic Elements 596 Animating 3D Models 606 Configuring Animation Effects 609 Configuring Animation Paths 612 Reordering Animations on a Slide 617 Setting Timing for Transitions 619 Setting Transition Effect Duration 619 Configuring Transition Start and Finish Options 620 Summary 622 Key Terms 622 Exam Essentials 623 Review Questions 624 Appendix Answers to Review Questions 627 Part I: Word Exam MO-100 628 Chapter 1: Working with Documents 628 Chapter 2: Inserting and Formatting Text 628 Chapter 3: Managing Tables and Lists 629 Chapter 4: Building References 630 Chapter 5: Adding and Formatting Graphic Elements 630 Chapter 6: Working with Other Users on Your Document 631 Part II: Excel Exam MO-200 632 Chapter 7: Managing Worksheets and Workbooks 632 Chapter 8: Using Data Cells and Ranges 632 Chapter 9: Working with Tables and Table Data 633 Chapter 10: Performing Operations by Using Formulas and Functions 634 Chapter 11: Managing Charts 634 Part III: PowerPoint Exam MO-300 635 Chapter 12: Creating Presentations 635 Chapter 13: Managing Slides 636 Chapter 14: Inserting and Formatting Text, Shapes, and Images 636 Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media 637 Chapter 16: Applying Transitions and Animations 638 Index 639

Autorenportrait

ABOUT THE AUTHORERIC 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.

Back cover copy

Your complete Guide to preparing for the Microsoft Office Specialist Associate certification examsThe MCA Microsoft Office Specialist Complete Study Guide (Office 365 and Office 2019) is your one-stop resource for complete coverage of the Word MO-100, Excel MO-200, and PowerPoint MO-300 exams. This Sybex Study Guide covers 100% of each exam’s topics and will help you prepare for the exams and a new career in a modern office. Sybex’ efficient and accurate content includes assessment tests that validate and measure exam readiness, objective maps, real-world examples and scenarios, practical exercises, and challenging chapter review questions. You’ll learn the skills you need to confidently complete the exams, succeed on a job interview, or start a new career. Reinforce and retain what you’ve learned with the Sybex online learning environment and test bank, accessible across multiple devices. Get prepared for the Microsoft Office Specialist Associate certification with Sybex.Coverage of 100% of all exam objectives in this Study Guide means you’ll be ready for:<ul><li>Managing text documents, spreadsheets, and presentations</li><li>Inserting and formatting text, formulas, shapes, and images</li><li>Creating tables, lists, and charts</li><li>Adding graphics, 3D models, and SmartArt</li><li>Performing spreadsheet operations using formulas and functions</li><li>Applying transitions and animations to slideshows</li></ul>Interactive learning environmentTake your exam prep to the next level with Sybex’s superior interactive online study tools. To access our interactive 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:<ul><li>Interactive test bank with 3 practice exams 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.</li><li>300 electronic flashcards to reinforce learning and last-minute prep before the exam</li><li>Comprehensive glossary in PDF format gives you instant access to the key terms so you are fully prepared</li></ul>ABOUT THE MICROSOFT OFFICE SPECIALIST ASSOCIATE CERTIFICATIONThe Microsoft Office Specialist Associate certification is the ideal credential for those seeking to demonstrate their understanding of Microsoft Word, Excel, and PowerPoint in a modern office environment. Visit https://docs.microsoft.com/en-us/learn/certifications/microsoft-office-specialist-associate-2019/ for more information.