MS-EXCEL: USING IT AS A CALCULATOR Ii: CREATING YOUR OWN FUNCTIONS
This tutorial is available as a pdf download

The data below shows the results from an experiment which investigated the effects of temperature on yeast peroxidase enzyme. This reaction produces a foam of oxygen bubbles. The reaction was measure by measuring the maximum height that the foam reached and the time it took to reach this height.

 The student wanted to calculate the rate of increase in the foam height in cm per min.

• Enter your data into a spread sheet and create a new column for the rates.

• Enter your equation in the first cell. Start with the equals sign.

• Left click on the cells containing the values that you want to use in the calculation.

Then  press Enter.

To repeat the calculation down the column, place the mouse cursor on the bottom right of the cell. Hold down the left mouse button and pull the mouse down over the other boxes in the column.

When you let go of the mouse you will see that Excel has calculated the rates but the number of decimal places for the answers is variable.

You can adjust the decimal places using the Add or Reduce Decimal Place buttons in the tool bar.

• Index Page
• Top of Page

© Paul Billiet 2007