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

by Ciprian Adrian Rusen

Overview

Master word processing, spreadsheets, and presentations ahead of the IC3 exam

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.

Product Details

ISBN-13:	9781118991725
Publisher:	Wiley
Publication date:	04/27/2015
Edition description:	Study Guide
Pages:	300
Product dimensions:	7.30(w) x 9.20(h) x 0.80(d)

About the Author

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.

Read an Excerpt

Click to read or download

Table of Contents

Inroduction 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 Application 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 Basic of Using Microsoft Office Applications 18

Keyboard Shortcuts for Using the Ribbon Productivity 18

Selecting, Copying, and Moving Data When Using Microsoft Office Application 22

Dragging and Dropping Data When Using Microsoft Office Applications 31

Finding and Replacing Data in Your Microsoft Office Document 32

Checking the Spelling of Your Microsoft Office Document 35

Undoing Your Changes and Mistakes When Working with Microsoft Office Document 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 Way You View Microsoft Office Files 45

Adjusting the Size and the Orientation of Your Microsoft Office Files 49

Printing Your Document 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 Picture 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 Document 76

Adjusting Line and Paragraph Spacing in Your Document 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 Document 87

Indenting Text in Your Documents 88

Using Tabs to Control Where the Text Is Placed in Your Document 92

Organizing the Data in Your Document 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

Formating 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 Relatives 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 Garph 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 Presentation 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 Presention 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 Document Using Networks Attached Storage Solutions 234

Storing Document Using Cloud Storage Solutions 236

Summary 236

Exam Essentials 238

Key Terms 239

Review Questions 240

Appendix A Answer to Review Questions 243

Appendix B Using the Practice Files 249

Index 253