Module 4 - Spreadsheets

Spreadsheets provide the basis for the practice-based test in this module domain.

Who Should Attend

Anyone who is interested to get knowledge in Computers

Pre-requisites

ICDL - Module 3 Word Processing

Objective

Spreadsheets require the candidate to understand the basic concepts of spreadsheets and to demonstrate the ability to use a spreadsheet application on a personal computer. He or she shall understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. The candidate shall be able to accomplish standard mathematical and logical operations using basic formulas and functions. The candidate shall demonstrate competence in using some of the more advanced features of a spreadsheet application such as importing objects, and creating graphs and charts.

Duration

10 Training Hours

Exam Number

ICDL - Module 4 Test

Class Outline

• Getting Started

• First Steps with Spreadsheets

• Adjust Basic Settings

• Document Exchange

• Basic Operation

• Insert Data

•  Select Data

• Copy, Move, Delete

• Search and Replace

• Rows and Columns

• Sort Data

• Formulas & Functions

• Arithmetic and Logical Formulas

• Working with Functions

• Formatting

• Format Cells Numbers

• Format Cells Text

• Format Cells Cell Ranges

• Spelling

• Document Setup

• Printing

• Printing Simple Spreadsheet Document

• More Advanced Features

• Importing Objects

• Charts and Graphs