Averaging a column or a range of cells is made easy by using the average formula. This means that it will automatically solve for the average to a column or range of cells.
To start, navigate your cursor to the left tab and use a 'Prefilled table' under 'Table'. A pre-filled table has a fixed number of rows you can set in your template creation.
To average a column or a range of cells, use the formula:
=AVERAGE(Number1:Number2)
Where Number1 is the start of the range, and Number2 is the end of the range.
Average calculation includes Number1, Number2, and the numbers in between.
For example:
Given that the cells contain these numbers,
A1 = 10
A2 = 15
A3 = 20
A4 = 25
Therefore the formula,
=AVERAGE(A1:A4)
Returns the value, 17.50.