Using spreadsheets

Introduction

It is obvious that spreadsheets can perform calculations. It is less obvious that they can be used for the same purposes as many simple computer programs.

There are several common spreadsheet programs, such as Microsoft Word, Apple Numbers and Apache Open Office. They all have most of the features you will need, but eventually you may find that each one has particular strengths and weaknesses.

Spreadsheets can easily store data such as numbers and words. The power of the spreadsheets, however, is in their ability to perform and update calculations by changing the contents of just a few cells.

Exercise

Create an exponential growth simulation.

Modify the simulation to utilize an efficiency-discounted, exponential growth (EDEG) model.