8th Gr. Assignment #42

Directions:

1. Download the spreadsheet from the site. It is called “hot_dog_exploration.xls” Download it, save it, open it, then minimize it so it is ready.. Website click here.

2. Add math formulas to make the spreadsheet ready to work for this hot dog stand seller to use to keep track of his sales. You will need to add math formulas in the E, F, G and H columns. It will take some critical thinking to decide which cells you are multiplying or subtracting. Here;s some hints:

Column E needs a multiplication formula.

Column F needs a subtraction formula.

Column G needs a multiplication formula

Column H needs a subtraction formula.

Here’s a letter I wrote to the hot dog seller explaining the spreadsheet. It will explain what you need to do Letter click here.

Remember the four basic steps to creating math formulas:

a. Select the cell the answer goes in.

b. Type an equals sign.

c. put cell names with math signs to add, subtract, multiply or divide cells (+, -, *, / ).

d. Press “Enter”.

3. Make a column graph of the hot dogs at the start of the day, end of the day and number sold (B, C and D columns only). Move it under the numbers and stretch it from the A column to the H column.

4. Print the spreadsheet with your name.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: