IC3: Internet and Computing Core Certification Key Applications Global Standard 4 Study Guide. Ciprian Adrian Rusen

>Ciprian Adrian Rusen

      IC3® Internet and Computing Core Certification Key Applications Global Standard 4

      IC^3® Internet and Computing Core Certification Key Applications Global Standard 4

      Study Guide

      Ciprian Adrian Rusen

      Senior Acquisitions Editor: Ken Brown

      Development Editor: Tom Cirtin

      Technical Editor: Vlad Falon

      Production Editor: Dassi Zeidel

      Copy Editor: Linda Recktenwald

      Editorial Manager: Mary Beth Wakefield

      Production Manager: Kathleen Wisor

      Associate Publisher: Jim Minatel

      Supervising Producer: Rich Graves

      Book Designers: Judy Fung and Bill Gibson

      Proofreader: Kim Wimpsett

      Indexer: Ted Laux

      Project Coordinator, Cover: Brent Savage

      Cover Designer: Wiley

      Cover Image: ©Getty Images, Inc./Jeremy Woodhouse

      Copyright © 2015 by John Wiley & Sons, Inc., Indianapolis, Indiana

      Published simultaneously in Canada

      ISBN: 978-1-118-99173-2 (ebk.)

      ISBN: 978-1-118-99174-9 (ebk.)

      No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone]. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at http://www.wiley.com/go/permissions.

      Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Web site may provide or recommendations it may make. Further, readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this work was written and when it is read.

      For general information on our other products and services or to obtain technical support, please contact our Customer Care Department within the U.S. at [phone], outside the U.S. at [phone] or fax [phone].

      Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.

      Library of Congress Control Number: 2015936361

      TRADEMARKS: Wiley and the Sybex logo are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. IC³ is a registered trademark of Certiport, Inc. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.

      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 also a very active tech blogger at http://www.7tutorials.com.

      On his website you can find many tutorials about Windows 7, Windows 8.1, and Windows 10. He and his team of editors also publish how-to guides about other Microsoft products like Windows Phone and Xbox One. If you would like to keep up to date with the latest Microsoft consumer products, you should subscribe to his blog.

      Introduction

      Welcome to the IC3 Internet and Computing Core Certification Key Applications Study Guide for the IC3 Digital Literacy Certification. The purpose of this book is to help you prepare for the Key Applications certification exam, which covers four major types of applications: word processing, spreadsheet, presentation, and database software. You will learn the common features of these types of applications, how to perform all kinds of tasks (opening and saving files, formatting them, printing them, and so on), and how to collaborate with others to create all kinds of business documents and files.

      The book contains all of the information you need to pass the Key Applications exam. It also includes notes and warnings from the author to help reduce issues you may be experiencing in your own environment. By studying for and passing this exam, you will gain insight that will make you more valuable in your current position and will make you more likely to be recognized.

      In the remainder of this section we will look at some of the facts about the exam, give some commonsense tips for taking the exam, and review the process for registering for the exam.

Exam Facts

      Individuals seeking IC3 certification are required to take and pass all three IC3 exams: Computing Fundamentals, Key Applications, and Living Online. Here are some facts about them:

      ■ The IC3 exams are administered by Certiport and are taken at Certiport Authorized Testing Centers.

      ■ The exams are based on Microsoft Windows 7 and Microsoft Office 2010.

      ■ There are 45 multiple-choice questions for each exam.

      ■ There is a time limit of 50 minutes for each exam.

      ■ Each exam has a maximum score of 1000.

      ■ The minimum passing score could range from 620 in difficult tests to 720 on easier tests.

      ■ There is a short survey before the exam begins (taking the survey does not use any of the available 50 minutes).

      ■ If you do not pass the exam, you can retake it as many times as you want, but you must wait 24 hours before taking the exam a second time. If you do not pass the exam again, a two-day waiting period will be imposed for each subsequent exam retake.

Tips for Taking the IC3 GS4 Exams

      Here are some general tips for improving the odds of passing your certification exam:

      ■ Read each question carefully. Although the test is not written to be confusing there are times when the obvious choice is not the correct choice.

      ■ Make sure you answer each question. Any unanswered questions are considered wrong, so you are better off making an educated guess than leaving a question unanswered.

      ■