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

Theory Question: Examples Of Each Of The Following Application Programs

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

7 hours ago

Theory Questions: Definition of Application Software – Differences Between Hard Disk and Auxiliary Storage Devices

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

8 hours ago

Theory Questions: Devices Used for Computing Before Today’s Electronic Computers – Booting

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

9 hours ago

Theory Questions: Identify Errors In Each BASIC Programmes – Write BASIC Program To Calculate Quadratic Equation

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

10 hours ago

Theory Questions: Draw A Flowchart For This Problem – Write A Program

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

10 hours ago

Theory Questions: Write Short Notes On The Following

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

11 hours ago