Sheet1
Sample Checking Account
x Date Check # Transaction Credit
11/23/11 Deposit $1,000.00
11/23/11 Debit Card – Speedway Gas
11/25/11 Debit Card – McDonalds
11/25/11 1234 Wal-mart
11/25/11 1235 Meijer
11/25/11 1236 Old Navy
11/25/11 1237 American Eagle
11/25/11 Debit Card – Pizza Hut
11/26/11 ATM
Checkbook A
1. Create the spreadsheet above.
2. Use the correct formulas to calculate the balance in column G
3. Match my formatting, including bolding, alignment and merged cells (F1 & G1)
4. Format columns EF& G to currency with the dollar sign and two decimals.
5. Match my column widths (x is .5, Date, Check, Credit, Debit, and Balance are 1 and Transaction is 3)
Transactions to be added to the checkbook:
Debit 11/28/11 Papa Johns 12.75
Debit 11/28/11 Family Video 5.78
Debit 11/30/11 Circle K 50
Debit 11/30/11 Alco 9.12
Debit 11/30/11 Chiefs 5
Debit 12/01/11 Taco Bell 6.52
Debit 12/01/11 Rite Aid 8.87
12/01/11 Deposit 1000
1238 12/02/11 Verizon 58.92
1239 12/02/11 Wal-mart 22.75
Debit 12/02/11 Regal Cinemas 12.75
Debit 12/02/11 Olive Garden 52.36
When done with this checkbook...
Checkbook B
Create your own checkbook. Have at least 15 checks, 5 deposits, and 3 ATM withdrawals. Your
starting balance is $200.00. Print with and without formulas. You can use another sheet within
this same file. Save file under Mrs. McClurg Computers\Open Office Calc\checkbooks
Checkbook C
Create a checkbook for a club. You have been voted treasurer of a club here at Delphos Jefferson
High School (Fellowship of Christian Athletes, D-Club, FFA, or make up your own you wish we had)
Label your checkbook at the top and include your name at the top as well.
Include at least 4 deposits and 8 checks for various activities/fees you club might have. Be creative!
Again you can use another sheet within this file and save it all as one file.
Page 1
Sheet1
Account # 1234567890
Debit Balance
$1,000.00
$1,000.00
$6.36 $993.64
$187.36 $806.28
$225.87 $580.41
$22.78 $557.63
$58.46 $499.17
$12.00 $487.17
$50.00 $437.17
$437.17
$437.17
$437.17
Page 2