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

If you need to adjust the number of decimal places use the buttons on the tool bar.

The advantage of a spread sheet is that you can make it repeat a calculation over and over for similar series of data.

• Highlight the boxes for mean and standard deviation.

• Place the mouse cursor on the bottom right of the box and hold down the left mouse button.

Pull the cursor across the bottom of the table and then let go of the mouse. The means and standard deviations of each column will appear in the boxes.

• Previous Page
• Index Page
• Top of Page

© Paul Billiet 2009