Update cookies preferences

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 [Paperback / softback]

3.00/5 (1 ratings by Goodreads)
  • Format: Paperback / softback, 704 pages, height x width x depth: 231x183x38 mm, weight: 1179 g
  • Pub. Date: 16-Aug-2021
  • Publisher: Sybex Inc.,U.S.
  • ISBN-10: 111971849X
  • ISBN-13: 9781119718499
Other books in subject:
  • Paperback / softback
  • Price: 56,89 €*
  • * the price is final i.e. no additional discount will apply
  • Regular price: 66,92 €
  • Save 15%
  • This book is not in stock. Book will arrive in about 2-4 weeks. Please allow another 2 weeks for shipping outside Estonia.
  • Quantity:
  • Add to basket
  • Delivery time 4-6 weeks
  • Add to Wishlist
MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide: Word Exam MO-100, Excel Exam MO-200, and PowerPoint Exam MO-300Larger Image
  • Format: Paperback / softback, 704 pages, height x width x depth: 231x183x38 mm, weight: 1179 g
  • Pub. Date: 16-Aug-2021
  • Publisher: Sybex Inc.,U.S.
  • ISBN-10: 111971849X
  • ISBN-13: 9781119718499
Other books in subject:
Permanent link: https://www.kriso.ee/db/9781119718499.html

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. 

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