IDream Stripper ru PDream Stripper ru Average Function NDream Stripper ru

There are many functions built into many spreadsheets. One of the first ones that we are going to discuss is the Average function. The average function finds the average of the specified data. (Simplifies adding all of the indicated cells together and dividing by the total number of cells.) The syntax is as follows.

Text fields and blank entries are not included in the calculations of the Average Function.

Lets use the table here for the discussion that follows:
We will look at several different specific examples that show how the average function can be used!
A
1
25
2
50
3
75
4
100
5
ExampleCells to averageAnswer
=average (A1:A4)A1, A2, A3, A462.5
=average (A1:A4, 300)A1, A2, A3, A4 and 300110
=average (A1:A5)A1, A2, A3, A4, A562.5
=average (A1:A2, A4)A1, A2, A458.33

IDream Stripper ru PDream Stripper ru Average Function NDream Stripper ru

1094208

Choose:   TRIO homeDream Stripper ru   I   tutorialsDream Stripper ru   I   by Brad JamesDream Stripper ru   I   bwjames@usd.eduDream Stripper ru