Page 211 - CA_165_V2.0_C9_Flipbook
P. 211
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:
Category Description
Cell Address or a Cell A1, C11, A24:B36, etc
Range
Functions SUM, MAX, MIN, etc.
+ (Addition) - (Subtraction)
Mathematical Operators * (Multiplication) / (Division)
^ (Exponent)
> (Greater than) < (Less than)
Relational Operators = (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 209

