check book...

missbossyy · 2008-02-01 12:56:20

You need to create an Excel document that will start with a beginning checking balance of $1000. It will then need to add or subtract from this balance like a checkbook. The checkbook should be designed is such a way that it doesn't matter what the amount is or if it is a credit or debit. The balance should be correct if one enters +$100 or -$100 for a line. Please use these sample checks and deposits to enter into your checkbook:

January 2, Deposit $400

January 3, Check $39.72

January 8, Check $14.14

January 10, Check $19.19

January 10, Deposit $30

January 14, Check $125.72

January 16, Deposit $45.72

January 17, Check $50.77

January 20, Check $220.15

In addition to the above requirements, your project also needs to fulfill the following items:

Create a workbook containing exactly one worksheet. Name this worksheet "Checkbook". You need to delete any other worksheets present.
Format the worksheet using at least 3 different font colors and 3 different background colors.
You need to use at least one relative reference and at least one absolute reference in your formulas.
Save your Excel workbook and upload it to the Checkbook assignment on Oncourse.

John E. Franklin · 2008-02-01 13:16:02

I do this actually with an old Works spreadsheet.
Here are some boxes where the total comes out.
These three boxes are above and below each other.
=F335-E336 This formula is in box F336 to the right of E336 and below F335.
=F336-E337 This formula is in box F337 to the right of E337 and below F336.
=F337-E338 This formula is in box F338 to the right of E338 and below F337.
Notice I used minus signs, because I like to make
my checks I write Positive numbers, instead of
negative.
But you can change that to plus I guess.
When I cut and pasted the formula, it
was relatively pasted I noticed
when I made it, but
that was in Works, not Excel.
Maybe the $ sign means something in a formula, like absolute or relative?
I can't remember Lotus 123 where I remember the $ from I think, and I
don't have excel.
But use the F1 key for Help in Excel and then get to the Index, and
type "relative" and see what comes up in the list below and click on it to read about it.
Also try "absolute" in the index.

Last edited by John E. Franklin (2008-02-01 13:20:17)

mathsyperson · 2008-02-02 00:57:20

Yes, putting a $ before a cell co-ordinate makes that co-ordinate become absolute.

For example, say you have =A1 in a cell. If you copied that across to the cell on the right, it would have the formula =A2. Similarly, copying down would give =B1.

If instead you had =$A$1, then copying across or down would always give =$A$1.

You can have half-absolute things as well.
Copying =$A1 across and down would give =$A2 and =$A1, respectively. In this case, the A is fixed but the number can still change.

missbossyy · 2008-02-02 04:21:11

thanks guys!

John E. Franklin · 2008-02-02 04:30:20

You're welcome

Math Is Fun Forum

#1 2008-02-01 12:56:20

check book...

#2 2008-02-01 13:16:02

Re: check book...

#3 2008-02-02 00:57:20

Re: check book...

#4 2008-02-02 04:21:11

Re: check book...

#5 2008-02-02 04:30:20

Re: check book...

Board footer