Ecdl/Icdl Syllabus 4 Module 4 Spreadsheets Using Excel XP: European Computer Driving Licence

Front Cover
CIA Training Ltd., 2003 - Computers - 152 pages
Module 4 ECDL/ICDL Syllabus 4.0. This manual helps you learn how to design spreadsheets, how to use basic functions to perform calculations within your spreadsheet and how to create and format charts. The manual comes with its own data files which you use for practising the relevant exercises. Approved by the ECDL Foundation.
 

Selected pages

Contents

GETTING STARTED
7
STARTING EXCEL
8
2 THE EXCEL SCREEN
9
CONTINUED
10
3MENUS
11
4TOOLBARS
12
5 THE WORKSHEET WINDOW
14
6 MOVING AROUND
15
60PRINT TITLES
88
61PRINT OPTIONS
89
62DISPLAYING PRINTING FORMULAS 63 REVISION
91
64REVISION
92
FORMATTING
93
65FORMATTING
94
66 BOLD UNDERLINE ITALIC
95
67 FONTS FONT SIZE
96

7 HELP
16
8THE OFFICE ASSISTANT
18
9 PREFERENCES
20
10CLOSING EXCEL
22
11 REVISION
23
12 REVISION
24
OPEN AND CLOSE WORKBOOKS
25
13OPENING A WORKBOOK
26
14 CLOSING A WORKBOOK
27
15 USING SCROLL BARS
28
16 OPENING MULTIPLE WORKBOOKS
29
17 REVISION
30
CREATING AND SAVING WORKBOOKS
31
STARTING A NEW WORKBOOK
32
19ENTERING LABELS
33
20ENTERING NUMBERS
34
21SAVING A NEW WORKBOOK
35
22SAVING A NAMED WORKBOOK
36
23SAVING IN DIFFERENT FORMATS
37
24SAVING AS WEB PAGE
38
39INSERTING AND DELETING SHEETS
39
25REVISION
40
26 REVISION
41
27REVISION
42
FORMULAS
43
28 FORMULAS
44
BRACKETS
45
30AUTOSUM
46
47MOVING CELLS
47
31CHECKING FOR ERRORS
48
49REPLACING TEXT
49
32REVISION
50
33REVISION
51
34REVISION
52
53REVISION
53
PRINTING
79
54PRINTING
80
55PRINT PREVIEW
81
56PAGE SETUP
83
57MARGINS
84
58PRINTING A SELECTION
85
59HEADERS AND FOOTERS
86
68FORMAT NUMBER
97
69DATES
99
70ALIGNMENT
101
71CHANGING COLUMN WIDTH
102
72CHANGING ROW HEIGHT
103
73
104
74
105
75
106
76
108
77
109
78
110
79
111
80
112
81
113
82
114
FUNCTIONS ADDRESSING
115
83FUNCTIONS
116
84
117
85
118
86
119
RELATIVE ADDRESSING
120
88
121
89
122
90
124
91
125
92
126
CHARTS
127
93 INTRODUCING CHARTS
128
CREATING CHARTS
129
EMBEDDED Charts
131
མཛ༦༤ཕིཎྜ 96
132
97
134
98PRINTING CHARTS
136
99
137
100
138
101REVISION
139
ANSWERS
140
GLOSSARY
142
INDEX
143
RECORD OF ACHIEVEMENT MATRIX
145
95
148
Copyright

Other editions - View all

Ecdl/Icdl Syllabus 4 Module 4 Spreadsheets Using Excel 2003
Cia Training Ltd Staff
Limited preview - 2004

Common terms and phrases

active cell Alignment Border calculation cell A1 cell B3 Check Click and drag Click OK Click on cell Clipboard Close the workbook colour completing this Revision Computer covers the features Ctrl cursor default Delete dialog box difficulty completing display Double click Driving Lesson covers ECDL embedded chart experienced any difficulty features introduced Fill Handle Font Footer Formatting Toolbar Formula Bar Header Highlight the range labels Leave the workbook Lessons while completing Manoeuvres Microsoft Excel Move to cell Office Assistant OK Cancel Open the workbook open workbooks Paper size Park and Read preceding Driving Lessons Press Enter Print Preview redo the Revision Revision Exercise(s Revision refer back Revision This Driving row height Sales Save the workbook screen scroll bar Select cell Select File select Format Select the range Setup sheet tab Smart Tag spreadsheet Standard Toolbar Task Pane Taskbar Undo Window workbook open workbook without saving Zoom

Bibliographic information

TitleEcdl/Icdl Syllabus 4 Module 4 Spreadsheets Using Excel XP: European Computer Driving Licence
Volume 4 of Ecdl Series
AuthorCia Training Ltd Staff
Editionillustrated
PublisherCIA Training Ltd., 2003
ISBN1860051324, 9781860051326
Length152 pages
Subjects › 

Computers / General
  
Export CitationBiBTeX EndNote RefMan