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

IC3: Internet and Computing Core Certification Key Applications Study Guide is your ideal study guide when you want to focus on the Key Applications exam module in preparation for the IC3. This book covers common features and functions, word processing, spreadsheets, and presentations, all presented in a clear, concise style. Hands-on examples and self-paced exercises show you how to perform critical tasks needed to pass the exam, and the companion website offers a diverse set of study tools including the Sybex test engine, a preassessment test, hundreds of practice questions, videos, and access to over one hundred electronic flashcards. Test your skills and solidify your understanding of Key Applications for the IC3.

• Master the functions common to all programs, and the most common features
• Review the basics of word processing, with formatting and automation
• Understand spreadsheets, and how to manipulate data with formulas
• Brush up on the creation and formatting of simple presentations

When you are serious about certification, IC3 provides the practice that inspires self-confidence.

Ciprian Adrian Rusen is a recognized Windows Consumer Expert – Microsoft Most Valuable Professional (MVP). He has published several books about Windows and Microsoft Office, and he's an active tech blogger at http://www.7tutorials.com. At 7 Tutorials, he also provides complete tutorials for Windows, Windows Phone, and Xbox One users.

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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.