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

Eric Butow

• Herausgeber: John Wiley & Sons
• Kategorie: Wissenschaft und neue Technologien
• Sprache: Englisch

Seitenzahl: 732

Veröffentlichungsjahr: 2021

Beschreibung

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.

Leseprobe

Table of Contents

Cover

Title Page

Copyright

Dedication

Acknowledgments

About the Author

About the Technical Editor

Table of Exercises

Introduction

Interactive Online Learning Environment and TestBank

Objective Map

Assessment  Test

Answers to Assessment  Test

PART I: Word Exam MO‐100

Chapter 1: Working with Documents

Navigating Within Documents

Formatting Documents

Saving and Sharing Documents

Inspecting Documents for Issues

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 2: Inserting and Formatting Text

Adding and Replacing Text

Formatting Text and Paragraphs

Creating and Configuring Document Sections

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 3: Managing Tables and Lists

Creating Tables

Modifying Tables

Creating and Formatting Lists

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 4: Building References

Creating and Managing Referencing Elements

Working with Referencing Tables

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 5: Adding and Formatting Graphic Elements

Inserting Illustrations and Text Boxes

Formatting Illustrations and Text Boxes

Adding and Organizing Text

Modifying Graphic Elements

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 6: Working with Other Users on Your Document

Adding Comments

Tracking Your Changes

Summary

Key Terms

Exam Essentials

Review Questions

PART II: Excel Exam MO‐200

Chapter 7: Managing Worksheets and Workbooks

Importing Data into Workbooks

Navigating Within Workbooks

Formatting Worksheets and Workbooks

Customizing Options and Views

Configuring Content for Collaboration

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 8: Using Data Cells and Ranges

Manipulating Data in Worksheets

Formatting Cells and Ranges

Defining and Referencing Named Ranges

Summarizing Data Visually

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 9: Working with Tables and Table Data

Creating and Formatting Tables

Modifying Tables

Filtering and Sorting Table Data

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 10: Performing Operations by Using Formulas and Functions

Inserting References

Calculating and Transforming Datas

Formatting and Modifying Text

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 11: Managing Charts

Creating Charts

Modifying Charts

Formatting Charts

Summary

Key Terms

Exam Essentials

Review Questions

PART III: PowerPoint Exam MO‐300

Chapter 12: Creating Presentations

Modifying Slide Masters, Handout Masters, and Note Masters

Changing Presentation Options and Views

Configuring Print Settings for Presentations

Configuring and Presenting Slideshows

Preparing Presentations for Collaboration

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 13: Managing Slides

Inserting Slides

Modifying Slides

Ordering and Grouping Slides

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 14: Inserting and Formatting Text, Shapes, and Images

Formatting Text

Inserting Links

Inserting and Formatting Images

Inserting and Formatting Graphic Elements

Ordering and Grouping Objects on Slides

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media

Inserting and Formatting Tables

Inserting and Modifying Charts

Inserting and Formatting SmartArt Graphics

Inserting and Modifying 3D Models

Inserting and Managing Media

Summary

Key Terms

Exam Essentials

Review Questions

Chapter 16: Applying  Transitions and Animations

Applying and Configuring Slide Transitions

Animating Slide Content

Setting Timing for Transitions

Summary

Key Terms

Exam Essentials

Review Questions

Appendix: Answers to Review Questions

Part I: Word Exam MO‐100

Chapter 1: Working with Documents

Chapter 2: Inserting and Formatting Text

Chapter 3: Managing Tables and Lists

Chapter 4: Building References

Chapter 5: Adding and Formatting Graphic Elements

Chapter 6: Working with Other Users on Your Document

Part II: Excel Exam MO‐200

Chapter 7: Managing Worksheets and Workbooks

Chapter 8: Using Data Cells and Ranges

Chapter 9: Working with Tables and Table Data

Chapter 10: Performing Operations by Using Formulas and Functions

Chapter 11: Managing Charts

Part III: PowerPoint Exam MO‐300

Chapter 12: Creating Presentations

Chapter 13: Managing Slides

Chapter 14: Inserting and Formatting Text, Shapes, and Images

Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media

Chapter 16: Applying Transitions and Animations

Index

Online Test Bank

Register and Access the Online Test Bank

End User License Agreement

List of Illustrations

Chapter 1

FIGURE 1.1 Navigation pane

FIGURE 1.2 List of search results

FIGURE 1.3 Find And Replace dialog box

FIGURE 1.4 The Navigation Pane check box

FIGURE 1.5 Hyperlink dialog box

FIGURE 1.6 Go To tab

FIGURE 1.7 Show/Hide ¶ icon

FIGURE 1.8 Font dialog box

FIGURE 1.9 Word Options dialog box

FIGURE 1.10 Page Setup section

FIGURE 1.11 Design ribbon theme tiles

FIGURE 1.12 Styles pane

FIGURE 1.13 Header & Footer menu

FIGURE 1.14 Page Background section

FIGURE 1.15 Save As screen

FIGURE 1.16 Document properties list

FIGURE 1.17 Print screen

FIGURE 1.18 Share screen

FIGURE 1.19 Document Inspector dialog box

FIGURE 1.20 Accessibility panel

FIGURE 1.21 Microsoft Word Compatibility Checker dialog box

Chapter 2

FIGURE 2.1 First instance of the word “AutoFit” highlighted

FIGURE 2.2 Find And Replace dialog box

FIGURE 2.3 Symbol window

FIGURE 2.4 Text Effects menu

FIGURE 2.5 Format Painter icon

FIGURE 2.6 Line And Paragraph Spacing menu

FIGURE 2.7 Down arrow

FIGURE 2.8 Menu with all style tiles

FIGURE 2.9 Clear Formatting option

FIGURE 2.10 More icon

FIGURE 2.11 Columns menu

FIGURE 2.12 Breaks icon

FIGURE 2.13 Page Setup options

FIGURE 2.14 Page Number menu

FIGURE 2.15 Borders And Shading dialog box

FIGURE 2.16 Built‐in footer style

Chapter 3

FIGURE 3.1 The selected table cells

FIGURE 3.2 Convert Text To Table dialog box

FIGURE 3.3 Insert Table menu option

FIGURE 3.4 Insert Table dialog box

FIGURE 3.5 Sort icon

FIGURE 3.6 Sort dialog box

FIGURE 3.7 The reordered table rows

