Formulae, Cell referencing (absolute and relative) and worksheet ranges

Certified E-Governance ProfessionalCertify and Increase Opportunity.
Govt. Certified E-Governance Professional

Formulae, Cell referencing (absolute and relative) and worksheet ranges

Formulae, Cell referencing (absolute & relative) and worksheet ranges

It is the most used facility of MS-EXCEL. A formula is a cell entry that calculates values to return a result and it begins with the equal sign (=) and uses values or cell references and operators or MS-Excel in-built function.

Various operators are


What It Does

+ Addition
* Multiplication
/ Division
= Equal to
< Less than
<= Less than or equal to
> Greater than
>= Greater than or equal to
<> Not equal to
% Percentage
^ Exponentiation
Functions are prewritten formulas that perform certain types of calculations automatically.
For example the function used for today date is TODAY (). Functions are used as
  • Using Functions Wizard to create formulae
  • Directly Inserting Functions
Cells address used in formulae can be absolute or relative address.

Working with Ranges
A selection consisting of two or more cells is a range. The cells in a range can be adjacent or non-adjacent. An range is given by start cell address and last cell address separated by ‘:’.

Names can also be given to ranges.

Share this post
Data entry and types
Printing and Formatting

Get industry recognized certification – Contact us