content_image/705299.jpg content_image/705300.jpg content_image/705301.jpg
This process may be used to filter any column. 

*All sort and filter functions can also be found from the dropdown Sort & Filter  menu in the Editing  section 

## Section VIII: Functions and Formulas 

<img src='content_image/705299.jpg'>

## Basic Functions/Formulas 

Excel has many different functions and formulas which can be used to manipulate data in a variety of ways, such as sums, subtotals, averages, number counts, maximums, and minimums. 

## Sums 

One of the most commonly used functions of Excel is summation. If you have a data table for a single student with amounts and dates of payment, to find the sum of all payments, you would use the summation function. 

<img src='content_image/705300.jpg'>

To add numbers in a column: 

1. Select the cell directly beneath the last entry. 

2. Select Auto Sum  located on the Formulas  tab. 

<img src='content_image/705301.jpg'>

3. Select the AutoSum  button 

4. This will select all items within the column 

5. Click the Enter  key on your keyboard to calculate the sum of all fields. 

Other functions are available by selecting the AutoSum dropdown 

