The Open Door Web Site
Using MS Excel as a Calculator
ICT in Biology Index
ICT IN BIOLOGY
Using MS Excel 2013 as a Calculator
Creating Your Own Functions
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.
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.
The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.
Donate to the Open Door Web Site using PayPal