Assume that you have numbers in cells C1, C2, C3, C4, and C5. You want to get a sum
of those numbers in cell C6. In cell C6, click on the AutoSum (looks like an E) key
located on the toolbar. The cells above should then be highlighted. If they are not, select
the cells you want to add. Hit enter and the sum should appear in C6.
If you want the average to appear in C7, click on C7 choose the arrow next to the
autosum (E) and select average. Highlight cells C1 to C5 then hit enter. You should
have the average. Repeat these steps choosing max, min, and count. The formulas
should look like this:
=sum(C1:C5)
=average(C1:C5)
=max(C1:C5)
=min(C1:C5)
=count(C1:C5)