Calculation is the process of computing formulas and then displaying the result as values in the cells that contain the formulas.
It is very easy to perform Arithmetic & Logical operations or calculations in Microsoft Excel. In Microsoft Excel, figures are not referenced but the cell. It is wrong to calculate the value you have in a cell by referring to that value. You can only refer to the cell where you have the value. For you to know refer to a Cell, you must first of all call it by the column follow by the row e.g A1, B6, H7, C4, etc.
OPERATORS
Operators are the symbols or signs used for calculations in Microsoft Excel. Below are some operators that can be used in MS-EXCEL.
COMMON OPERATORS
^
-
+
/
%
*
>
<
>=
<=
=
< >
:
,
There are two methods of calculation in Microsoft Excel. These are:
1. FORMULA METHOD
2. FUNCTIONS METHODe.g