Using the Paste Function Tool

One can always enter the calculation by hand or use Excel to insert the formula
into the cell. AutoSum is one such instance, but Excel has many more. These
can be found in the Paste Function Tool located on the toolbar. This feature
helps you go through the process of creating formulas containing functions.
To use the Paste Tool Function, follow the steps below:
- Make sure you are in the correct cell.
- Select the Paste Tool Function.
- The function dialog window is divided into two sections. The
left side contains the category of functions within Excel. The
right side is where the actual function is located. Choose the
category (e.g., Statistical) and then the actual function to be
performed (e.g., AVERAGE).
- You will then be taken to a second dialog window where you
will be asked to enter the block of cells to apply the function
to. Type or highlight the block of cells you want.
- If you click on the formula palette button, the current
formula window will be temporarily set aside and you will be taken
back to the worksheet where you can use your mouse to select the
block for the function.
- Once you have selected or entered the block of cells to use
for the function, click the OK button or press the Enter
key.