Stay Ahead with the Power of Upskilling - Invest in Yourself! 
Certified E-Governance ProfessionalCertify and Increase Opportunity.
Be
Govt. Certified E-Governance Professional
Formulae, Cell referencing (absolute and relative) and worksheet ranges
Formulae, Cell referencing (absolute & relative) and worksheet ranges
Formula
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.
Operators
Various operators are
|
Operator |
What It Does |
|---|---|
| + | Addition |
| – | Subtraction |
| * | 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
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.
Apply for E-Governance Certification Now!!
http://www.vskills.in/certification/Certified-E-Governance-Professional