FIGURE 3.8 Double‐headed arrow icon

FIGURE 3.9 Table Options dialog box

FIGURE 3.10 Merge Cells menu option

FIGURE 3.11 Split Cells dialog box

FIGURE 3.12 Table Row Height box

FIGURE 3.13 AutoFit drop‐down list

FIGURE 3.14 Double‐headed arrow cursor

FIGURE 3.15 Selected columns

FIGURE 3.16 Distribute Columns icon

FIGURE 3.17 Cursor on third row

FIGURE 3.18 Split Table icon

FIGURE 3.19 Repeat Header Rows icon

FIGURE 3.20 Repeat At Header Row

FIGURE 3.21 Bullets and Numbering icons

FIGURE 3.22 Bullet style tiles

FIGURE 3.23 Number style tiles

FIGURE 3.24 Define New Bullet dialog box

FIGURE 3.25 Define New Number Format dialog box

FIGURE 3.26 Change List Level menu

FIGURE 3.27 Set Numbering Value menu option

FIGURE 3.28 Set Numbering Value dialog box

FIGURE 3.29 Continue Numbering option

FIGURE 3.30 Restart At 1 menu option

Chapter 4

FIGURE 4.1 Insert Footnote option

FIGURE 4.2 Insert Endnote icon

FIGURE 4.3 Pop‐up menu for changing the footnote style

FIGURE 4.4 Writing styles list

FIGURE 4.5 Create Source dialog box

FIGURE 4.6 Citation drop‐down menu

FIGURE 4.7 Added citation in drop‐down list

FIGURE 4.8 TOC styles menu

FIGURE 4.9 TOC styles in the Built‐In menu

FIGURE 4.10 Bibliography styles

Chapter 5

FIGURE 5.1 The shapes drop‐down list

FIGURE 5.2 Pictures drop‐down menu

FIGURE 5.3 Category tiles

FIGURE 5.4 3D model category list

FIGURE 5.5 SmartArt categories

FIGURE 5.6 Screenshots drop‐down list

FIGURE 5.7 Capture area

FIGURE 5.8 Text box styles

FIGURE 5.9 The effects tiles

FIGURE 5.10 Offset: Center shadow style applied to the picture

FIGURE 5.11 Picture Styles section

FIGURE 5.12 Removed background

FIGURE 5.13 Shape Format ribbon

FIGURE 5.14 Picture Format ribbon

FIGURE 5.15 Picture Format ribbon

FIGURE 5.16 Designing an organizational chart using SmartArt

FIGURE 5.17 The Rotate icon

FIGURE 5.18 Text effects options in the WordArt Styles section

FIGURE 5.19 Text appearance options in the Text section

FIGURE 5.20 Shape Format ribbon

FIGURE 5.21 Text in an organizational chart

FIGURE 5.22 Layout Options menu

FIGURE 5.23 Text Wrapping tab in Layout dialog box

FIGURE 5.24 Alt Text pane

Chapter 6

FIGURE 6.1 A new comment

FIGURE 6.2 The next comment

FIGURE 6.3 Resolved comment

FIGURE 6.4 Deleting a comment

FIGURE 6.5 Track Changes icon

FIGURE 6.6 Previous and Next options

FIGURE 6.7 Markup drop‐down menu

FIGURE 6.8 Accept menu

FIGURE 6.9 Reject menu

FIGURE 6.10 Track Changes drop‐down menu

FIGURE 6.11 Unlock Password dialog box

Chapter 7

FIGURE 7.1 Text Import Wizard dialog box

FIGURE 7.2 Get & Transform section

FIGURE 7.3 Import Data dialog box

FIGURE 7.4 Preview dialog box

FIGURE 7.5 Find And Replace dialog box

FIGURE 7.6 The Define Name menu option

FIGURE 7.7 Go To dialog box

FIGURE 7.8 The Link icon

FIGURE 7.9 The Insert Hyperlink dialog box

FIGURE 7.10 The Place In This Document menu option

FIGURE 7.11 A list of recently opened files

FIGURE 7.12 Browsed Pages list

FIGURE 7.13 E‐mail Address menu option

FIGURE 7.14 Edit Hyperlink dialog box

FIGURE 7.15 The Remove Hyperlink option in the context menu

FIGURE 7.16 Page Setup section options

FIGURE 7.17 Column Width option

FIGURE 7.18 AutoFit Column Width option

FIGURE 7.19 Keep Source Column Widths icon

FIGURE 7.20 Default Width option

FIGURE 7.21 The resize mouse pointer between two column headings

FIGURE 7.22 Row Height option

FIGURE 7.23 AutoFit Row Height option

FIGURE 7.24 The resize mouse pointer between two row headings

FIGURE 7.25 Header & Footer icon

FIGURE 7.26 Header element drop‐down list

FIGURE 7.27 Header & Footer Elements section

FIGURE 7.28 Page Setup dialog box

FIGURE 7.29 The new icon in the Quick Access Toolbar

FIGURE 7.30 Customize Quick Access Toolbar drop‐down menu

FIGURE 7.31 The Quick Access Toolbar below the ribbon

FIGURE 7.32 Reset button in Excel Options dialog box

FIGURE 7.33 Zoom dialog box

FIGURE 7.34 Custom Views icon

FIGURE 7.35 Add View dialog box

FIGURE 7.36 The selected view in the list is at the top.

FIGURE 7.37 Freeze Panes drop‐down menu

FIGURE 7.38 Page Break Preview view

FIGURE 7.39 Page Layout view

FIGURE 7.40 Info screen

FIGURE 7.41 Protect Sheet option

FIGURE 7.42 Protect Sheet dialog box

FIGURE 7.43 Set Print Area option

FIGURE 7.44 A partial list of file formats

FIGURE 7.45 Print screen

FIGURE 7.46 Document Inspector dialog box

Chapter 8

FIGURE 8.1 The Paste drop‐down menu

FIGURE 8.2 Paste Special dialog box

FIGURE 8.3 Pop‐up box shows what value you will fill.

FIGURE 8.4 Inserted columns

FIGURE 8.5 Inserted rows

FIGURE 8.6 Insert Sheet Columns menu option

FIGURE 8.7 Insert Sheet Rows menu option

FIGURE 8.8 Merge options in the drop‐down menu

FIGURE 8.9 Align Left, Align Center, and Align Right icons

