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

Author:   Ciprian Rusen
Publisher:   John Wiley & Sons Inc
ISBN:  

9781118991725


Pages:   300
Publication Date:   29 May 2015
Format:   Paperback
Availability:   To order   Availability explained
Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us.

Our Price $32.95 Quantity:  
Add to Cart

Share |

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


Add your own review!

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.

Full Product Details

Author:   Ciprian Rusen
Publisher:   John Wiley & Sons Inc
Imprint:   Sybex Inc.,U.S.
Dimensions:   Width: 18.60cm , Height: 1.60cm , Length: 23.20cm
Weight:   0.526kg
ISBN:  

9781118991725


ISBN 10:   1118991729
Pages:   300
Publication Date:   29 May 2015
Audience:   Adult education ,  Further / Higher Education
Format:   Paperback
Publisher's Status:   Active
Availability:   To order   Availability explained
Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us.

Table of Contents

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

Reviews

Author Information

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.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions
Latest Reading Guide

MDRG1

 VIEW OUR LATEST READING GUIDE HERE 

Shopping Cart
Your cart is empty
Shopping cart
Mailing List