Decisions at the Ptomaine Fish Co.
Malcolm Swordfish president of the Ptomaine Fish Company needs your help. He is looking to hire a delivery company for his business. But he’s not sure which company to choose. So he has sent a letter to your math class for some help. Please read the letter. Each group will be responsible to come up with advice for Mr. Swordfish.
In order to solve this problem you will need to create a spreadsheet and graph. But first fill out the Ptomaine Fish Problem worksheet before continuing.
1. Open the Excel Spreadsheet program. You should see something like this:
Columns are vertical and are labeled with capital letters. Rows are horizontal and are numerically labeled. The intersection of a row and a column is called a cell and can contain three types of information: Text, numbers, and formulas. Text and numbers can be entered directly by clicking on a cell and typing the text or number. Formulas, on the other hand, require that you start with an equal (=) sign. More about formulas later.
Make a table like the one below:
You can finish this table by entering in all the information directly into each cell. An alternative is let the spreadsheet do the work for you dynamically with formatting and formulas.
Since the numbers in each column are following a pattern we can use a formula that will generate the numbers themselves.
Next, fill down your formulas by selecting the cell and
and dragging down as far as you like.
The appropriate numbers will magically appear.
Repeat for columns C and D.
To make a graph or chart of this information do the following: