Categories: Lesson Notes

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

Sunday

Share
Published by
Sunday

Recent Posts

CSC 225 Theory Questions: System Analysis And Implementation – Difference Between Validation And Verification

200 Level Computer Science exam questions and the detailed answers. Download the answers in document…

9 hours ago

CSC 225 Theory Question: Major Network Communication Models – Code Selection

200 Level Computer Science exam questions and the detailed answers. Download the answers in document…

10 hours ago

CSC 225 Theory Questions: Phases Of System Analysis An Design

200 Level Computer Science exam questions and the detailed answers. Download the answers in document…

10 hours ago

CSC 225 Theory Questions: Relationship Between A System And A Sub System – Components Of A System

200 Level Computer Science exam questions and the detailed answers. Download the answers in document…

10 hours ago

CSC 225 Theory Questions: Change-Over – Methods Employed To Change-Over

200 Level Computer Science exam questions and the detailed answers. Download the answers in document…

11 hours ago

CSC 225 Theory Questions: Define The Following Terms – Roles Of System Analyst

200 Level Computer Science exam questions and the detailed answers. Download the answers in document…

12 hours ago