User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
International Computer Driving License 4.0 XP U.S. Series: Spreadsheets
Product Code: i4us04 Time: 9.0 hour(s) CEUs: Available

Summary:

After taking this course, the learner will be able to work with a spreadsheet application to insert and manipulate data. The learner will also be able to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts. This course describes how to meet International Computer Driving License 4.0 XP U.S. (ICDL) objectives using Microsoft Excel on a personal computer that uses a Windows operating system. The ECDL/ICDL test can be taken with any spreadsheet application, and although this course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

Objectives:

  • Open, revise, close, and print a spreadsheet
  • Insert, select, copy, move, and delete data
  • Search, replace, sort, and format data
  • Use, create, and copy both formulas and functions (e.g., SUM, AVERAGE, and IF)
  • Import an object and text file into a spreadsheet
  • Create, adjust, move, and delete a chart


Topics:

  • Opening and closing spreadsheets
  • Creating and saving spreadsheets
  • Using help
  • Adjusting settings
  • Cells
  • Rows and columns
  • Editing data
  • Copying data
  • Moving and deleting data
  • Find and replace
  • Sorting data
  • Handling worksheets
  • Working with formulas
  • Cell referencing
  • Working with functions
  • The IF function
  • Formatting numbers and dates
  • Formatting cell contents
  • Working with alignments and border effects
  • Creating charts and graphs
  • Editing charts and graphs
  • Worksheet setup
  • Printing worksheets

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.