FIGURE 8.10 Orientation drop‐down menu

FIGURE 8.11 Format Cells dialog box

FIGURE 8.12 Format Painter icon

FIGURE 8.13 Wrap Text option

FIGURE 8.14 Number format options

FIGURE 8.15 Format Cells option

FIGURE 8.16 Format Cells dialog box

FIGURE 8.17 Cell Styles drop‐down list

FIGURE 8.18 Clear drop‐down list

FIGURE 8.19 Define Name option

FIGURE 8.20 New Name dialog box

FIGURE 8.21 Create From Selection option

FIGURE 8.22 Create Names From Selection dialog box

FIGURE 8.23 Use In Formula drop‐down menu

FIGURE 8.24 Highlighted table name in the Table Name Box

FIGURE 8.25 Highlighted table in the Name Box

FIGURE 8.26 The three Sparkline icons

FIGURE 8.27 The selected cell range

FIGURE 8.28 Sparkline menu ribbon

FIGURE 8.29 Quick Analysis icon

FIGURE 8.30 Quick Analysis drop‐down menu

FIGURE 8.31 Clear Rules From Entire Sheet option

FIGURE 8.32 Clear Rules From Selected Cells option

FIGURE 8.33 Go To Special dialog box

Chapter 9

FIGURE 9.1 Table styles in the Format As Table drop‐down menu

FIGURE 9.2 Format As Table dialog box

FIGURE 9.3 Highlighted default name in the New Table Style dialog box

FIGURE 9.4 Format Cells dialog box

FIGURE 9.5 Convert To Range menu option

FIGURE 9.6 Resize Table option

FIGURE 9.7 The reordered table rows

FIGURE 9.8 The Delete Table Rows and Delete Table Columns options

FIGURE 9.9 Table Style Options section check boxes

FIGURE 9.10 Total Row check box

FIGURE 9.11 Sum option in drop‐down menu

FIGURE 9.12 Filter drop‐down menu

FIGURE 9.13 The filtered table shows one row that contains the cell.

FIGURE 9.14 Sort & Filter drop‐down menu

FIGURE 9.15 Sort dialog box

Chapter 10

FIGURE 10.1 Relative cell reference

FIGURE 10.2 Absolute cell reference

FIGURE 10.3 Mixed cell reference

FIGURE 10.4 Absolute reference in the Formula Bar

FIGURE 10.5 The formula in the Formula Bar

FIGURE 10.6 The average of all five numbers

FIGURE 10.7 Average of five numbers in the cell

FIGURE 10.8 The calculated

MAX

result in the cell and the formula in the For...

FIGURE 10.9 The calculated

MIN

result in the cell and the formula in the For...

FIGURE 10.10 The calculated

SUM

result in the cell and the formula in the Fo...

FIGURE 10.11 The count result in the cell and the formula in the Formula Bar...

FIGURE 10.12 The

COUNTA

results in the cell and the formula in the Formula B...

FIGURE 10.13 The calculated

COUNTBLANK

result in the cell and formula in the...

FIGURE 10.14 The

FALSE

result in the cell with the formula in the Formula Ba...

FIGURE 10.15 The results of the formula in column R

FIGURE 10.16 The last two letters in cell A4

FIGURE 10.17 The first two letters in cell A6

FIGURE 10.18 The three characters in cell A11

FIGURE 10.19 All uppercase text in column C

FIGURE 10.20 All lowercase text in column C

FIGURE 10.21 Length in characters in column C

FIGURE 10.22 Combined text with

CONCAT()

function in the Formula Bar

FIGURE 10.23 The combined text with spaces between each text string

Chapter 11

FIGURE 11.1 The Recommended Charts icon in the Insert ribbon

FIGURE 11.2 The Insert Chart dialog box

FIGURE 11.3 The Column category in the All Charts tab

FIGURE 11.4 The chart in the worksheet

FIGURE 11.5 Move Chart icon in the Chart Design ribbon

FIGURE 11.6 Move Chart dialog box

FIGURE 11.7 The chart in a new tab

FIGURE 11.8 The updated chart and expanded selection area in the table

FIGURE 11.9 Select Data Source dialog box and selected table cells

FIGURE 11.10 Updated chart in chart sheet

FIGURE 11.11 Row titles in the horizontal axis

FIGURE 11.12 Chart elements list

FIGURE 11.13 Trend line for teddy bears

FIGURE 11.14 Excel previews the layout in the chart.

FIGURE 11.15 Format ribbon sections

FIGURE 11.16 Current Selection section

FIGURE 11.17 Insert Shapes section

FIGURE 11.18 Shape Styles section

FIGURE 11.19 WordArt Styles section

FIGURE 11.20 Arrange section

FIGURE 11.21 Size section

FIGURE 11.22 The preview of the style in the chart

FIGURE 11.23 Six swatch colors in the selected swatch group

FIGURE 11.24 Alt Text pane

Chapter 12

FIGURE 12.1 Slide Master option in the Master Views section

FIGURE 12.2 Slide Master screen

FIGURE 12.3 Theme tiles in the drop‐down list

FIGURE 12.4 Background tiles in the drop‐down list

FIGURE 12.5 Format Background pane

FIGURE 12.6 Master Layout icon in the ribbon

FIGURE 12.7 Master Layout dialog box

FIGURE 12.8 Insert Layout icon

FIGURE 12.9 Eight content type options in the drop‐down menu

FIGURE 12.10 Rename Layout dialog box

FIGURE 12.11 Delete icon in Slide Master ribbon

FIGURE 12.12 Title and Footers check boxes

FIGURE 12.13 Color scheme drop‐down list

FIGURE 12.14 Font scheme drop‐down list

FIGURE 12.15 Effects drop‐down list

FIGURE 12.16 Hide Background Graphics check box

FIGURE 12.17 The Handout Master option

FIGURE 12.18 Handout Master ribbon

FIGURE 12.19 Slides Per Page drop‐down list

FIGURE 12.20 Color scheme drop‐down list

FIGURE 12.21 Font schemes in the drop‐down list

FIGURE 12.22 Effects drop‐down list

FIGURE 12.23 Background tiles in the drop‐down list

FIGURE 12.24 The Notes Master icon

FIGURE 12.25 Notes Master ribbon

FIGURE 12.26 Color scheme drop‐down list

FIGURE 12.27 Font schemes in the drop‐down list

