1. Review and understand the example. (Note: Always start a function with an = as the first character.)
2. Enter a column of 5 numbers, in cells B27 to B31 (Pick any numbers you wish.)
3. In cell B33, enter a formula to add the individual 5 cells one at a time.
4. In cell B34, enter a formula to calculate the SUM using the SUM function of cell range B27 through B31
5. In cell B35, enter a formula to calculate the average, but adding the 5 cells and dividing by 5.
6. In cell B36, enter a formula to calculate the AVERAGE using the AVERAGE function of cell range B27 through B31