The distinguishing feature of a spreadsheet program such as Excel is that it allows you to create mathematical formulas and execute functions.

Microsoft Excel has a set of prewritten formulas called Functions. A function is a small assignment that is performed to produce a result that can be reliably used without caring as to how the function works or how it was created.

Functions differ from regular formulas in that you supply the value but not the operators, such as +,-,* or /.

Formulas are entered in the worksheet cell and must begin with an equal sign “=”. The formula then includes the addresses of the cells whose values will be manipulated with appropriate operands placed in between. After the formula is typed into the cell, the calculation executes immediately and the formula itself is visible only in the formula bar.

While using a function, remember the following rules:

Please Login or Register to read the rest of this article. Gold/Silver Membership required.