This is not a course. It is a... Tip Sheet

Open Office 3.0 Open Office Calc - Calculate the Average


1

Click the first empty box or cell to the right of the row of numbers for which you want to find average.

average row
2

Or, click the first empty box or cell below the column of the numbers of which you want to find average.

average column
3

Click Insert | Function

 

 

 

 

 

 

 

 

or click the Functions icon

average function

average wizard
4

Select AVERAGE

Functions
5 Click OK in the Function Wizard Dialog box or press the Enter key average ok
6

Select the cells for which you want to calculate the average. Press Enter.

Average Selection
12

Notice that the average result now shows in the selected cell.

average box

 
 
 
Produced by SchoolNet SA