MS-EXCEL: USING IT AS A CALCULATOR I: USING PRESET FUNCTIONS
This tutorial is available as a pdf download

Each of the cells in a spread sheet can carry out calculations. Either you choose from the collection of functions in the tool bar or you type in your own function.

• Enter your data in a new spread sheet

• Select a cell at the bottom of a column where you want the mean ( average) to be calculated.

• Click on the functions button in the tool bar

• Select Average (Fr: Moyenne) and click on it.

An equation will appear in the cell indicating the function and the cells it will use with this function. Check that they are the correct cells and click OK or press Enter.

The mean will appear in the box.

The same thing can be done if you want to calculate the Standard Deviation of this sample.
Select a cell, Click on the function button. This time you will have to search for Standard deviation (Fr:Ecart type) amongst the Other functions.

If you have used it recently it will be there. If not, look under the Statistics functions.

• Continued on the next Page
• Index Page
• Top of Page

© Paul Billiet 2010