IC3 Internet and Computing Core Certification Key Applications Global Standard 4 Study Guide

Introduction xvii Assessment Test xxix Chapter 1 Exploring Common Application Features in Microsoft Office 1 Creating New Empty Documents with Microsoft Office 4 Starting and Closing Microsoft Office Applications 5 Opening and Closing Microsoft Office Files 6 Creating New Empty Files with Microsoft Office 7 Saving Your Microsoft Office Files 9 Working with Several Windows at the Same Time 13 The Basics of Using Microsoft Office Applications 18 Keyboard Shortcuts for Using the Ribbon Productively 18 Selecting, Copying, and Moving Data When Using Microsoft Office Applications 22 Dragging and Dropping Data When Using Microsoft Office Applications 31 Finding and Replacing Data in Your Microsoft Office Documents 32 Checking the Spelling of Your Microsoft Office Documents 35 Undoing Your Changes and Mistakes When Working with Microsoft Office Documents 38 Hiding Your Data from Tables and Charts 39 Selecting Non-adjacent Cells in Microsoft Excel Tables 41 Sorting Data When Working with Microsoft Excel Files 43 Adjusting the Way You View Microsoft Office Files 45 Adjusting the Size and the Orientation of Your Microsoft Office Files 49 Printing Your Documents from Microsoft Office 51 Where to Get Help with Using Microsoft Office 52 The Basics of Formatting Your Microsoft Office Files 55 Formatting the Text in Your Documents 55 Using Styles to Format Your Documents 58 Working with Multimedia Files in Microsoft Office 62 Adding Multimedia Files to Your Presentations 62 Adjusting the Pictures Used in Your Presentations 66 Summary 69 Exam Essentials 70 Key Terms 71 Review Questions 72 Chapter 2 Using Microsoft Word 75 Configuring the Layout of Your Documents 76 Adjusting Line and Paragraph Spacing in Your Documents 76 Aligning the Text in Your Documents 79 Organizing Your Documents into Columns 83 Setting the Margins of Your Documents 84 Displaying the Ruler When Editing Documents 87 Indenting the Text in Your Documents 88 Using Tabs to Control Where the Text Is Placed in Your Documents 92 Organizing the Data in Your Documents 96 Creating Bulleted and Numbered Lists 97 Sorting Single-Level Lists 98 Creating Tables 100 Adding or Removing Rows and Columns in Your Tables 103 Merging and Splitting Cells in Your Tables 104 Adding Page Numbers to Your Documents 107 Summary 111 Exam Essentials 111 Key Terms 111 Review Questions 112 Chapter 3 Using Microsoft Excel 115 Navigating among Worksheets, Workbooks, and Cells 116 Navigating between Worksheets 117 Navigating between Cells 118 Changing the Alignment and the Positioning of Cells 122 Changing the Size of Cells 125 Formatting How Cells Are Displayed 128 Adding and Removing Rows and Columns 130 Merging or Unmerging Cells 133 Using Number Formats in Microsoft Excel Workbooks 135 Sorting and Filtering Data 137 Sorting Data 138 Filtering Data 140 Using Common Formulas and Functions 142 Using Mathematical Operators 143 Using Relative and Absolute References 145 Using Functions 148 Adding Charts and Graphs 151 Inserting a Line Chart 153 Inserting a Pie Chart 155 Inserting a Bar Graph 157 Summary 159 Exam Essentials 159 Key Terms 160 Review Questions 161 Chapter 4 Using Microsoft PowerPoint 163 Adding and Removing Slides When Creating Presentations 165 Changing the Order of Your Slides 168 Changing the Design and the Background of Your Presentations 169 Adding and Formatting the Text in Your Presentations 172 Changing the Layout of Your Slides 175 Adding Shapes and Pictures to Your Slides 177 Adding Tables to Your Presentations 180 Formatting the Tables in Your Presentations 183 Adding Charts to Your Presentations 186 Adding Video and Other Multimedia Files to Your Presentations 188 Adding Animations to Your Presentation 190 Setting Transitions between Slides and Viewing Your Presentations 193 Summary 195 Exam Essentials 196 Key Terms 196 Review Questions 197 Chapter 5 Using Microsoft Access 199 Adding, Modifying, and Removing Data in a Microsoft Access Database 200 Using Search in a Microsoft Access Database 205 Using Stored Queries in a Microsoft Access Database 208 Running Predefined Reports in a Microsoft Access Database 210 Creating Simple Reports in a Microsoft Access Database 211 Summary 217 Exam Essentials 218 Key Terms 218 Review Questions 219 Chapter 6 Collaborating with Others When Working in Microsoft Office 221 Adding Comments to Your Microsoft Office Files 222 Reviewing the Comments That Were Added to a Document 225 Tracking Changes in a Microsoft Word Document 226 Reviewing Changes in a Microsoft Word Document 228 Sharing Your Work Files Using Email 231 Storing Documents Using Network Attached Storage Solutions 234 Storing Documents Using Cloud Storage Solutions 236 Summary 238 Exam Essentials 238 Key Terms 239 Review Questions 240 Appendix A Answers to Review Questions 243 Appendix B Using the Practice Files 249 Index 253