JSS 3 FIRST TERM 2023 WEEK FIVE LESSON NOTE

 

Jss 3

TOPIC: Worksheet


 

OBJECTIVES

At the end of this topic you should be able to:

1.           1. Select, add and rename a worksheet.

   2.       Define data entry and editing 

Introduction

From the simple explanation of what a spreadsheet is in the previous lesson, it is clear that worksheet is a sheet or a page of a workbook.

A workbook is made up of cells which are formed from the combination of rows and column. A workbook could be made up of one or more pages depending on volume of data stored on the sheet.

Selecting, Adding and Renaming Worksheets

Selecting Worksheet: the worksheets are accessible by clicking the worksheet tabs just above the status bar.

Adding worksheet: To add a sheet,

·        select insert worksheet from the menu bar

·        select new worksheet beside the last worksheet on the worksheet tab or

·        press SHIFT + F11 on the keyboard.

Renaming worksheet: To rename the worksheet tab

·          move the cursor to the sheet tab

·          right-click on the tab with the mouse

·          select rename from the popup menu

·          type the new name and press ENTER

MENU BAR

The menu bars have the option for creating, editing, intersecting charts or graphs and providing the same features as in MS-word. Each menu is accessed by either clicking on it with the mouse pointer or by pressing the ALT key to activate the menu bar and formula bar is the blank line that appears on the top of the sheet. This area is used to write formula to manipulate the data. Instead of that, a box also appears along with the formula bar that displays the address of every cell.

DATA ENTRY

Data entry is the process of entering data or information in to the computer system. To enter data in a worksheet, the following steps are to be followed.

·        Activate the cell by moving the MS-excel cursor (rectangular box) or by clicking with the left mouse button.

·        Enter the data from the keyboard

·        Lock the data by pressing the enter key.

EDITING DATA

Editing is the process of making correction by adding or removing from the content of a cell or group of cells to ensure that the data is correct. Editing your worksheet data is very easy.


 

Comments

Post a Comment

Popular posts from this blog

JSS 2 WEEK TWO LESSON NOTE_FIRST TERM 2023

Image
  Jss2 TOPIC: CLASSIFICATION OF COMPUTER BY GENERATION OBJECTIVE At the end of this topic you should be able to:  1. List the criteria for classifying computers.          I.                   2. State the features of computers classified based on technological age. Introduction Computers can be classified into different categories based on different criteria. Basically, computers can be classified based on the following criteria: 1.      Size. 2.      Types 3.      Generation 4.      Purpose or versatility Based on the technological Age of the computer, computers can be classified into: ·         First generation ·         Second generation ·         Th...
Read more

SSS TWO WEEK TWO LESSON NOTE (ICT_223)

Image
  Ss2 TOPIC:   HANDLING COMPUTER FILES Introduction File operation deals with the physical movement of data in and out of files. User programs effectively use file operations through appropriate programming language syntax. The file management system manages the independent files and acts as the software interfaces between the user programs and file operations. Basic Operations of Computer Files 1.     Insertion: records must be inserted at the place dictated by the sequence of the keys. As   obvious, direct insertion into the main data file would   lead to frequent rebuilding of the file. This problem could be mitigated by reserving overflow areas in the file for insertions. But this leads to wastage of space and also the overflow areas may also be filled. 2.     Deletion: deletion is the reverse of insertion. The space occupied by the record should be free for use. 3.     Updating: updating is a combinat...
Read more

JSS ONE WEEK THREE LESSON NOTE (ICT_223)

Image
  Jss1 TOPIC:   MASTERY OF THE KEYBOARD Introduction A computer keyboard is the most commonly used input device. It is defined as the set of typewriter-like keys that enables you to enter data into a computer or other devices. Computer keyboard are similar to electric-typewriters but contain additional typing keys. The standard arrangement of alphabetic keys on the keyboard is known as the QWERTY. The computer keyboard could be wired or wireless. Types of keyboard There are different types of keyboard depending on what they are used for. Some have more keys than the others. Keyboards also come in different shapes but basically a keyboard has regular shape. The types of keyboards are: a)      Enhanced keyboard b)     Standard keyboard   c)      Windows keyboard d)     AT keyboard   Sections of the Keyboard The keyboard is divided into the following sections: ...
Read more