Cheltenham Courseware

[pic]
For ICDL Syllabus 4: Based on Windows 2000 / XP & Microsoft Office XP /
2003.
Over 1800 practice questions: Over 140 handout pages.
© 1995-2008 Cheltenham Courseware Pty. Ltd. All trademarks acknowledged. E&OE. No part of this document may be copied without written permission from
Cheltenham Courseware unless produced under the terms of a courseware site
license agreement with Cheltenham Courseware. All reasonable precautions have been taken in the preparation of this
document, including both technical and non-technical proofing. Cheltenham
Courseware and all staff assume no responsibility for any errors or
omissions. No warranties are made, expressed or implied with regard to
these notes. Cheltenham Courseware shall not be responsible for any direct,
incidental or consequential damages arising from the use of any material
contained in this document. If you find any errors in these training
modules, please inform Cheltenham Courseware. Whilst every effort is made
to eradicate typing or technical mistakes, we apologise for any errors you
may detect. All courses are updated on a regular basis, so your feedback is
both valued by us and will help us to maintain the highest possible
standards. Sample versions of courseware from Cheltenham Courseware
(Normally supplied in Adobe Acrobat format): If the version of courseware
that you are viewing is marked as NOT FOR TRAINING, SAMPLE, or similar,
then it cannot be used as part of a training course, and is made available
purely for content and style review. This is to give you the opportunity to
preview our courseware, prior to making a purchasing decision. Sample
versions may not be re-sold to a third party. For current license information
This document may only be used under the terms of the license agreement
from Cheltenham Courseware. Cheltenham Courseware reserves the right to
alter the licensing conditions at any time, without prior notice. Please
see the site license agreement available at:
www.cheltenhamcourseware.com.au/agreement Contact Information Australia / Asia Pacific / Europe (ex. UK/Ireland) / Rest of the World
Email: info@cheltenhamcourseware.com.au
Web: www.cheltenhamcourseware.com.au USA / Canada
Email: info@cheltenhamcourseware.com
Web: www.cheltenhamcourseware.com UK / Ireland
Email: info@cctglobal.com
Web: www.cctglobal.com [pic] ICDL Practice Sessions:
Approved Courseware 7
Understanding the formatting used within this document 8
Compare the practice sessions with the official ICDL syllabus 9
The purpose of these practice sessions 10 ICDL Module One - Using the Computer & Managing Files 11 Syllabus Section 1.1a - General Concepts - Multiple Choice 12
Syllabus Section 1.1b - General Concepts - Multiple Choice 13
Syllabus Section 1.2a - Hardware - Multiple Choice 14
Syllabus Section 1.2b - Hardware - Theory 15
Syllabus Section 1.3a - Software - Multiple Choice 16
Syllabus Section 1.3b - Software - Practice Session 17
Syllabus Section 1.4a - Information Networks - Multiple Choice 18
Syllabus Section 1.4b - Information Networks - Quick Quiz 19
Syllabus Section 1.5a - IT in Everyday Life - Quick Quiz 20
Syllabus Section 1.6a - Health, Safety & the Environment - Quick Quiz 21
Syllabus Section 1.7a - Security - Quick Quiz 22
Syllabus Section 1.8a - Copyright & the Law - Quick Quiz 23 ICDL Module One - Complete Quizzes 25 ICDL Module One: Complete Module Quiz (1) 26
ICDL Module One: Complete Module Quiz (2) 27
ICDL Module One: Complete Module Quiz (3) 28
ICDL Module One: Complete Module Crossword Quiz 29
ICDL Module One: Complete Module Crossword Solution 30 ICDL Module Two - Concepts of Information Technology 31 Syllabus Section 2.1a - Computer Environment - Multiple Choice 32
Syllabus Section 2.1b - Computer Environment - Practice Session 33
Syllabus Section 2.2a - The Desktop - Multiple Choice 34
Syllabus Section 2.2b - The Desktop - Practice Session 35
Syllabus Section 2.3a - Managing Files - Multiple Choice 36
Syllabus Section 2.3b - Managing Files - Practice Session 37
Syllabus Section 2.3c - Managing Files - Practice Session 38
Syllabus Section 2.4a - Viruses - Quick Quiz 39
Syllabus Section 2.5a - Print Management - Practice Session 40 ICDL Module Two - Complete Quizzes 41 ICDL Module Two: Complete Module Quiz (1) 42
ICDL Module Two: Complete Module Quiz (2) 43
ICDL Module Two: Complete Module Crossword Quiz 44
ICDL Module Two: Complete Module Crossword Solution 45 ICDL Module Three - Word Processing 47 Syllabus Section 3.1a - Using Microsoft Word - Toolbar Buttons 48
Syllabus Section 3.1b - Using Microsoft Word - Shortcuts 49
Syllabus Section 3.1c - Using Microsoft Word - Practice Session 50
Syllabus Section 3.1d - Using Microsoft Word - Practice Session 51
Syllabus Section 3.2a - Main Operations - Shortcuts & Toolbar Buttons 52
Syllabus Section 3.2b - Main Operations - Practice Session 53
Syllabus Section 3.2c - Main Operations - Practice Session 54
Syllabus Section 3.3a - Formatting - Toolbar Buttons 55
Syllabus Section 3.3b - Formatting - Shortcuts 56
Syllabus Section 3.3c - Formatting - Multiple Choice 57
Syllabus Section 3.3d - Formatting - Practice Session 58
Syllabus Section 3.3e - Formatting - Practice Session 59
Syllabus Section 3.3f - Formatting - Practice Session 60
Syllabus Section 3.3g - Formatting - Practice Session 61
Syllabus Section 3.3h - Formatting - Practice Session 62
Syllabus Section 3.4a - Objects - Toolbar Buttons 63
Syllabus Section 3.4b - Objects - Shortcuts 64
Syllabus Section 3.4c - Objects - Practice Session 65
Syllabus Section 3.4d - Objects - Practice Session 66
Syllabus Section 3.5a - Mail Merge - Toolbar Buttons 67
Syllabus Section 3.5b - Mail Merge - Shortcuts 68
Syllabus Section 3.5c - Mail Merge - Practice Session 69
Syllabus Section 3.6a - Printing Issues - Shortcuts & Toolbar Buttons 70
Syllabus Section 3.6b - Printing Issues - Practice Session 71 ICDL Module Three - Complete Quizzes 73 ICDL Module Three: Complete Module Quiz (1) 74
ICDL Module Three: Complete Module Quiz (2) 75
ICDL Module Three: Complete Module Crossword Quiz 76
ICDL Module Three: Complete Module Crossword Solution 77 ICDL Module Four - Spreadsheets 79 Syllabus Section 4.1a - Using Microsoft Excel - Toolbar Buttons 80
Syllabus Section 4.1b - Using Microsoft Excel - Shortcuts 81
Syllabus Section 4.1c - Using Microsoft Excel - Practice Session 82
Syllabus Section 4.1d - Using Microsoft Excel - Practice Session 83
Syllabus Section 4.2a - Cells - Shortcuts & Toolbar Buttons 84
Syllabus Section 4.2b - Cells - Practice Session 85
Syllabus Section 4.2c - Cells - Practice Session 86
Syllabus Section 4.2d - Cells - Practice Session 87
Syllabus Section 4.3a - Worksheets - Shortcuts 88
Syllabus Section 4.3b - Worksheets - Practice Session 89
Syllabus Section 4.4a - Formulas & Functions - Shortcuts & Toolbar Buttons
90
Syllabus Section 4.4b - Formulas & Functions - Practice Session 91
Syllabus Section 4.4c - Formulas & Functions - Practice Session 92
Syllabus Section 4.5a - Formatting - Toolbar Buttons 93
Syllabus Section 4.5b - Formatting - Shortcuts 94
Syllabus Section 4.5c - Formatting - Practice Session 95
Syllabus Section 4.5d - Formatting - Practice Session 96
Syllabus Section 4.5e - Formatting - Practice Session 97
Syllabus Section 4.6a - Charts - Shortcuts & Toolbar Buttons 98
Syllabus Section 4.6b - Charts - Practice Session 99
Syllabus Section 4.6b - Charts - Practice Session 100
Syllabus Section 4.7a - Preparing Outputs - Shortcuts & Toolbar Buttons
101
Syllabus Section 4.7b - Preparing Outputs - Practice Session 102 ICDL Module Four - Complete Quizzes 103 ICDL Module Four: Complete Module Quiz (1) 104
ICDL Module Four: Complete Module Quiz (2) 105
ICDL Module Four: Complete Module Quiz (3) 106
ICDL Module Four: Complete Module Crossword Quiz 107
ICDL Module Four: Complete Module Crossword Solution 108 ICDL Module Five - Database 109 Syllabus Section 5.1a - Using Microsoft Access - Shortcuts & Toolbar
Buttons 110
Syllabus Section 5.1b - Using Microsoft Access - Quick Quiz 111
Syllabus Section 5.1c - Using Microsoft Access - Practice Session 112
Syllabus Section 5.2a - Tables - Practice Session 113
Syllabus Section 5.2b - Tables - Practice Session 114
Syllabus Section 5.2c - Tables - Practice Session 115
Syllabus Section 5.3a - Forms - Practice Session 116
Syllabus Section 5.4a - Retrieving Information - Practice Session 117
Syllabus Section 5.4b - Retrieving Information - Practice Session 118
Syllabus Section 5.4c - Retrieving Information - Practice Session 119
Syllabus Section 5.5a - Reports - Practice Session 120
Syllabus Section 5.5b - Reports - Practice Session 121
Syllabus Section 5.6a - Printing Issues - Practice Session 122 ICDL Module Five - Complete Quizzes 123 ICDL Module Five: Complete Module Quiz (1) 124
ICDL Module Five: Complete Module Quiz (2) 125
ICDL Module Five: Complete Module Crossword Quiz 126
ICDL Module Five: Complete Module Crossword Solution 127 ICDL Module Six Presentation 129 Syllabus Section 6.1a - Using PowerPoint - Shortcuts & Toolbar Buttons
130
Syllabus Section 6.1b - Using PowerPoint - Practice Session 131
Syllabus Section 6.1c - Using PowerPoint - Practice Session 132
Syllabus Section 6.2a - Developing Presentations - Shortcuts & Toolbar
Buttons 133
Syllabus Section 6.2b - Developing Presentations - Practice Session
134
Syllabus Section 6.2c - Developing Presentations - Practice Session
135
Syllabus Section 6.3a - Text & Images - Toolbar Buttons 136
Syllabus Section 6.3b - Text & Images - Shortcuts 137
Syllabus Section 6.3c - Text & Images - Practice Session 138
Syllabus Section 6.3d - Text &