Function	Description
=SUM(A1:A3)	Totals all the values in the range A1 to A3.
=AVERAGE(A1:A3)	Averages all the values in the range A1 to A3.
=MIN(A1:A3)	Returns the smallest value in the range A1 to A3.
=MAX(A1:A3)	Returns the largest value in the range A1 to A3.
=STDEV(A1:A3)	Calculates the standard deviation of the range A1 to A3.

You can access Excel's built-in formulas by using the Function Wizard.

1. Choose the cell where you want your formula calculation to appear.
2. Click on the Insert Function icon in the Standard toolbar.
3. The Insert Function dialog will appear.

   

4. Select the formula you want. (Note that the Insert Function dialog defines the selected formula and its argument at the bottom of the dialog.)
5. Click on the OK button.
6. A Function Arguments dialog will appear.

   

7. The cells involved in the calculation will appear in the Number 1 field.
8. Confirm or change the contents to reflect the cells you want to use in the function.
9. The formula result will appear in the lower left-hand corner of the Function Arguments dialog.
10. Click on the OK button.
11. The calculation total will now appear in the originally selected cell.

NOTE 1:

• To change the cell references in the Number 1 field in the Function Arguments dialog, click on the icon with the red arrow to the immediate right of the field.
• This action will collapse the function dialog and allow you to select the cells that you want to include in your formula.

  

• After selecting the appropriate cells, click on the icon with the red arrow again. The function dialog will expand to its original size, and you can click on the OK button.

NOTE 2:

• You can type a function directly into a cell without using the Function Wizard. For example, if you want to average the numbers in cells A1, A2, and A3, you can type =Average(A1:A3) into a cell.

Click HERE to return to the Table of Contents.