JSS3 Second Term Internet and Communication Technology (ICT) Lesson Note – Worksheet I

The content is just an excerpt from the complete note for JSS3 Second Term Internet and Communication Technology (ICT) Lesson Note – Worksheet I. Check below to download the complete DOCUMENT

WEEK 4

TOPIC: WORKSHEET I

Sub-Topic 1: Definition of a Worksheet:

A Worksheet can be defined as the working area of the program where entering of data and calculations are handled. It consists of rows, columns, cells and a cell pointer.

Starting Excel worksheet: This entails the following

(i) opening a worksheet  (ii) Data entry   (iii) Editing    (iv) saving     (v) Retrieving worksheet

Opening a worksheet:

To create a new worksheet, follow the steps below:

1. Open Microsoft Excel from the Start button
2. Click on Office button to display a sub menu
3. Select New
4. Click on Create
5. A new workbook will be displayed.

Method II:

1. Open Microsoft Excel
2. Press Ctrl + N

Data Entry:

There are three types of data that can be entered into an excel worksheet. These are Labels, Numbers and Formula.

Labels are made up of texts that are entered into the active worksheet. Examples are letters of alphabets (A-Z) 

Numbers / values consists of numerals 0 – 9

Formulas are mathematical expressions which return calculated value.

A typical example of data entry is shown below;

To gain full access to the note: DOWNLOAD FILE