microsoft excel training courses london - Excel Formulas

Hi Yvette,

In response to yur query,

In each example, first place your cursor where you want the result of your calculation to be displayed.

1) The formula to get the Average of a column of figures is =AVERAGE(A1:A10)
Where A1: A10 represents a column of cells containing the figures that an average is required for.

2) The formula to get the Highest number in a column of figures is =MAX(A1:A10)
Where A1: A10 represents acolumn of cells containing the figures that highest is required for.

3) The formula to get the Lowest number in a column of figures is =MIN(A1:A10)
Where A1: A10 represents a column of cells containing the figures that lowest is required for.

Hope this helps