Checkbook
Assignment
Mrs.
Miñoso
In this assignment you will create a checkbook register which will keep an accurate balance of your purchases and deposits.
Using
Excel create a checkbook register with the following elements:
$
Your
Name in the first row of the spreadsheet in 18 size point (Jane Smith’s
Checkbook Register)
$
Insert
an appropriate clip art image for your register
$
The
First column of the register will contain the date of the transaction (format
the cells appropriately) Title the column = Date
$
The
second column will contain the transaction number or code: Deposits = D, Withdrawals = W, Checks will each have a
number) Title the Column = Number
$
The
third column will contain a description of the transaction (size the cells appropriately)
Title the column = Description
$
The
fourth column will contain the amount of payment (format the cells
appropriately for currency). Title the column = Payment
$
The
fifth column will contain the amount of deposit (format the cells appropriately
for currency) Title the column = Deposit
$
The
last column will calculate the balance of your account. The following formula
should be used: =Balance – Payments +Deposits) Title the column = Balance
$
Use
the shading format to shade every other line of the register light gray.
$
Make
the Row Height for the entire spreadsheet to be 18.00
$
Save
as Checkbook Register and Print.
You
have just opened this account with a birthday present from your parents in the
amount of $300.00. The following are
your transactions for this month.
|
Date |
Number |
Description |
Amount |
Balance |
|
9/30/02 |
Deposit |
Birthday
Present |
$300.00 |
|
|
10/1/02 |
Check
#100 |
Burdines
- shirt |
$35.00 |
|
|
10/2/02 |
Withdrawal |
ATM
- movies |
$20.00 |
|
|
10/3/02 |
Check
#101 |
Shell
Oil & Co. - Gas |
$30.00 |
|
|
10/4/02 |
Check
#102 |
State
Farm Insurance |
$100.00 |
|
|
10/5/02 |
Deposit |
Paycheck
from Job |
$115.00 |
|
|
10/8/02 |
Check
#103 |
Our
Lady of Lourdes - Tix |
$30.00 |
|
|
10/10/02 |
Withdrawal |
ATM
- dinner |
$45.00 |
|
|
10/12/02 |
Check
#104 |
Macy’s
- clothes |
$75.00 |
|
|
10/14/02 |
Check
#105 |
The
Gap - clothes |
$45.00 |
|
|
10/15/02 |
Deposit |
Paycheck
from Job |
$115.00 |
|
|
10/17/02 |
Withdrawal |
ATM
- party |
$45.00 |
|
|
10/19/02 |
Check
#106 |
Sunglass
Hut – glasses |
$43.50 |
|
|
10/20/02 |
Check
#107 |
Spec’s
– CD’s |
$37.95 |
|