duminică, 19 decembrie 2010

[Difference between formulas and functions]

Formulas = equations that perform calculations on values in our worksheet
Functions predefined formulas that perform formulas that perform calculations by using specific values, called arguments in a particular order or structure
In every calculation the mathematical operators and also the parenthesis are very important
Every function has arguments also known as parameters. Very few functions don’t have this type of parameters. Most of the functions have one required argument and also can have aoptional arguments that are indicated by the square brackets

sâmbătă, 18 decembrie 2010

[Tracing cell references]

Tracing cell references is very useful in a complex worksheet in which formulas are piled on top of one another and the results os some formulas are computed into other formulas, so this option gives us the opportunity to get a better idea of how our worksheet is constructed.