FIGURE 12.28 Effects drop‐down list

FIGURE 12.29 Background tiles in the drop‐down list

FIGURE 12.30 Slide Size drop‐down list

FIGURE 12.31 Slide Size dialog box

FIGURE 12.32 Icons in the Presentation Views section

FIGURE 12.33 Info screen

FIGURE 12.34 Print options

FIGURE 12.35 Print Layout options

FIGURE 12.36 Notes area below the slide on the page

FIGURE 12.37 Handouts section icons

FIGURE 12.38 Color settings list

FIGURE 12.39 Custom Slide Show option in the ribbon

FIGURE 12.40 Define Custom Show dialog box

FIGURE 12.41 The Link option in the drop‐down menu

FIGURE 12.42 The Place In This Document icon in the Link To section

FIGURE 12.43 Set Up Slide Show option in the ribbon

FIGURE 12.44 Custom Show button

FIGURE 12.45 Set Up Show dialog box

FIGURE 12.46 Rehearse Timings icon in the ribbon

FIGURE 12.47 Recording dialog box

FIGURE 12.48 The time underneath Slide 1

FIGURE 12.49 Manually button

FIGURE 12.50 Clear Timing On Current Slide option

FIGURE 12.51 Record From Beginning option

FIGURE 12.52 Audio recording screen

FIGURE 12.53 Playback bar

FIGURE 12.54 From Beginning icon

FIGURE 12.55 Full Screen View controls

FIGURE 12.56 Presenter View screen

FIGURE 12.57 Monitors area in the Slide Show ribbon

FIGURE 12.58 Mark As Final option

FIGURE 12.59 Encrypt With Password option

FIGURE 12.60 Encrypt Document dialog box

FIGURE 12.61 Document Inspector dialog box

FIGURE 12.62 A new comment

FIGURE 12.63 The next comment

FIGURE 12.64 Deleting a comment

FIGURE 12.65 Print Comments option

FIGURE 12.66 Preserve option and pushpin icon

FIGURE 12.67 Export options on the Export screen

FIGURE 12.68 Save As Type drop‐down list

FIGURE 12.69 Video export options

FIGURE 12.70 Save As Type drop‐down list

FIGURE 12.71 Package For CD button

FIGURE 12.72 Package For CD dialog box

FIGURE 12.73 Create Handouts button

FIGURE 12.74 Send To Microsoft Word dialog box

FIGURE 12.75 Change File Type list

Chapter 13

FIGURE 13.1 Slides From Outline option at the bottom of the drop‐down menu

FIGURE 13.2 Insert Outline dialog box

FIGURE 13.3 The outline appears within the slide.

FIGURE 13.4 Reuse Slides option at the bottom of the drop‐down menu

FIGURE 13.5 The Browse button in the Reuse Slides pane

FIGURE 13.6 The inserted slide

FIGURE 13.7 Slide layout icons in the list

FIGURE 13.8 The Summary Zoom option

FIGURE 13.9 Insert Summary Zoom dialog box

FIGURE 13.10 The Summary Zoom slide in the right pane

FIGURE 13.11 The Duplicate Selected Slides option

FIGURE 13.12 The hidden slide in the left pane

FIGURE 13.13 The Format Background option

FIGURE 13.14 The Format Background pane

FIGURE 13.15 The Header & Footer icon

FIGURE 13.16 The Notes And Handouts tab

FIGURE 13.17 The Footer check box

FIGURE 13.18 The Slide Number check box

FIGURE 13.19 The Add Section option

FIGURE 13.20 Rename Section dialog box

FIGURE 13.21 The section title above the slide

FIGURE 13.22 The selected slide in the left pane

FIGURE 13.23 Rename Section option

FIGURE 13.24 Rename Section dialog box

Chapter 14

FIGURE 14.1 Format Painter icon

FIGURE 14.2 Line Spacing drop‐down menu

FIGURE 14.3 Paragraph dialog box

FIGURE 14.4 Decrease List Level (left) and Increase List Level (right) icons...

FIGURE 14.5 The Quick Styles drop‐down menu

FIGURE 14.6 Clear All Formatting icon

FIGURE 14.7 Add Or Remove Columns menu

FIGURE 14.8 Bullets (left) and Numbering (right) icons

FIGURE 14.9 Insert Hyperlink dialog box

FIGURE 14.10 Selected Summary Zoom slide

FIGURE 14.11 Insert Slide Zoom dialog box

FIGURE 14.12 Thumbnail‐sized slides within the Slide Zoom

FIGURE 14.13 Selected Slide Zoom slide

FIGURE 14.14 Pictures drop‐down menu

FIGURE 14.15 Images dialog box

FIGURE 14.16 Shape Height (top) and Width (bottom) boxes

FIGURE 14.17 The Crop menu option

FIGURE 14.18 The Crop icon in the Picture Format ribbon

FIGURE 14.19 Quick Styles style tiles

FIGURE 14.20 Offset: Center shadow style applied to the picture

FIGURE 14.21 Screenshots drop‐down list

FIGURE 14.22 Capture area

FIGURE 14.23 The shapes drop‐down list

FIGURE 14.24 The Draw ribbon and digital ink on the slide

FIGURE 14.25 Edit Text option

FIGURE 14.26 The text box in the slide

FIGURE 14.27 Height and Width boxes

FIGURE 14.28 Height and Width boxes in the Size section

FIGURE 14.29 Shape Format ribbon

FIGURE 14.30 Font and Paragraph icons in the Home ribbon

FIGURE 14.31 Shape Styles section

FIGURE 14.32 Shape Styles drop‐down list

FIGURE 14.33 WordArt Styles section

FIGURE 14.34 Paragraph section

FIGURE 14.35 Alt Text pane

FIGURE 14.36 Drawing drop‐down list options

FIGURE 14.37 Alignment options

FIGURE 14.38 Group option in the drop‐down menu

FIGURE 14.39 The ruler, gridlines, and guides

Chapter 15

FIGURE 15.1 The selected table cells

FIGURE 15.2 Insert Table menu option

FIGURE 15.3 Insert Table dialog box

FIGURE 15.4 Insertion options in the Rows & Columns section

FIGURE 15.5 Delete options

FIGURE 15.6 Table style tiles

FIGURE 15.7 The Chart icon in the Insert ribbon

FIGURE 15.8 The Column category in the Insert Chart dialog box

FIGURE 15.9 The chart in the worksheet

FIGURE 15.10 The selected chart entries in the spreadsheet window

FIGURE 15.11 The updated chart and expanded selection area in the spreadshee...

FIGURE 15.12 Column titles in the horizontal axis

FIGURE 15.13 Chart elements list

FIGURE 15.14 Trendline for first quarter sales

FIGURE 15.15 SmartArt option in the Insert ribbon

FIGURE 15.16 SmartArt categories

FIGURE 15.17 The Convert To SmartArt drop‐down list

FIGURE 15.18 The Type Your Text Here box

FIGURE 15.19 Designing an organization chart using SmartArt

FIGURE 15.20 3D model category list

FIGURE 15.21 A 3D hat model

FIGURE 15.22 The Rotate icon in the 3D model

FIGURE 15.23 Audio On My PC menu option

FIGURE 15.24 The Insert button in the dialog box

FIGURE 15.25 The audio file in the slide

FIGURE 15.26 Video On My PC menu option

FIGURE 15.27 The Insert button in the dialog box

FIGURE 15.28 The video file in the slide

FIGURE 15.29 Record Audio menu option

FIGURE 15.30 Record Sound dialog box

FIGURE 15.31 The recorded audio file in the slide

FIGURE 15.32 Screen Recording icon

FIGURE 15.33 Control Dock box

FIGURE 15.34 The video recording and playback bar in the slide

FIGURE 15.35 Playback ribbon

FIGURE 15.36 The Playback ribbon for videos

Chapter 16

FIGURE 16.1 The drop‐down list of transition effects

FIGURE 16.2 Preview icon

FIGURE 16.3 Airplane transition in the drop‐down list

FIGURE 16.4 The Left icon in the drop‐down list

FIGURE 16.5 Animation styles in the drop‐down list

FIGURE 16.6 By Paragraph at the bottom of the drop‐down list

FIGURE 16.7 Animation Pane

FIGURE 16.8 Effect Options in the drop‐down menu

FIGURE 16.9 By Letter option in the Animate Text drop‐down menu

FIGURE 16.10 The Wipe style in the drop‐down list

FIGURE 16.11 One By One option in the Sequence section

FIGURE 16.12 The Show Additional Effects Options icon

FIGURE 16.13 The Wipe dialog box

FIGURE 16.14 Level 1 in the Animation Pane

FIGURE 16.15 Remove option in the drop‐down menu

FIGURE 16.16 The Turntable style in the drop‐down list

FIGURE 16.17 The rotating scarf with the Turntable effect applied

FIGURE 16.18 Animation effect options for the Turntable style

FIGURE 16.19 Effect Options menu option

FIGURE 16.20 Wipe dialog box

FIGURE 16.21 The Turns motion path in the drop‐down list

FIGURE 16.22 The truncated graphic in the slide

FIGURE 16.23 Effect Options drop‐down menu

FIGURE 16.24 The Duplicate Selected Slides option

FIGURE 16.25 The Morph icon in the ribbon

FIGURE 16.26 Effects drop‐down menu

FIGURE 16.27 Animation marker on the slide

FIGURE 16.28 The Duration box

FIGURE 16.29 After check box in the Transitions ribbon

Guide

Cover

Table of Contents

Title Page

Copyright

Dedication

Acknowledgments

About the Author

About the Technical Editor

Table of Exercises

Introduction

Begin Reading

Appendix: Answers to Review Questions

Index

Online Test Bank

End User License Agreement

Pages

i

ii

iii

iv

v

xix

xx

xxi

xxii

xxiii

xxiv

xxv

xxvi

xxvii

xxviii

xxix

xxx

xxxi

xxxii

xxxiii

xxxiv

xxxv

xxxvi

xxxvii

xxxviii

xxxix

xl

xli

xlii

xliii

xliv

1

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

169

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

325

326

327

328

329

330

331

332

333

334

335

336

337

338

339

341

342

343

344

345

346

347

348

349

350

351

352

353

354

355

356

357

358

359

360

361

362

363

364

365

366

367

368

369

370

371

373

375

376

377

378

379

380

381

382

383

384

385

386

387

388

389

390

391

392

393

394

395

396

397

398

399

400

401

402

403

404

405

406

407

408

409

410

411

412

413

414

415

416

417

418

419

420

421

422

423

424

425

426

427

428

429

430

431

432

433

434

435

436

437

438

439

440

441

442

443

444

445

446

447

448

449

450

451

452

453

454

455

456

457

458

459

460

461

462

463

464

465

466

467

468

469

470

471

472

473

474

475

476

477

478

479

480

481

482

483

484

485

486

487

488

489

490

491

492

493

494

495

496

497

498

499

500

501

502

503

504

505

506

507

508

509

510

511

512

513

514

515

516

517

518

519

520

521

522

523

524

525

526

527

528

529

530

531

532

533

534

535

536

537

538

539

540

541

542

543

544

545

546

547

548

549

550

551

552

553

554

555

556

557

558

559

560

561

562

563

564

565

566

567

568

569

570

571

572

573

574

575

576

577

578

579

580

581

582

583

584

585

586

587

588

589

590

591

592

593

594

595

596

597

598

599

600

601

602

603

604

605

606

607

608

609

610

611

612

613

614

615

616

617

618

619

620

621

622

623

624

625

627

628

629

630

631

632

633

634

635

636

637

638

639

640

641

642

643

644

645

646

647

648

649

650

651

652

653

654

655

656

657

658

659

660

661

MCAMicrosoft® Office Specialist Complete Study Guide(Office 365 and Office 2019)

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

Eric Butow

Copyright © 2021 by John Wiley & Sons, Inc. All rights reserved.

Published by John Wiley & Sons, Inc., Hoboken, New Jersey.Published simultaneously in Canada.

ISBN: 978‐1‐119‐71849‐9ISBN: 978‐1‐119‐71851‐2 (ebk.)ISBN: 978‐1‐119‐71850‐5 (ebk.)

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per‐copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750‐8400, fax (978) 646‐8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748‐6011, fax (201) 748‐6008, or online at http://www.wiley.com/go/permissions.

Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.

For general information on our other products and services or to obtain technical support, please contact our Customer Care Department within the U.S. at (877) 762‐2974, outside the U.S. at (317) 572‐3993 or fax (317) 572‐4002.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic formats. For more information about Wiley products, visit our web site at www.wiley.com.

Library of Congress Control Number: 2021938302

TRADEMARKS: WILEY and the Wiley logo are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. Microsoft is a registered trademark of Microsoft Corporation. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.

Cover Image: © Getty Images Inc./Jeremy WoodhouseCover Design: Wiley

To my family and friends

Acknowledgments

I have many people to thank, starting with my literary agent, Matt Wagner. He connected me with Sybex to write this book and managed our relationship well. Next, I want to give a shout out to my excellent editing team: Gary Schwartz, Barath Kumar Rajasekaran, Christine O'Connor, and Senior Acquisitions Editor Kenyon Brown.

And, as always, I want to thank my family and friends for their everlasting support. I couldn't write this book without them.

—Eric Butow

About the Author

Eric Butow is the owner of Butow Communications Group (BCG) in Jackson, California. BCG offers website development, online marketing, and technical writing services. Eric is a native Californian who started working with his friend's Apple II Plus and Radio Shack TRS‐80 Model III in 1980 when he lived in Fresno, California. He learned about programming, graphic design, and desktop publishing in the Fresno PC Users Group in his professional career, and when he started BCG in 1994.

Eric has written 40 other technical books as an author, co‐author or, in one case, as a ghostwriter. Most of Eric's works were written for the general book market, but some were written for specific clients including HP and F5 Networks. Two of his books have been translated into Chinese and Italian. Eric's most recent books are Programming Interviews for Dummies (For Dummies, 2019) with John Sonmez, Ultimate Guide to Social Media Marketing (Entrepreneur Press, 2020) with Herman, Liu, Robinson, and Allton, and Instagram for Business for Dummies Second Edition (For Dummies, 2021) with Jennifer Herman and Corey Walker.

Upon his graduation from California State University, Fresno in 1996 with a master's degree in communication, Eric moved to Roseville, California, where he lived for 13 years. Eric continued to build his business and worked as a technical writer for a wide variety of businesses from startups to large companies including Intel, Wells Fargo Wachovia, TASQ Technology, Cisco Systems, and Hewlett‐Packard. Many of those clients required their technical writers to know Microsoft PowerPoint, which Eric has used since the early 1990s. From 1997–1999, during his off‐time, Eric produced 30 issues of Sacra Blue, the award‐winning monthly magazine of the Sacramento PC Users Group.

When Eric isn't working in (and on) his business or writing books, you can find him enjoying time with friends, walking around the historic Gold Rush town of Jackson, and helping his mother manage her infant and toddler daycare business.

About the Technical Editor

Kristen Merritt is an experienced technical editor who has reviewed books for several publishers, including Wiley and Microsoft Press. Kristen spent 12 years in technical sales, and she is currently employed as a digital marketer.

Table of Exercises

Exercise 1.1

Navigating and Modifying Text in a Document

Exercise 1.2

Setting Up Your Document

Exercise 1.3

Changing the File Type and Sharing Your Document

Exercise 1.3

Checking Out Your Document

Exercise 2.1

Finding and Replacing Text

Exercise 2.2

Changing a Paragraph Format

Exercise 2.3

Inserting Sections

Exercise 3.1

Creating a Table

Exercise 3.2

Modifying a Table

Exercise 3.3

Formatting Your List

Exercise 4.1

Insert a Footnote, Source, and Citation

Exercise 4.2

Adding a TOC and Bibliography

Exercise 5.1

Inserting Shapes and Graphics

Exercise 5.2

Formatting Pictures and Graphics

Exercise 5.3

Adding Text to Shapes and Graphics

Exercise 5.4

Positioning Graphics and Adding Alt Text

Exercise 6.1

Inserting, Replying to, and Deleting a Comment

Exercise 6.2

Track Changes

Exercise 7.1

Importing Text and CSV Format Files

Exercise 7.2

Navigating in a Workbook

Exercise 7.3

Formatting a Workbook

Exercise 7.4

Changing Workbook Properties and Views

Exercise 7.5

Changing Print Settings and Inspecting a Workbook

Exercise 8.1

Manipulating Data

Exercise 8.2

Formatting Cells and Ranges

Exercise 8.3

Define and Reference Named Ranges

Exercise 8.4

Summarizing Data Visually

Exercise 9.1

Creating a Table

Exercise 9.2

Modifying a Table

Exercise 9.3

Filtering and Sorting Your Table Data

Exercise 10.1

Inserting References

Exercise 10.2

Calculate and Transform Datas

Exercise 10.3

Formatting and Modifying Text

Exercise 11.1

Creating Charts

Exercise 11.2

Modifying Charts

Exercise 11.3

Formatting Charts

Exercise 12.1

Modifying Slide Masters, Handout Masters, and Note Masters

Exercise 12.2

Changing Presentation Options and Views

Exercise 12.3

Configuring Print Settings for Presentations

Exercise 12.4

Configuring and Presenting Slideshows

Exercise 12.5

Preparing Presentations for Collaboration

Exercise 13.1

Inserting Slides

Exercise 13.2

Modifying Slides

Exercise 13.3

Ordering and Grouping Slides

Exercise 14.1

Formatting Text

Exercise 14.2

Inserting Links

Exercise 14.3

Inserting and Formatting Images

Exercise 14.4

Inserting and Formatting Graphic Elements

Exercise 14.5

Ordering and Grouping Objects on Slides

Exercise 15.1

Inserting and Formatting Tables

Exercise 15.2

Inserting and Modifying Charts

Exercise 15.3

Inserting and Formatting SmartArt Graphics

Exercise 15.4

Inserting and Modifying 3D Models

Exercise 15.5

Inserting and Managing Media

Exercise 16.1

Applying and Configuring Slide Transitions

Exercise 16.2

Animating Slide Content

Exercise 16.3

Setting Timing for Transitions

Introduction

Welcome to this book about becoming a Microsoft Certified Office Specialist for the Microsoft 365 suite of productivity applications to which you can subscribe. You can also use this book with the one‐time purchase version of Office, which Microsoft calls Office 2019.

Microsoft 365 allows you to use different versions on many platforms, including Windows, macOS, iOS, iPadOS, and Android. You can even use the free online version of Microsoft 365. This book, however, talks about using the most popular version of Microsoft 365 on the most popular operating system, which happens to be the Word, Excel, and PowerPoint applications in Microsoft 365 running on Windows 10.

