ECDL / ICDL Courseware from
Cheltenham
Computer
Training
|
ECDL / ICDL Courseware from |
|
|
|
|
|
|
|
|
| ECDL / ICDL Module 4 Goals |
Page-1 |
| 4.1 Getting Started |
Page-2 |
| 4.1.1 - First Steps With Spreadsheets - ECDL / ICDL Skill Set |
Page-3 |
| 4.1.1.1 Open a Spreadsheet Application. |
Page-4 |
| 4.1.1.2 Open an Existing Spreadsheet - Make Some Modifications and Save. |
Page-5 |
| 4.1.1.3 Open Several Spreadsheets. |
Page-6 |
| 4.1.1.4 Create a New Spreadsheet and Save. |
Page-7 |
| 4.1.1.5 Save an Existing Spreadsheet onto the Hard Disk or a Diskette. |
Page-8 |
| 4.1.1.6 Close the Spreadsheet. |
Page-9 |
| 4.1.1.7 Use Application Help Functions. |
Page-10 |
| 4.1.2 - Adjust Basic Settings - ECDL / ICDL Skill Set |
Page-11 |
| 4.1.2.1 Change Spreadsheet View Mode. |
Page-12 |
| 4.1.2.2 Use the Page View Magnification Tool/Zoom Tool. |
Page-13 |
| 4.1.2.3 Modify Toolbar Display. |
Page-14 |
| 4.1.3 - Document Exchange - ECDL / ICDL Skill Set |
Page-15 |
| 4.1.3.1 Save an Existing Spreadsheet Under Another File Format: Txt File, Document Template, Software Type or Version Number Etc. |
Page-16 |
| 4.1.3.2 Save a Document In a Format Appropriate For Posting to a Web Site. |
Page-17 |
| 4.2 Basic Operations |
Page-18 |
| 4.2.1 - Insert Data - ECDL / ICDL Skill Set |
Page-19 |
| 4.2.1.1 Enter Numbers In a Cell. |
Page-20 |
| 4.2.1.2 Enter Text In a Cell. |
Page-21 |
| 4.2.1.3 Enter Symbols or Special Characters In a Cell. |
Page-22 |
| 4.2.1.4 Enter Simple Formulas In a Cell. |
Page-23 |
| 4.2.1.5 Use the Undo Command. |
Page-24 |
| 4.2.2 - Select Data - ECDL / ICDL Skill Set |
Page-25 |
| 4.2.2.1 Select a Cell or Range Of Adjacent or Non-Adjacent Cells. |
Page-26 |
| 4.2.2.2 Select a Row or Column. Select a Range Of Adjacent or Non-Adjacent Rows or Columns. |
Page-27 |
| 4.2.3 - Copy, Move, Delete - ECDL / ICDL Skill Set |
Page-28 |
| 4.2.3.1 Use the Copy and Paste Tools to Duplicate Cell Contents In Another Part Of a Worksheet. |
Page-29 |
| 4.2.3.2 Use the Cut and Paste Tools to Move Cell Contents Within Worksheet. |
Page-30 |
| 4.2.3.3 Move Cell Contents Between Active Worksheets. |
Page-31 |
| 4.2.3.4 Move Cell Contents Between Active Spreadsheets. |
Page-32 |
| 4.2.3.5 Delete Cell Contents In a Selected Cell Range. |
Page-33 |
| 4.2.4 - Search and Replace - ECDL / ICDL Skill Set |
Page-34 |
| 4.2.4.1 Use the Search Command For Specified Cell Content. |
Page-35 |
| 4.2.4.2 Use the Replace Command For Specified Cell Content. |
Page-36 |
| 4.2.5 - Rows and Columns - ECDL / ICDL Skill Set |
Page-37 |
| 4.2.5.1 Insert Rows and Columns. |
Page-38 |
| 4.2.5.2 Modify Column Width and Row Height. |
Page-39 |
| 4.2.5.3 Delete Selected Rows or Columns. |
Page-40 |
| 4.2.6 - Sort Data - ECDL / ICDL Skill Set |
Page-41 |
| 4.2.6.1 Sort Selected Data In Ascending or Descending Numeric Order. |
Page-42 |
| 4.2.6.2 Sort Selected Data In Ascending or Descending Alphabetic Order. |
Page-43 |
| 4.3 Formulas and Functions |
Page-44 |
| 4.3.1 - Arithmetic and Logical Formulas - ECDL / ICDL Skill Set |
Page-45 |
| 4.3.1.1 Use Basic Arithmetic and Logical Formulas In a Spreadsheet Addition, Subtraction, Multiplication, Division. |
Page-46 |
| 4.3.1.2 Recognize Standard Error Messages Associated With Formulas. |
Page-47 |
| 4.3.1.3 Use the Autofill Tool/Copy Handle Tool to Copy or Increment Data Entries. |
Page-48 |
| 4.3.1.4 Understand and Use Relative Cell Referencing In Formulas or Functions. |
Page-49 |
| 4.3.1.5 Understand and Use Absolute Cell Referencing In Formulas or Functions. |
Page-50 |
| 4.3.2 - Working With Functions - ECDL / ICDL Skill Set |
Page-51 |
| 4.3.2.1 Use the Sum Function. |
Page-52 |
| 4.3.2.2 Use the Average Function. |
Page-53 |
| 4.4 Formatting |
Page-54 |
| 4.4.1 - Format Cells - Numbers - ECDL / ICDL Skill Set |
Page-55 |
| 4.4.1.1 Format Cells to Display Different Number Styles: Number Of Decimal Places, Number Of Zeros After the Decimal Point, With or Without Commas to Indicate Thousands. |
Page-56 |
| 4.4.1.2 Format Cells to Display Different Date Styles. |
Page-57 |
| 4.4.1.3 Format Cells to Display Different Currency Symbols. |
Page-58 |
| 4.4.1.4 Format Cells to Display Numbers As Percent-Ages. |
Page-59 |
| 4.4.2 - Format Cells - Text - ECDL / ICDL Skill Set |
Page-60 |
| 4.4.2.1 Change Text Size. Format Text: Bold, Italic, Font Type. |
Page-61 |
| 4.4.2.2 Change Text Font Colour. |
Page-62 |
| 4.4.2.3 Adjust Text Orientation. |
Page-63 |
| 4.4.3 - Format Cells - Cell Ranges - ECDL / ICDL Skill Set |
Page-64 |
| 4.4.3.1 Centre and Align Cell Contents In a Selected Cell Range: Left and Right; Top and Bottom. |
Page-65 |
| 4.4.3.2 Add Border Effects to a Selected Cell Range. |
Page-66 |
| 4.4.4 - Spelling - ECDL / ICDL Skill Set |
Page-67 |
| 4.4.4.1 Use a Spell-Check Program and Make Changes Where Necessary. |
Page-68 |
| 4.4.5 - Document Setup - ECDL / ICDL Skill Set |
Page-69 |
| 4.4.5.1 Modify Document Margin Settings. |
Page-70 |
| 4.4.5.2 Adjust Document Setup to Fit One Page. |
Page-71 |
| 4.4.5.3 Add a Header and Footer. |
Page-72 |
| 4.4.5.4 Change Document Orientation - Portrait or Landscape, Page Size Etc. |
Page-73 |
| 4.5 Printing |
Page-74 |
| 4.5.1 - Printing Simple Spreadsheet Documents - ECDL / ICDL Skill Set |
Page-75 |
| 4.5.1.1 Use Basic Print Options. |
Page-76 |
| 4.5.1.2 Preview a Spreadsheet. |
Page-77 |
| 4.5.1.3 Print a Spreadsheet or a Worksheet. |
Page-78 |
| 4.5.1.4 Print Part Of a Worksheet or a Pre-Defined Cell Range. |
Page-79 |
| 4.6 More Advanced Features |
Page-80 |
| 4.6.1 - Importing Objects - ECDL / ICDL Skill Set |
Page-81 |
| 4.6.1.1 Import Objects into a Spreadsheet: Image Files, Graphs, Text Files Etc. |
Page-82 |
| 4.6.1.2 Move and Resize Imported Objects Within a Spreadsheet. |
Page-83 |
| 4.6.2 - Charts and Graphs - ECDL / ICDL Skill Set |
Page-84 |
| 4.6.2.1 Produce Different Types Of Charts and Graphs From Spreadsheet Figures to Analyse Data, E.G. Pie Charts, Column Charts, Bar Charts. |
Page-85 |
| 4.6.2.2 Edit or Modify a Chart or Graph: Add a Title or Label, Change the Scale. Modify the Colours In the Chart or Graph. |
Page-86 |
| 4.6.2.3 Change the Chart Type. |
Page-87 |
| 4.6.2.4 Move and Delete Charts or Graphs. |
Page-88 |
|
ECDL / ICDL Courseware from |
|
|
|
|
|
|
|
|
© 2000 Copyright Cheltenham Computer
Training
No unauthorized use, modification, copying
or editing allowed http://www.cctglobal.com