Enter the text below in the cells indicated.
A1: Sure Balance Checkbook
A3: Ck. #
B3: Date
C3: Item Description
D3: Debit E3: Credit F3: X
G3: Balance
Modify column widths for columns A through F.
Format the numbers to show dollars and cents for all entries in columns D, E, and G
Format column B to enter the date of transactions.
Enter the formulas below in the cells indicated.
G4: =-d4+e4
G5: =g4-d5+e5
Your checkbook should look like the one below.
A |
B |
C |
D |
E |
F |
G |
|
1 |
Sure Balance Checkbook | ||||||
2 |
|||||||
3 |
Ck. # | Date | Item Description | Debit | Credit | X | Balance |
4 |
6/30/92 | June Paycheck | $1,795.86 | $1,795.86 | |||
5 |
100 | 7/1/92 | Rent Payment. | $42.64 | $1,753.22 | ||
6 |
101 | 7/1/92 | Plaza Theatres | $87.34 | $1,665.88 | ||
7 |
7/4/92 | Cash (Auto Teller) | $50.00 | $1,615.88 | |||
8 |
102 | 7/6/92 | United Way (Gift) | $75.00 | $1,540.88 | ||
9 |
103 | 7/7/92 | Rent | $800.00 | $740.88 | ||
10 | 7/10/92 | Hobby Sales | $2,500.00 | $3,240.88 | |||
11 | 104 | 7/11/92 | Speeding Ticket | $500.00 | $2,740.88 | ||
12 | 105 | 7/12/92 | Lawyer for Speeding Ticket | $3,200.00 | ($459.12) | ||
13 | 7/14/92 | Saving Quarter Fund | $500.00 | $40.88 |