You may already know about a lot of Word, Excel, and PowerPoint features by working with it, but no matter if you use Word, Excel, and PowerPoint for your regular documentation tasks, or if you're new to the application, you'll learn a lot about the power that Word, Excel, and PowerPoint gives you to create all kinds of documents.

Who Should Read This Book

If you want to prepare to take one or all the Microsoft Office Specialist exams, which will help you become a certified specialist in Word, Excel, and/or PowerPoint, and hopefully increase your stature, marketability, and income, then this is the book for you. Even if you're not going to take the exam, but you want to learn how to use Word, Excel, and PowerPoint more effectively, this book will show you how to get the most out of using Word, Excel, and PowerPoint based on features that Microsoft believes are important for you to know.

What You'll Learn from this Book

What you learn in this book hews to the topics in the Microsoft Office Specialist exams, because this book is designed to help you learn about the topics in the exam and pass it on the first try.

After you finish reading the book and complete all the exercises, you'll have an in‐depth understanding of Word, Excel, and PowerPoint that you can use to become more productive at work and at home (or in your home office).

Hardware and Software Requirements

You should be running a computer with Windows 10 installed, and you should have Word, Excel, and PowerPoint for Microsoft 365 or Word, Excel, and PowerPoint 2019 installed and running too before you dive into this book. Either version of Word, Excel, and PowerPoint contains all of the features that are documented in this book so that you can pass the exam.

How to Use this Book

Start by taking the Assessment Test after this introduction to see how well you know Word, Excel, and PowerPoint already. Even if you've been using Word, Excel, and PowerPoint for a while, you may be surprised at how much you don't know about it.

Next, read each chapter and go through each of the exercises throughout the chapter to reinforce the concepts in each section. When you reach the end of the chapter, answer each of the 10 Review Questions to test what you learned. You can check your answers in the appendix at the back of the book.

If you're indeed taking the exam, then there are two other pedagogical tools that you can use: Flashcards and a Practice Exam. You may remember flashcards from when you were in school, and they're useful when you want to reinforce your knowledge. Use the Flashcards with a friend or relative if you like. (They might appreciate learning about Word, Excel, and PowerPoint, too.) The Practice Exam will help you further hone your ability to answer any question on the real exam with no worries.

How to Contact Wiley or the Author

If you believe you have found an error in this book, and it is not listed on the book's web page, you can report the issue to our customer technical support team at support.wiley.com.

You can email the author with your comments or questions at [email protected]. You can also visit Eric's website at www.butow.net.

How this Book Is Organized

Part I

: Word Exam MO‐100

Chapter 1

: Working with Documents

   This chapter introduces you to navigating within a document, how to format a document so that it looks the way you want, saving a document, sharing a document, and inspecting a document before you share it, so that all of your recipients can read it.

Chapter 2

: Inserting and Formatting Text

   This chapter follows up by showing you how to add text into a document, how to format text and paragraphs in your document using Word tools, including Format Painter and styles, as well as how to create and format sections within a document.

Chapter 3

: Managing Tables and Lists

   This chapter shows you how to use the built‐in table tools to create tables of information, convert the table to text (and vice versa), as well as modify the table to look the way that you want. You'll also learn how to create bulleted and numbered lists in your text.

Chapter 4

: Building References

   This chapter tells you about how to add and format reference elements in a document including footnotes, endnotes, bibliographies, citations in those bibliographies, as well as a table of contents.

Chapter 5

: Adding and Formatting Graphic Elements

   This chapter covers all of the ins and outs of adding various types of graphic elements in a document. Word comes with plenty of stock shapes, pictures, 3D models, and Microsoft's own SmartArt graphics. What's more, you'll learn how to add text boxes that sit outside of the main text in the document, such as for a sidebar.

Chapter 6

: Working with Other Users on Your Documents

   This chapter wraps up the book with a discussion about how to use the built‐in Comments and Track Changes features when you share a document with others. The Comments feature allows you to add comments outside of the main text for easy reading, and the Track Changes feature shows you which one of your reviewers made changes and when.

Part II

: Excel Exam MO‐200

Chapter 7

: Managing Worksheets and Workbooks

   This chapter introduces you to importing data into workbooks, navigating within a workbook, how to format worksheets and workbooks so that they look the way you want, customizing Excel options and views, saving a workbook, sharing a workbook, and inspecting a workbook before you share it, so that all of your recipients can read it.

Chapter 8

: Using Data Cells and Ranges

   This chapter follows up by showing you how to manipulate your data in a worksheet to show the data that you want to see, how to format cells and ranges in a worksheet using Excel tools, including Format Painter and styles, define and reference cell ranges, as well as how to summarize your data with Sparklines and conditional formatting.

Chapter 9

: Working with Tables and Table Data

   This chapter shows you how to use the built‐in table tools to create tables of information, convert the table to a cell range (and vice versa), as well as modify the table to look the way that you want. You'll also learn how to sort and filter text in a table.

Chapter 10

: Performing Operations by Using Formulas and Functions

   This chapter tells you how to insert references into a cell formula, perform calculations, count cells, execute conditional operations, as well as format text using a variety of built‐in Excel functions.

Chapter 11

: Managing Charts

   This chapter covers how to create charts within a worksheet and on a separate worksheet, how to modify a chart to show the data you want, how to format a chart with layouts, styles, and add alternative text to a chart so that everyone who sees the chart will know what it's about.

Part III

: PowerPoint Exam MO‐300

Chapter 12

: Creating Presentations

   This chapter introduces you to managing presentations including how to modify slide masters, handout masters, and note masters, change presentation options and views, configure print settings for your presentation, configure and present slideshows, and prepare presentations for collaboration with others.

Chapter 13

: Managing Slides

   This chapter follows up by showing you how to insert slides including from Word and other presentations, insert Summary Zoom slides, modify slides including inserting slide headers and footers, as well as how to order and group slides.

Chapter 14

: Inserting and Formatting Text, Shapes, and Images

   This chapter shows you how to format and apply styles to text in a slideshow, insert links, insert and format images, insert and format graphic elements including shapes and text boxes, as well as order and group objects on slides.

Chapter 15

: Inserting Tables, Charts, SmartArt, 3D Models, and Media

   This chapter tells you how to insert and format tables, charts, SmartArt graphics, 3D models, audio and video clips, and screen recordings into a slideshow.

