Introduction xxi Assessment Test xxviii Answers to Assessment Test xl Part I Word Exam MO-100 1 Chapter 1 Working with Documents 3 Navigating Within Documents 4 Searching for Text 4 Linking to Locations Within Documents 8 Moving to Specific Locations and Objects in Documents 9 Showing and Hiding Formatting Symbols and Hidden Text 10 Formatting Documents 13 Setting Up Document Pages 14 Applying Style Settings 15 Inserting and Modifying Headers and Footers 17 Configuring Page Background Elements 18 Saving and Sharing Documents 20 Saving Documents in Alternative File Formatting 20 Changing Basic Document Properties 21 Modifying Print Settings 23 Sharing Documents Electronically 24 Inspecting Documents for Issues 26 Locating and Removing Hidden Properties and Personal Information 26 Finding and Fixing Accessibility Issues 28 Locating and Correcting Compatibility Issues 29 Summary 30 Key Terms 31 Exam Essentials 31 Review Questions 33 Chapter 2 Inserting and Formatting Text 35 Adding and Replacing Text 36 Finding and Replacing Text 36 Inserting Symbols and Special Characters 40 Formatting Text and Paragraphs 42 Adding Text Effects 42 Applying Formatting by Using Format Painter 43 Setting Line and Paragraph Spacing and Indentation 43 Applying Built-In Styles to Text 46 Clearing Formatting 47 Creating and Configuring Document Sections 50 Formatting Text in Multiple Columns 50 Inserting Page, Section, and Column Breaks 52 Changing Page Setting Options for a Section 53 Summary 56 Key Terms 57 Exam Essentials 57 Review Questions 58 Chapter 3 Managing Tables and Lists 61 Creating Tables 62 Converting Text to Tables 64 Switching Tables to Text 65 Creating Tables by Specifying Rows and Columns 66 Modifying Tables 68 Sorting Table Data 68 Configuring Cell Margins and Spacing 70 Merging and Splitting Cells 73 Resizing Tables, Rows, and Columns 75 Splitting Tables 80 Configuring a Repeating Row Header 82 Creating and Formatting Lists 85 Structuring Paragraphs as Numbered and Bulleted Lists 85 Changing Bullet Characters and Number Formatting 86 Defining Custom Bullet Characters and Number Formatting 88 Increasing and Decreasing List Levels 91 Restarting and Continuing List Numbering 92 Setting Starting Number Values 94 Summary 95 Key Terms 96 Exam Essentials 96 Review Questions 97 Chapter 4 Building References 99 Creating and Managing Referencing Elements 100 Inserting Footnotes and Endnotes 100 Modifying Footnote and Endnote Properties 103 Creating and Modifying Bibliography Citation Sources 104 Inserting Citations for Bibliographies 107 Working with Referencing Tables 109 Inserting Tables of Contents 109 Customizing Tables of Contents 110 Adding Bibliographies 112 Summary 113 Key Terms 113 Exam Essentials 114 Review Questions 115 Chapter 5 Adding and Formatting Graphic Elements 117 Inserting Illustrations and Text Boxes 118 Adding Shapes 118 Including Pictures 120 Inserting 3D Models 121 Adding SmartArt Graphics 122 Placing Screenshots and Screen Clippings 123 Inserting Text Boxes 125 Formatting Illustrations and Text Boxes 127 Applying Artistic Effects 127 Adding Picture Effects and Picture Styles 128 Removing Picture Backgrounds 131 Formatting Graphic Elements 132 Setting Up SmartArt Graphics 134 Working with 3D Models 136 Adding and Organizing Text 137 Formatting Text in Text Boxes 137 Adding Text in Shapes 139 Changing SmartArt Graphic Content 141 Modifying Graphic Elements 142 Positioning Objects 142 Wrapping Text Around Objects 143 Adding Alt Text to Objects 146 Summary 148 Key Terms 148 Exam Essentials 148 Review Questions 149 Chapter 6 Working with Other Users on Your Document 151 Adding Comments 152 Inserting Comments 152 Reviewing and Replying to Comments 153 Resolving Comments 154 Deleting Comments 155 Tracking Your Changes 157 Turning On Track Changes 157 Reviewing Tracked Changes 158 Accepting and Rejecting Tracked Changes 159 Locking and Unlocking Change Tracking 162 Summary 165 Key Terms 165 Exam Essentials 165 Review Questions 166 Part II Excel Exam MO-200 169 Chapter 7 Managing Worksheets and Workbooks 171 Importing Data into Workbooks 172 Bringing in Data from TXT Files 173 Importing Data from CSV Files 174 Navigating Within Workbooks 178 Searching for Data Within a Workbook 178 Navigating to Named Cells, Ranges, or Workbook Elements 180 Inserting and Removing Hyperlinks 182 Formatting Worksheets and Workbooks 190 Modifying Page Settings 190 Adjusting Row Height and Column Width 192 Customizing Headers and Footers 200 Customizing Options and Views 206 Customizing the Quick Access Toolbar 207 Displaying and Modifying Workbook Content in Different Views 211 Freezing Worksheet Rows and Columns 214 Changing Window Views 216 Modifying Basic Workbook Properties 218 Displaying Formulas 219 Configuring Content for Collaboration 222 Setting a Print Area 222 Saving Workbooks in Other File Formats 224 Configuring Print Settings 224 Inspecting Workbooks for Issues 225 Summary 229 Key Terms 229 Exam Essentials 229 Review Questions 231 Chapter 8 Using Data Cells and Ranges 233 Manipulating Data in Worksheets 234 Pasting Data by Using Special Paste Options 234 Filling Cells by Using Auto Filling 238 Inserting and Deleting Multiple Columns or Rows 240 Adding and Removing Cells 242 Formatting Cells and Ranges 245 Merging and Unmerging Cells 245 Modifying Cell Alignment, Orientation, and Indentation 246 Formatting Cells by Using Format Painter 249 Wrapping Text Within Cells 250 Using Number Formatting 252 Applying Cell Formatting from the Format Cells Dialog Box 253 Working with Cell Styles 254 Clearing Cell Formatting 256 Defining and Referencing Named Ranges 258 Defining a Named Range 258 Naming a Table 263 Summarizing Data Visually 265 Inserting Sparklines 265 Applying Built-In Conditional Formatting 269 Removing Conditional Formatting 271 Summary 275 Key Terms 275 Exam Essentials 275 Review Questions 277 Chapter 9 Working with Tables and Table Data 279 Creating and Formatting Tables 280 Creating Excel Tables from Cell Ranges 280 Applying Table Styles 282 Converting Tables to Cell Ranges 283 Modifying Tables 285 Adding or Remove Table Rows and Columns 285 Configuring Table Style Options 288 Inserting and Configuring Total Rows 289 Filtering and Sorting Table Data 292 Filtering Records 292 Sorting Data by Multiple Columns 296 Summary 298 Key Terms 299 Exam Essentials 299 Review Questions 300 Chapter 10 Performing Operations by Using Formulas and Functions 303 Inserting References 304 Inserting Relative, Absolute, and Mixed References 305 Referencing Named Ranges and Named Tables in Formulas 307 Calculating and Transforming Datas 310 Performing Calculations Using the AVERAGE() , MAX() , MIN() , and SUM() Functions 310 Perform Conditional Operations by Using the IF() Function 321 Formatting and Modifying Text 325 Formatting Text Using the RIGHT() , LEFT() , and MID() Functions 325 Formatting Text Using the UPPER() , LOWER() , and LEN() Functions 329 Formatting Text Using the CONCAT() and TEXTJOIN() Functions 333 Summary 336 Key Terms 337 Exam Essentials 337 Review Questions 338 Chapter 11 Managing Charts 341 Creating Charts 342 Building Charts 342 Working with Chart Sheets 344 Modifying Charts 348 Adding Data Series to Charts 348 Switching Between Rows and Columns in Source Data 351 Adding and Modifying Chart Elements 352 Formatting Charts 355 Using Chart Layouts 356 Applying Chart Styles 364 Adding Alternative Text to Charts for Accessibility 366 Summary 368 Key Terms 368 Exam Essentials 369 Review Questions 370 Part III PowerPoint Exam MO-300 373 Chapter 12 Creating Presentations 375 Modifying Slide Masters, Handout Masters, and Note Masters 377 Changing the Slide Master Theme or Background 378 Modifying Slide Master Content 383 Creating Slide Layouts 384 Modify Slide Layouts 389 Modifying the Handout Master 393 Modifying the Notes Master 400 Changing Presentation Options and Views 406 Changing the Slide Size 406 Displaying Presentations in Different Views 408 Setting Basic File Properties 410 Configuring Print Settings for Presentations 411 Printing All or Part of a Presentatio.