EXCEL CALCULATIONS

CONTENT

1. Introduction
2. Addition: Using the SUM Function
3. Subtraction: Using the IMSUB Function
4. Average
5. Count
6. Multiplication
7. Division
8. Printing of Worksheet

Introduction

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. The function name (e.g. SUM, AVERAGE) which is preceded by equal (=) sign must be selected and followed by the desired argument, i.e.