Microsoft Office Tutorials and References
In Depth Information
Commonly Used Excel 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.