Formula of zenamix
Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.
Formulas used in Excel must follow a certain syntax.
Here, We deal with Some Special Products in Polynomials.
Certain products of Polynomials occur more often
in Algebra. They are to be considered specially.
These are to be remembered as Formulas in Algebra.
Remembering these formulas in Algebra is as important
as remembering multiplication tables in Arithmetic.
We give a list of these Formulas and Apply
them to solve a Number of problems.
We give Links to other Formulas in Algebra.
Here is the list of Formulas in
Polynomials which are very useful in Algebra.
Formulas in Polynomials :
Algebra Formula 1 in Polynomials:
Square of Sum of Two Terms:
(a + b)2 = a2 + 2ab + b2
Algebra Formula 2 in Polynomials:
Square of Difference of Two Terms:
(a - b)2 = a2 - 2ab + b2
Algebra Formula 3 in Polynomials:
Product of Sum and Difference of Two Terms:
(a + b)(a - b) = a2 - b2
Algebra Formula 4 in Polynomials:
Product giving Sum of Two Cubes:
(a + b)(a2 - ab + b2) = a3 + b3
Algebra Formula 5 in Polynomials:
Cube of Difference of Two Terms:
(a - b)3 = a3 - 3a2b + 3ab2 - b3 = a3 - 3ab(a - b) - b3
Algebra Formula 8 in Polynomials:
Each of the letters in fact represent a TERM.
e.g. The above Formula 1 can be stated as
(First term + Second term)2
= (First term)2 + 2(First term)(Second term) + (Second term)2
Relative cell reference is address of cell , when copied from one cell to another gets changed automatically.
e.g. Put formula in cell c5 as A5+1 when you copy this from c5 to c6 the address of A5 will automatically changed to A6.
Absolute Cell Reference
As above now put formula in cell C5 as $A$5+1 ,now copy this formula from C5 to C6 if you this formula youwill find cell Address of A5 does not changed.
Mixed Cell Reference:
If we put Dollar ($) sign before Alphabetic cell address i.e.$c5 then even if you copy this formula in any cell , coloumn (c) will remains constant.
Similarly if we put Dollar ($) sign before Numeric cell address i.e.c$5 then you copy this formula in any cell row address of the cell remains same.(5).
Pl elobarate on remaining two points 'Specific order of formulas ' and 'advance formulas,
176 views
Usually answered in minutes!
×