Chapter 16

: Applying Transitions and Animations

   This chapter covers how to apply and configure transitions between slides, animate content within a slide, and set timing for slide transitions.

Interactive Online Learning Environment and TestBank

Learning the material in the MCA Microsoft® Office Specialist Complete Study Guide (Office 365 and Office 2019) is an important part of preparing for the Microsoft Office Specialist exams, but we also provide additional tools to help you prepare. The online TestBank will help you understand the types of questions that will appear on the certification exam.

The Sample Tests in the TestBank include all the questions in each chapter as well as the questions from the Assessment Test. In addition, there is a Practice Exam containing 150 questions. You can use this test to evaluate your understanding and identify areas that may require additional study.

The Flashcards in the TestBank will push the limits of what you should know for the certification exam. The Flashcards contain 300 questions provided in digital format. Each flashcard has one question and one correct answer.

The online Glossary is a searchable list of key terms introduced in this Study Guide that you should know for the Microsoft Office Specialist exams.

To start using the test bank to study for the Microsoft Office Specialist exams, go to www.wiley.com/go/sybextestprep and register your book to receive your unique PIN. Once you have 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

7

,

8

2.3 Define and reference named changes

8

2.4 Summarize data visually

8

Section 3: Manage tables and table data

3.1 Create and format tables

9

3.2 Modify tables

7

,

8

,

9

3.3 Filter and sort table data

9

Section 4: Perform operations by using formulas and functions

4.1 Insert references

10

4.2 Calculate and transform datas

10

4.3 Format and modify text

7

,

8

,

10

Section 5: Manage charts

5.1 Create charts

11

5.2 Modify charts

11

5.3 Format charts

11

PowerPoint for Office 365 or Office 2019

Section 1: Manage presentations

1.1 Modify slide masters, handout masters, and note masters

12

1.2 Change presentation options and views

12

1.3 Configure print settings for presentations

12

1.4 Configure and present slide shows

12

1.5 Prepare presentations for collaboration

12

Section 2: Manage slides

2.1 Insert slides

13

2.2 Modify slides

13

2.3 Order and group slides

13

Section 3: Insert and format text, shapes, and images

3.1 Format text

14

3.2 Insert links

14

3.3 Insert and format images

14

3.4 Insert and format graphic elements

14

3.5 Order and group objects on slides

14

Section 4: Insert tables, charts, SmartArt, 3D models, and media

4.1 Insert and format tables

15

4.2 Insert and modify charts

15

4.3 Insert and format SmartArt graphics

15

4.4 Insert and modify 3D models

15

4.5 Insert and manage media

15

Section 5: Apply transitions and animations

5.1 Apply and configure slide transitions

16

5.2 Animate slide content

16

5.3 Set timing for transitions

16

Assessment  Test

How big of a table can you create using the Table grid in the Insert menu ribbon?

12 columns and 10 rows

10 columns and 8 rows

10 columns and 10 rows

12 columns and 12 rows

What search option do you use to find all words in a document that start with the same three letters?

Match Suffix

Match Prefix

Use Wildcards

Sounds Like (English)

What menu option do you click to create a new comment in a document?

Insert

References

Review

Home

What are the three reference elements that you can add to a document?

Citation, source, and bibliography

Caption, table of figures, cross‐reference

Footnote, endnote, citation

Table of contents, table of figures, table of authorities

You need to have a link on page 30 of your document that goes back to page 1. What menu option do you click on to get there?

Home

References

View

Insert

Where can you find pictures to add into a Word document? (Choose all that apply.)

On a drive connected to your computer

On the Internet

Stock images

Office.com

When you need to indent a paragraph, where can you do this? (Choose all that apply.)

In the Home menu ribbon

In the Insert menu ribbon

In the Layout menu ribbon

Using the Tab key

Your customers want an easy way to see what's in your document and go to a location quickly. How do you do that?

Add links.

Add a bibliography.

Add a table of contents.

Add a bookmark.

How can you quickly change the format of selected text?

By using the Insert menu ribbon

By using the Layout menu ribbon

By moving the mouse pointer over the selected text and selecting formatting options from the pop‐up menu

By selecting the style in the Home ribbon

What do you have to do before you cite a source?

Select the writing style guide to use.

Add a bibliography.

Add the source to the document.

Add a table of contents.

How does Word allow you to sort in a table?

By number and date

By text, number, and date

By text and number

Text only

You need to send your document to several coworkers for their review. How do you make sure that you see all their additions, changes, and deletions?

Click the Show Comments icon in the Review menu ribbon.

Add a comment at the beginning of the document.

Click Read Mode in the View menu ribbon.

Turn on Track Changes.

Your boss wants you to convert a Word document and share it as a PDF file. How can you do that?

Print to a PDF printer.

Use the Send Adobe PDF For Review feature.

Use Adobe Acrobat.

Use the Home menu ribbon.

How do you go to each comment in your document? (Choose all that apply.)

By using the View menu ribbon

By using the Review menu ribbon

By scrolling through the document to read them

By using the Find And Replace dialog box

Your boss wants you to create a nice‐looking organization chart for the company. What do you use to create one in Word?

Pictures

Shapes

SmartArt

Screenshot

What are the two types of lists that you can add to a document?

Cardinal and ordinal

Roman and alphabetical

Bulleted and numbered

Symbol and picture

How do you select all of the text in a document?

Click the first word in the document and then hold and drag until all of the words are selected.

Press Ctrl+A.

Use the Home menu ribbon.

Use the View menu ribbon.

What category of paragraph styles does Word look for when you create a table of contents?

Title

Subtitle

Strong

Heading

What WordArt styles can you add to text within a text box? (Choose all that apply.)

Text Fill

Text Direction

Text Alignment

Text Outline

Why would you change a number value in a numbered list?

Word gets confused as you add more entries.

You have one list separated by other text or images.

You need to add a number value manually for each entry in the list.

You can't change a number value in a numbered list.

What wrapping style do you use to get an image to sit on a line of text?

Square

Tight

In line with text

Top and bottom

How do you check a document so that you can make sure everyone can read it before you share it with others?

Look through the entire document.

Use Find and Replace.

Use the Document Inspector.

Use the spell checker.

How do you change the color for each reviewer in a document?

You can't.

Use the Review menu ribbon.