Page 197 - CA 165 ver 1.0 Class 9
P. 197
DATA ANALYSIS 7
One of the most important usage of a spreadsheet package is providing analytical reports of
values. Calculation on data in a spreadsheet package can be done easily in different ways to
provide useful information in a required format.
FORMULAS
For doing calculations, formulas are used. Formulas can be applied on a large data set to
perform various mathematical operations such as addition, subtraction, division, multiplication
and many more.
A formula in a spreadsheet package may consist of the following:
Cell Address or a Cell A1, C11, A24:B36, etc
Range
Functions SUM, MAX, MIN, etc.
Operators Mathematical Operators
+ (Addition) - (Subtraction)
* (Multiplication), / (Division)
Exp (Exponent)
Relational Operators
> (Greater than) < (Less than)
= (Equal to) <> (Not equal to)
<= (Less than or equal to) >= (greater than or equal to)
Parenthesis ()
‘Equal to’ operator A formula always starts with an ‘=’ operator.
Data Analysis 195

