|
    
Excel
Aim: The aim of this unit is to ensure that each participant can
use spreadsheets as detailed below:
- access a spreadsheet system/package
- enter text
- edit text
- open an existing file
- format text
- enter various formulae…sum, min, max, average, etc.
- edit formulae
- copy formulae
- save files within the system
- preview a document
- apply formatting options …currency, number, 0,2 decimals etc.
- make corrections to a document
- insert charts, pie bar & column
- print documents
- exit from the spreadsheet system using proper procedures.
- work with several open spreadsheets
- Make cell references absolute when required
· Worksheets
Basic
Exercise 1 | Basic
Exercise 2 | Basic
Exercise 3 | Basic
Exercise 4 | Basic
Exercise 5 |
Basic
Exercise 6 |
· Additional Worksheets
These notes act as a support to a training programme. Anyone competing
an ICT programme will find them an essential tool.
|