Inserting Functions
There are several ways to insert functions. Before you do anything, make sure your cursor is in the cell in which you want the result. Once there, choose one of the methods below to insert your function:
- On the Home ribbon, click on the arrow next to the AutoSum icon and select More Functions
- Go to the Formulas ribbon – choose either the Insert Function icon to bring up the Insert Function dialog box (same dialog box you would get with the first method), or click the arrow next to the correct category in the Function Library Group, and then choose the desired function.
The Insert Function dialog box that appears gives you a list of operations that Excel can perform.
Choose a category from "select a category"(which includes an option to show all), and then choose a particular function from the "Select a function".
Another dialog box opens which asks you to select the cells you would like to involve in the formula. To select, use the mouse to click on the first cell and drag through the cells you would like to add. Note that for each function, this second window will look different.
If you’re not sure how to use a particular function, you can click the "Help on this function" link atthe bottom of the Insert Function dialog box, and that will bring up Excel’s Help.