Оглавление
Eric Butow. MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide
Table of Contents
List of Illustrations
Guide
Pages
MCA Microsoft® Office Specialist Complete Study Guide (Office 365 and Office 2019) Word Exam MO‐100, Excel Exam MO‐200, and PowerPoint Exam MO‐300
Acknowledgments
About the Author
About the Technical Editor
Table of Exercises
Introduction
Who Should Read This Book
What You'll Learn from this Book
Hardware and Software Requirements
How to Use this Book
How to Contact Wiley or the Author
How this Book Is Organized
Interactive Online Learning Environment and TestBank
Objective Map
Assessment Test
Answers to Assessment Test
Chapter 1 Working with Documents
Navigating Within Documents
Searching for Text
Using the Search Bar
Finding in the Ribbon
Replacing in the Ribbon
Opening the Navigation Pane
Replacing with the Keyboard
Linking to Locations Within Documents
Moving to Specific Locations and Objects in Documents
Showing and Hiding Formatting Symbols and Hidden Text
Formatting Symbols
Hidden Text
Selected Text
For the Entire Document
EXERCISE 1.1 Navigating and Modifying Text in a Document
Formatting Documents
Setting Up Document Pages
Applying Style Settings
Design Menu
Styles Pane
Inserting and Modifying Headers and Footers
Configuring Page Background Elements
EXERCISE 1.2 Setting Up Your Document
Saving and Sharing Documents
Saving Documents in Alternative File Formatting
Changing Basic Document Properties
Modifying Print Settings
Sharing Documents Electronically
Real World Scenario. The Case for Sending a Document by Fax
EXERCISE 1.3 Changing the File Type and Sharing Your Document
Inspecting Documents for Issues
Locating and Removing Hidden Properties and Personal Information
Finding and Fixing Accessibility Issues
Locating and Correcting Compatibility Issues
EXERCISE 1.4 Checking Out Your Document
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 2 Inserting and Formatting Text
Adding and Replacing Text
Finding and Replacing Text
Finding Text
Using Advanced Find to Locate More than Just Text
Replacing Text
Inserting Symbols and Special Characters
EXERCISE 2.1 Finding and Replacing Text
Formatting Text and Paragraphs
Adding Text Effects
Applying Formatting by Using Format Painter
Setting Line and Paragraph Spacing and Indentation
Line Spacing
Paragraph Spacing
Indenting a Paragraph
Applying Built‐In Styles to Text
Clearing Formatting
EXERCISE 2.2 Changing a Paragraph Format
Creating and Configuring Document Sections
Formatting Text in Multiple Columns
Real World Scenario. Creating Different Column Sections on One Page
Inserting Page, Section, and Column Breaks
Changing Page Setting Options for a Section
EXERCISE 2.3 Inserting Sections
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 3 Managing Tables and Lists
Creating Tables
Real World Scenario. Create Tables Quick!
Converting Text to Tables
Switching Tables to Text
Creating Tables by Specifying Rows and Columns
EXERCISE 3.1 Creating a Table
Modifying Tables
Sorting Table Data
Configuring Cell Margins and Spacing
Use Your Mouse
Set to a Specific Width
Add or Change the Space Inside the Table
Merging and Splitting Cells
Merge Cells
Split Cells
Resizing Tables, Rows, and Columns
Change Row Height
Resize a Column or Table Automatically with AutoFit
Turn Off AutoFit
Resize an Entire Table Manually
Make Multiple Columns or Rows the Same Size
Splitting Tables
Configuring a Repeating Row Header
EXERCISE 3.2 Modifying a Table
Creating and Formatting Lists
Structuring Paragraphs as Numbered and Bulleted Lists
Create a List
Create a List from Existing Text
Changing Bullet Characters and Number Formatting
Bullets
Numbering
Defining Custom Bullet Characters and Number Formatting
Bullets
Numbering
Increasing and Decreasing List Levels
Restarting and Continuing List Numbering
Setting Starting Number Values
EXERCISE 3.3 Formatting Your List
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 4 Building References
Creating and Managing Referencing Elements
Inserting Footnotes and Endnotes
Add Footnote
Place Endnote
Modifying Footnote and Endnote Properties
Creating and Modifying Bibliography Citation Sources
Create a Source
Modify a Source
Edit Citation
Edit Source
Inserting Citations for Bibliographies
Real World Scenario. Add a Citation Placeholder
EXERCISE 4.1 Insert a Footnote, Source, and Citation
Working with Referencing Tables
Inserting Tables of Contents
Customizing Tables of Contents
Change Style or Remove TOC
Update Table
Change the Styles in the TOC
Adding Bibliographies
EXERCISE 4.2 Adding a TOC and Bibliography
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 5 Adding and Formatting Graphic Elements
Inserting Illustrations and Text Boxes
Adding Shapes
Including Pictures
Inserting 3D Models
Adding SmartArt Graphics
Placing Screenshots and Screen Clippings
Screenshot
Screen Clipping
Inserting Text Boxes
EXERCISE 5.1 Inserting Shapes and Graphics
Formatting Illustrations and Text Boxes
Applying Artistic Effects
Adding Picture Effects and Picture Styles
Add a Picture Effect
Apply a Picture Style
Removing Picture Backgrounds
Formatting Graphic Elements
Shapes
Pictures
Screenshots and Screen Clippings
Setting Up SmartArt Graphics
Working with 3D Models
EXERCISE 5.2 Formatting Pictures and Graphics
Adding and Organizing Text
Formatting Text in Text Boxes
Apply WordArt Styles
Change Text Appearance
Adding Text in Shapes
Apply WordArt Styles
Change Text Appearance
Changing SmartArt Graphic Content
EXERCISE 5.3 Adding Text to Shapes and Graphics
Modifying Graphic Elements
Positioning Objects
Wrapping Text Around Objects
Wrapping Text Styles
Specific Wrapping
Real World Scenario. Placing Your Graphics for Easy Reading
Adding Alt Text to Objects
EXERCISE 5.4 Positioning Graphics and Adding Alt Text
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 6 Working with Other Users on Your Document
Adding Comments
Inserting Comments
Reviewing and Replying to Comments
Resolving Comments
Deleting Comments
EXERCISE 6.1 Inserting, Replying to, and Deleting a Comment
Tracking Your Changes
Turning On Track Changes
Reviewing Tracked Changes
View Changes in the Document
Modify Change Markup Settings
Accepting and Rejecting Tracked Changes
Accept Tracked Changes
Reject Tracked Changes
Locking and Unlocking Change Tracking
Real World Scenario. Add a Good Lock Change Tracking Password
EXERCISE 6.2 Track Changes
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 7 Managing Worksheets and Workbooks
Importing Data into Workbooks
Bringing in Data from TXT Files
A Cautionary Note About Formatting in a Text File
Import a Text File into an Existing Worksheet
Importing Data from CSV Files
Insert a CSV File into a New Worksheet
EXERCISE 7.1 Importing Text and CSV Format Files
Navigating Within Workbooks
Searching for Data Within a Workbook
Important Search Tips
Navigating to Named Cells, Ranges, or Workbook Elements
Inserting and Removing Hyperlinks
Within a Workbook
Real World Scenario. Give Your Readers Helpful Link Tips
Link to an Existing File
Link to a Web Page
To an Email Address
Copy and Move a Hyperlink
Change a Hyperlink
Delete a Hyperlink
EXERCISE 7.2 Navigating in a Workbook
Formatting Worksheets and Workbooks
Modifying Page Settings
Adjusting Row Height and Column Width
Set Column to Specific Width
Change the Column Width to Fit the Contents Automatically with AutoFit
Match the Column Width to Another Column
Change the Default Width for All Columns on a Worksheet
Change the Width of Columns by Using the Mouse
Set a Row to a Specific Height
Change the Row Height to Fit the Contents with AutoFit
Change the Height of Rows by Using the Mouse
Customizing Headers and Footers
Add a Header or Footer
How to Hide the Header and Footer
Add Built‐In Header and Footer Elements
Header & Footer Section
Header & Footer Elements
Delete a Header and Footer
EXERCISE 7.3 Formatting a Workbook
Customizing Options and Views
Customizing the Quick Access Toolbar
Add a Command to the Quick Access Toolbar
Add from the Ribbon
Add from the Customize Quick Access Toolbar Menu
Remove a Command from the Quick Access Toolbar
Move the Quick Access Toolbar
Reset the Quick Access Toolbar to the Default Settings
Displaying and Modifying Workbook Content in Different Views
Create a Custom View
Apply a Custom View
Delete a Custom View
Freezing Worksheet Rows and Columns
Freeze the First Column
Freeze the First Row
Freeze Any Column or Row
Unfreeze Rows and Columns
Changing Window Views
Page Break Preview
Page Layout View
Normal View
Modifying Basic Workbook Properties
Displaying Formulas
Switch Between Displaying Formulas and Their Results
Hide a Formula in the Formula Bar
EXERCISE 7.4 Changing Workbook Properties and Views
Configuring Content for Collaboration
Setting a Print Area
Configuring Print Areas
Saving Workbooks in Other File Formats
Configuring Print Settings
Inspecting Workbooks for Issues
EXERCISE 7.5 Changing Print Settings and Inspecting a Workbook
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 8 Using Data Cells and Ranges
Manipulating Data in Worksheets
Pasting Data by Using Special Paste Options
Paste
Paste Values
Other Paste Options
Paste Special
Filling Cells by Using Auto Filling
Inserting and Deleting Multiple Columns or Rows
Insert Multiple Columns
Insert Multiple Rows
Deleting Multiple Rows and Columns
Adding and Removing Cells
Add and Remove a Column
Insert and Delete a Row
EXERCISE 8.1 Manipulating Data
Formatting Cells and Ranges
Merging and Unmerging Cells
What You Can and Can't Do When Merging
Modifying Cell Alignment, Orientation, and Indentation
Align a Column or Row
Change the Orientation of Text in a Cell
Rotate Text to a Precise Angle
Formatting Cells by Using Format Painter
Wrapping Text Within Cells
Wrap Text
Add a Line Break
Using Number Formatting
Applying Cell Formatting from the Format Cells Dialog Box
Working with Cell Styles
Apply a Cell Style
Remove a Cell Style from Data
Clearing Cell Formatting
EXERCISE 8.2 Formatting Cells and Ranges
Defining and Referencing Named Ranges
Defining a Named Range
Name a Cell or a Range
Cell Naming Conventions
Define Names from a Selected Range
Use Names in Formulas
Naming a Table
EXERCISE 8.3 Define and Reference Named Ranges
Summarizing Data Visually
Inserting Sparklines
Add a Sparkline
Format a Sparkline Chart
Real World Scenrio. Adding a Date to Your Axis
Applying Built‐In Conditional Formatting
Removing Conditional Formatting
Clear Conditional Formatting on a Worksheet
In a Range of Cells
Find and Remove the Same Conditional Formats Throughout a Worksheet
EXERCISE 8.4 Summarizing Data Visually
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 9 Working with Tables and Table Data
Creating and Formatting Tables
Creating Excel Tables from Cell Ranges
Applying Table Styles
Converting Tables to Cell Ranges
EXERCISE 9.1 Creating a Table
Modifying Tables
Adding or Remove Table Rows and Columns
Add Table Rows and Columns
Remove Table Rows and Columns
Other Ways to Add and Remove Table Rows and Columns
Configuring Table Style Options
Inserting and Configuring Total Rows
EXERCISE 9.2 Modifying a Table
Filtering and Sorting Table Data
Filtering Records
Real World Scenrio. Filter Your Numbers Even More
Sorting Data by Multiple Columns
Sort Ascending or Descending
Create a Custom Sort
EXERCISE 9.3 Filtering and Sorting Your Table Data
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 10 Performing Operations by Using Formulas and Functions
Inserting References
Inserting Relative, Absolute, and Mixed References
Referencing Named Ranges and Named Tables in Formulas
EXERCISE 10.1 Inserting References
Calculating and Transforming Datas
Performing Calculations Using the AVERAGE(), MAX(), MIN(), and SUM() Functions
AVERAGE()
Average of Cells
Average of Numbers
Real World Scenrio. Use Averages for Different Criteria
MAX()
MIN()
SUM()
Counting Cells Using the COUNT(), COUNTA(), and COUNTBLANK() Functions
COUNT()
COUNTA()
COUNTBLANK()
Perform Conditional Operations by Using the IF() Function
Show if a Cell Contains Text
Show if the Numeric Value Meets the Condition
EXERCISE 10.2 Calculate and Transform Datas
Formatting and Modifying Text
Formatting Text Using the RIGHT(), LEFT(), and MID() Functions
RIGHT()
LEFT()
MID()
Formatting Text Using the UPPER(), LOWER(), and LEN() Functions
UPPER()
LOWER()
LEN()
Formatting Text Using the CONCAT() and TEXTJOIN() Functions
The Difference Between CONCAT and TEXTJOIN
CONCAT()
TEXTJOIN()
EXERCISE 10.3 Formatting and Modifying Text
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 11 Managing Charts
Creating Charts
Building Charts
Working with Chart Sheets
EXERCISE 11.1 Creating Charts
Modifying Charts
Adding Data Series to Charts
Add a Data Series in the Same Worksheet Chart
Add a Data Series to a Chart Sheet
Switching Between Rows and Columns in Source Data
Adding and Modifying Chart Elements
Change Elements More Precisely
EXERCISE 11.2 Modifying Charts
Formatting Charts
Using Chart Layouts
Create Your Own Chart Layout
Current Selection
Insert Shapes
Shape Styles
WordArt Styles
Accessibility
Arrange
Size
Align Multiple Charts in a Worksheet
Applying Chart Styles
Apply a Built‐In Chart Style
Create Your Own Chart Style
Adding Alternative Text to Charts for Accessibility
EXERCISE 11.3 Formatting Charts
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 12 Creating Presentations
Modifying Slide Masters, Handout Masters, and Note Masters
Design Your Masters First
Changing the Slide Master Theme or Background
Apply a Slide Master theme
Change the Slide Master Background
Modifying Slide Master Content
Creating Slide Layouts
Add Placeholder Areas
Rename the Layout
Delete the Layout
Modify Slide Layouts
Modifying the Handout Master
Modifying the Notes Master
EXERCISE 12.1 Modifying Slide Masters, Handout Masters, and Note Masters
Changing Presentation Options and Views
Changing the Slide Size
Displaying Presentations in Different Views
Setting Basic File Properties
EXERCISE 12.2 Changing Presentation Options and Views
Configuring Print Settings for Presentations
Printing All or Part of a Presentation
Printing Notes Pages
Printing Handouts
Printing in Color, Grayscale, or Black and White
EXERCISE 12.3 Configuring Print Settings for Presentations
Configuring and Presenting Slideshows
Creating Custom Slideshows
Create a Simple Custom Slideshow
Create a Hyperlinked Custom Slideshow
Present a Custom Slideshow Setup
Configuring Slideshow Options
Rehearsing Slideshow Timing
Rehearse Your Timings
View and Turn Off Slideshow Timings
Change the Timing Setup
Remove the Timing Setup
Setting Up Slideshow Recording Options
Record Audio Narration
Playing and Removing the Audio Recording
Presenting Slideshows by Using Presenter View
Start Presenter View
Use Presenter View Controls
Top of Screen
Below the Slide in the Left Pane
At the Bottom of the Left Pane
Set Monitor and Presenter View Settings
Real World Scenrio. Make Your Notes Bigger
EXERCISE 12.4 Configuring and Presenting Slideshows
Preparing Presentations for Collaboration
Mark Presentations as Final
Protecting Presentations by Using Passwords
Inspecting Presentations for Issues
Adding and Managing Comments
Insert Comments
View, Review, and Reply to Comments
Delete Comments
Print One or More Comments
Preserving Presentation Content
Exporting Presentations to Other Formats
Export to a PDF or XPS Document
Export a Slideshow as a Video
Package a Presentation to Save to a CD‐R or CD‐RW
Create Handouts
Change the File Type
EXERCISE 12.5 Preparing Presentations for Collaboration
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 13 Managing Slides
Inserting Slides
Importing Word Document Outlines
Inserting Slides from Another Presentation
Inserting Slides and Selecting Slide Layouts
Inserting Summary Zoom Slides
Real World Scenrio. Changing a Summary Zoom Slide to an Image
Duplicating Slides
EXERCISE 13.1 Inserting Slides
Modifying Slides
Hiding and Unhiding Slides
Showing a Hidden Slide During Your Presentation
Modifying Individual Slide Backgrounds
Inserting Slide Headers, Footers, and Page Numbers
Inserting a Handouts and Notes Header
Inserting a Slide Footer
Inserting a Page Number
EXERCISE 13.2 Modifying Slides
Ordering and Grouping Slides
Creating Sections
Modifying the Slide Order
Modify an Individual Slide
Move a Section
Renaming Sections
EXERCISE 13.3 Ordering and Grouping Slides
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 14 Inserting and Formatting Text, Shapes, and Images
Formatting Text
Applying Formatting and Styles to Text
Applying Formatting by Using Format Painter
Setting Line Spacing
Indenting a Paragraph
Applying Built‐In Styles to Text
Clearing Formatting
Formatting Text in Multiple Columns
Creating Bulleted and Numbered Lists
Create a List
Create a List from Existing Text
EXERCISE 14.1 Formatting Text
Inserting Links
Inserting Hyperlinks
Inserting Section Zoom Links and Slide Zoom Links
Linking to a Summary Zoom Slide
Creating a Slide Zoom Slide
Linking to a Slide Zoom Slide
EXERCISE 14.2 Inserting Links
Inserting and Formatting Images
Resizing and Cropping Images
Resize an Image
Crop an Image
Applying Built‐In Styles and Effects to Images
Apply a Picture Style
Add a Picture Effect
Inserting Screenshots and Screen Clippings
Screenshot
Screen Clipping
EXERCISE 14.3 Inserting and Formatting Images
Inserting and Formatting Graphic Elements
Inserting and Changing Shapes
Drawing by Using Digital Ink
Turn On the Draw Menu Option
Adding Text to Shapes and Text Boxes
Add Text to a Shape
Add a Text Box
Resizing Shapes and Text Boxes
Resize a Shape
Resize a Text Box
Formatting Shapes and Text Boxes
Shapes
Text Boxes
Real World Scenrio. Placing Your Graphics for Easy Reading
Applying Built‐In Styles to Shapes and Text Boxes
Apply a Shape Style
Apply WordArt Styles
Change Text Appearance
Adding Alt Text to Graphic Elements for Accessibility
EXERCISE 14.4 Inserting and Formatting Graphic Elements
Ordering and Grouping Objects on Slides
Ordering Shapes, Images, and Text Boxes
Aligning Shapes, Images, and Text Boxes
Grouping Shapes and Images
Displaying Alignment Tools
EXERCISE 14.5 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
Creating and Inserting Tables
Inserting and Deleting Table Rows and Columns
Create a Larger Table
Insert Rows and/or Columns
Delete Rows and/or Columns
Applying Built‐In Table Styles
EXERCISE 15.1 Inserting and Formatting Tables
Inserting and Modifying Charts
Creating and Inserting Charts
Modifying Charts
Adding Data Series to Charts
Switching Between Rows and Columns in Source Data
Adding and Modifying Chart Elements
Change Elements More Precisely
EXERCISE 15.2 Inserting and Modifying Charts
Inserting and Formatting SmartArt Graphics
Inserting SmartArt Graphics
Converting Lists to SmartArt Graphics
Adding and Modifying SmartArt Graphic Content
EXERCISE 15.3 Inserting and Formatting SmartArt Graphics
Inserting and Modifying 3D Models
Inserting 3D Models
Modifying 3D Models
EXERCISE 15.4 Inserting and Modifying 3D Models
Inserting and Managing Media
Inserting Audio and Video Clips
Supported Audio and Video Formats
Adding an Audio Clip
Adding a Video Clip
Real World Scenrio. Insert Online Video from YouTube
Creating and Inserting Screen Recordings
Recording Audio Clips
Recording Video Clips
Configuring Media Playback Options
Editing Audio Clips
Changing Video Playback Settings
EXERCISE 15.5 Inserting and Managing Media
Summary
Key Terms
Exam Essentials
Review Questions
Chapter 16 Applying Transitions and Animations
Applying and Configuring Slide Transitions
Applying Basic and 3D Slide Transitions
Configuring Transition Effects
Real World Scenrio. Add Sounds, Not Just Effects
EXERCISE 16.1 Applying and Configuring Slide Transitions
Animating Slide Content
Animating Text and Graphic Elements
Making Text Appear One Line at a Time
Making Text Appear One Letter at a Time
Animating SmartArt Graphics
Animating Shapes in a SmartArt Graphic
Reverse the Order of an Animation
Removing an Animation
Animating 3D Models
Applying an Animation
Changing Animation Effects
Configuring Animation Effects
Differences in Animation Behavior
Configuring Animation Paths
Adding a Motion Path
Editing a Motion Path
Creating a Morph Transition
Editing a Morph Transition
Reordering Animations on a Slide
EXERCISE 16.2 Animating Slide Content
Setting Timing for Transitions
Setting Transition Effect Duration
Configuring Transition Start and Finish Options
EXERCISE 16.3 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
WILEY END USER LICENSE AGREEMENT
