JSS3 FIRST TERM 2023 WEEK SIX LESSON NOTE

 

Jss 3

TOPIC: Worksheet II

OBJECTIVES: At the end of the lesson, you should be able to

1.     List some keyboard shortcut keys.

2.     Define formula and list parts of a formula

    3.     Define cell referencing and list types of referencing. 

 

Keyboard shortcuts

It is always better to know some basic keyboard shortcut command keys. Some of these shortcuts are: 

CTRL + O = open a file              CTRL + X = cut                      CTRL + B = bold

CTRL + N = new file                  CTRL + C = copy                  CTRL + I = italics

F12 = save as                               CTRL + V = paste                 CTRL + U = underline

CTRL + S = save                         CTRL + Z = undo                  CTRL + 5 = strikethrough

CTRL + P = print                         CTRL + Y = redo                   F7 = spelling

CTRL + F = find                        CTRL + H = replace             ALT + =      apply Auto sum

 

FORMULA 

A formula are equations that perform calculations on values in your worksheet. A formula always starts with an equal (=) sign. It specifies what operations are to be performed on the values of the cells it relates to. It usually contains arithmetic values, expressions, cell addresses or ranges.  

 

 Parts of Formula

Constant: they are fixed values that remain the same or that do not change during the program execution. For example: A1*100, A1+ “ADE”. 100 and “ADE” are numeric and alphanumeric constant respectively.

Operators: operators are symbols or special character that are used to indicate or specify the type of calculation that a formula would perform. Some of the functions used in excel are, plus (+) for addition, minus (-) for subtraction, asterisk (*) for multiplication and so on.

 

CELL REFERENCING

 

A cell reference refers to a cell or range of cells on a worksheet that can be used in a formula so that MS Excel can find the values or data that you want that formula to calculate.

 

Types of Cell referencing

Relative reference

Absolute reference

Mixed reference


 

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