Categories: Lesson Notes

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

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

WEEK 5

TOPIC: WORKSHEET II

Sub-Topic 1:  EXCEL CALCULATIONS:

The basic and most powerful feature of Microsoft Excel is the ability to accept formula into the worksheet. A Formula is an instruction that is entered to tell Excel how to Add, Subtract, Multiply, Divide, or otherwise perform calculation by using the content of other cells. It is advisable to construct formula that makes reference to cells in the worksheet so that the result can be instantly generated even the values are changed.

When working on Excel calculations, the following guidelines should be considered;

  1. To enter a formula, first select the cell that will contain the formula.
  2. All formula must begin with equal (=) sign tells Excel to treat the cells contents as a formula.
  3. The formula should not be more than 1024 characters.
  4. (iv) The function name (e.g. SUM, AVERAGE) which is preceded by equal (=) sign must be selected and followed by the desired argument, i.e. =SUM (A5:F5). In this case, SUM is the function name and A5:F5 is the argument.

Addition: Using the SUM Function

The SUM function is used to add together a range of data or numbers. To sum up the values of a range of data:

  1. Open the worksheet containing data (as previously done in fig 4.2 above).
  2. Position the cell pointer on the desired cell i.e. the cell where the result should be displayed.
  3. Type equal sign, Select the function (i.e. SUM) and state the range of cells.
  4. MS Excel will highlight the range specified.
  5. Press the Enter key.
  6. The result is displayed.

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…

13 hours ago