Ecdl/Icdl Syllabus 4 Module 4 Spreadsheets Using Excel 2003CIA Training Ltd., 2004 This comprehensive manual covers all aspects required by Module 4 ECDL/ICDL Syllabus 4.0. Data files are supplied with the manual which allow practice of the different software features. It is approved by the ECDL Foundation. |
Contents
GETTING STARTED | 7 |
1STARTING EXCEL | 8 |
2 THE EXCEL SCREEN | 10 |
3MENUS | 11 |
4TOOLBARS | 12 |
5 THE WORKSHEET WINDOW | 14 |
6 MOVING AROUND | 15 |
7HELP | 16 |
29BRACKETS | 45 |
30AUTOSUM | 46 |
47MOVING CELLS | 47 |
31CHECKING FOR ERRORS | 48 |
49REPLACING TEXT | 49 |
32REVISION | 50 |
33REVISION | 51 |
34REVISION | 52 |
8THE OFFICE ASSISTANT | 18 |
9PREFERENCES | 20 |
10CLOSING EXCEL | 22 |
11 REVISION | 23 |
12REVISION | 24 |
OPEN AND CLOSE WORKBOOKS | 25 |
13OPENING A WORKBOOK | 26 |
14 CLOSING A WORKBOOK | 27 |
15USING SCROLL BARS | 28 |
16OPENING MULTIPLE WORKBOOKS | 29 |
17REVISION | 30 |
CREATING AND SAVING WORKBOOKS | 31 |
18STARTING 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 |
26REVISION | 41 |
27REVISION | 42 |
FORMULAS | 43 |
28FORMULAS | 44 |
53REVISION | 53 |
PRINTING | 79 |
54PRINTING | 80 |
55PRINT PREVIEW | 81 |
56PAGE SETUP | 83 |
57MARGINS | 84 |
58PRINTING A SELECTION | 85 |
59HEADERS AND FOOTERS | 86 |
60PRINT TITLES | 88 |
61PRINT OPTIONS | 89 |
62DISPLAYING PRINTING FORMULAS 63REVISION | 91 |
64REVISION | 92 |
FORMATTING | 93 |
FORMATTING | 94 |
66 BOLD UNDERLINE ITALIC | 95 |
67FONTS FONT SIZE | 96 |
68FORMAT NUMBER | 97 |
69DATES | 99 |
70ALIGNMENT | 101 |
53 | 110 |
60 | 144 |
79 | 147 |
ྣཛཉྙནྣཆེ 3 | 148 |
100 | 149 |
Other editions - View all
Common terms and phrases
active cell Alignment AutoSum button Border calculation cell A1 cell B3 Check click and drag Click OK Click on cell click the AutoSum Close the workbook colour completing this Revision Computer covers the features cursor default Delete dialog box difficulty completing display Double click Driving Lesson covers ECDL Edit embedded chart experienced any difficulty features introduced Fill Handle Font Formatting Toolbar Formula Bar function Header Highlight the range Insert labels Leave the workbook Lessons while completing Manoeuvres Microsoft Excel Microsoft Office Excel Move to cell Office Assistant OK Cancel Open the workbook open workbooks Options Paper size Park and Read preceding Driving Lessons Press Enter Print Preview redo the Revision Revision Exercise(s Revision refer back Revision This Driving Save the workbook screen scroll bar Select cell Select File select Format Select the range Setup sheet tab spreadsheet Task Pane Taskbar Window workbook open workbook without saving Zoom