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  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. 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. Sums  To add numbers in a column:  1. Select the cell directly beneath the last entry. 2. Select  Auto Sum  located on the  Formulas  tab. 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  36 