Spread Sheet Project #2

Spread Sheet Projects 1 & 2 (20 points)

BEFORE YOU START!!

Make certain that in the box you filled with prices and quantities that you have no "$" signs or words like, each, bottles, large, small, videos, etc.

This project consists of putting together two separate spreadsheets. The first spreadsheet has a budget of the original $1500.00 of Word Processing Project 5. The second has an adjusted budget of $1000.00. Follow the steps carefully and slowly and you will have no trouble being successful with putting together your spreadsheet. There is no need for a calculator for this project. The spreadsheet acts like a calculator. All sub- totals must be calculations.

Use of a calculator or Calculating the numbers in your head

for this project can result in the loss of up to 20 points!

Spreadsheet #1 $1500.00 budget.

Step 1

Open Spreadsheet Project #1

Step 2

Click on the words "To Multiply" and follow all of the instructions listed. Make sure that your read all of the instructions through once before you start applying them to your project!!

click here ---->To Multiply

Step 3

Type the word Total in the box on the left side of your Total. (This is the Number that popped into the box two boxes under your last sub-total.)

Step 4

This Total must now equal a number between $1495.00 and $1505.00

Step 5

Adjust your quantities and costs to bring your Total within the acceptable range.

Once you have finished Spreadsheet 1 perform the following steps:

File Save
File Save As
In the name section, change the file name from "last name ss1" to "last name ss2" by changing the 1 to a 2
Click the Save button

!*! FLASH !*!

Your Budget has just been cut because of financial difficulties. You need to have the same party only you need to make it work with less money.

Spreadsheet #2 $1000.00 budget.

Step 1

This Total must now equal a number between $995.00 and $1005.00

Step 2

Adjust your quantities and costs to bring your Total within the acceptable range. Change the budget from $1,500.00 to $1,000.00

Step 3

If you know what you are doing, help someone who does not! This helps everyone and will make you feel smart.

Di Leo's HomePage	6th Grade Projects	7th Grade Projects
Lincoln's HomePage	Search Engines

Step 1		Open Spreadsheet Project #1
Step 2		Click on the words "To Multiply" and follow all of the instructions listed. Make sure that your read all of the instructions through once before you start applying them to your project!! click here ---->To Multiply
Step 3		Type the word Total in the box on the left side of your Total. (This is the Number that popped into the box two boxes under your last sub-total.)
Step 4		This Total must now equal a number between $1495.00 and $1505.00
Step 5		Adjust your quantities and costs to bring your Total within the acceptable range.