ODWS icon

The Open Door Web Site
HOMEPAGE BIOLOGY HOMEPAGE CHEMISTRY PHYSICS ELECTRONICS HISTORY HISTORY OF SCI & TECH MATH STUDIES LEARNING FRENCH STUDY GUIDE  PHOTO GALLERY
IB BIOLOGY HOMEPAGE TOPIC CHAPTERS SCIENTIFIC INVESTIGATIONS DRAWING IN BIOLOGY DRAWING TABLES ERROR ANALYSIS IN BIOLOGY ALL ABOUT GRAPHS STATISTICS SCIENTIFIC POSTERS MOLECULAR IMAGES
WS

 

Using MS Excel as a Calculator

Using Preset Functions
Adjusting the Decimal Places

ICT in Biology Index

Using MS Excel : Going Further with Graphs
Using MS Excel as a Database

IB Biology Homepage

 

Note about this Tutorial

This tutorial has been updated. It was originally published using Excel 2003. The new images are screenshots from Excel 2013.

There may be very slight differences for those of you using Excel 2016 but, essentially, the layout is much the same as Excel 2013.

Download the Excel Data File used for this tutorial to practice with

Excel icon

Functions.xlsx

 

 

ICT IN BIOLOGY

Custom Search

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.

  • 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.

Excel01

Then press Enter.

Excel02

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.

Excel03

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

Excel04

 

Excel05

 

Next: Adjusting the Decimal Places

 

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

SITE MAP
WHAT'S NEW?
ABOUT

PRIVACY

COPYRIGHT

SPONSORSHIP

DONATIONS

ADVERTISING

© Paul Billiet 2018
Any questions or problems regarding this site should be addressed to the webmaster

Hosted By
Web Hosting by HostCentric


SiteLock