1. Functions are prewritten formulas. The most common functions are Sum, Average, Minimum, and Maximum. To Sum (add up cells), click on the cell you wish to place the function. On the toolbar, click on the AutoSum button

You will notice a marquee around some cells that Excel thinks you want to add. If Excel guesses correctly, just press the [Enter] key. If Excel does not guess the correct cells you want to add, click and drag over the cells you want and then press the [Enter] key.

  1. To find the Average, Minimum, or Maximum, click on the cell you wish to place the function. On the toolbar, click the little drop down arrow next to the AutoSum button. Select the function by clicking on it.

                     

You will notice a marquee around some cells that Excel thinks you want to use. If Excel guesses correctly, just press the [Enter] key. If Excel does not guess the correct cells you want, drag over the cells you want and then press the [Enter] key.