Microsoft Office Tutorials and References

In Depth Information

**Creating Functions**

Commonly Used Excel Functions

Creating Functions

Functions
are predesigned formulas that save you the time and trouble of creating com-

monly used or complex equations. Trying to write a formula that calculates various pieces

of data, such as calculating payments for an investment over a period of time at a certain

rate, can be difficult and time-consuming. The
Insert Function
feature simplifies the pro-

cess by organizing Excelâ€™s built-in formulas, called functions, into categories so they are

easy to find and use. A function defines all the necessary components (also called argu-

ments) you need to produce a specific result; all you have to do is supply the values, cell

references, and other variables. You can even combine one or more functions.

Enter a Function Using Insert Function

Click the cell where you want to enter the function.

Click the
Insert Function
button on the Formula bar or click the
Function

Wizard
button on the Formulas tab.