Homework 9, Checkbook.

This assignment is due Oct 22 for the day class and Oct 28 for the night class.

1. Start excel 2013
2. Start a new excel workbook with the Check register template.
3. 
4. Put your name in cell G2
5. Clear the current data entries in this book:
   • Select A1.. G9
   • Right click anywhere in the highlighted area
   • Select Clear Contents
   • The numbers in the Balance column will disappear as well, but don't worry.
   • Click in cell H5 an notice that there is still a formula in this cell.
   • 
6. Check registers are used to maintain the balance in a checking account.
   • This is a level of consumer record keeping.
   • Knowing how to do this can save you considerable banking fees.
7. Beginning Balance
   • The checking account should have a starting balance. Let us add one.
   • In cell C5 enter the date 10/01/2014
   • The cell is formatted to display the date in this format, you could also enter October 1, 2014 and it will be converted to the proper format.
   • In the Credit box (G5) enter the starting balance of $1000
   • Notice the $ and , are not required. Excel will again format the field for you
   • Notice that the Balance amount, H5 is calculated for you.
   • Enter the values in blue, the value in red will be automatically calculated
   • 
8. Registering a check
   • You write checks to pay for goods and services.
   • 
   • Checks are numbered sequentially.
     • This number is used to keep track of the transactions.
     • In this check the number is 5284, put that in cell B6
   • The date of the check is Oct 10, 2014, put this in cell C6
   • The Person to whom the check is written is Bob Smith
     • The memo line denotes Pet Care, but this is optional.
     • This line is unstructured in the register, I would put both pieces of information, if they fit.
     • Put Bob Smith, for Pet Care in Cell D6
     • The amount of the check is $30
       • This is how much you are spending, or a debit, so put this amount in cell F6.
     • Again, notice that the balance is updated automatically.
     • 
   • Applying a new credit
     • You worked at a neighbor's house raking leaves on October 14, 2014 and they paid you $50.
     • You deposited this the same day.
     • Enter Raking Leaves in cell D7.
     • This is a credit so enter 50 in cell G7
   • Add the following transactions

     Date	Check Number	Description	Credit/Debit	Amount
     10/14/14	5285	John's Pizza	D	20.45
     10/15/14	5286	Ocean Buffet	D	6.99
     10/16/14	5287	Pizza Hut	D	25.87
     10/17/14		Raking Leaves Again	C	50.00

   • You can either check with the bank, or look at your monthly statement to see if your checks have cleared.
     • This depends on your account type.
     • A check clearing, means that the debt has been paid.
     • The register gives you a place to keep track of this as well.
     • Once a check clears, place a number in column E on the check lines.
     • Let's assume that check 5284 has cleared, so place a 1 in cell E6
     • Notice that excel turns this into a check mark. This is another formatting detail that we will discuss later.
   • Mark checks 5285 and 5286 as cleared.
   • Spend a little time sorting the register using the sorting tabs in row 4
     • 
     • Sort your transactions by check number, low to high
     • Sort your transactions by credits, high to low
     • Sort your transactions by date.
   • You may want to try filtering your data as well
     • Select the drop down filter/sort tab after the C
     • Unselect the box next to 1
     • You will now only see the items which have note cleared.
     • 
     • Reselect the button next to 1 to show everything.
     • Do the same by deselecting blank in the Number field.
     • This should show you only checks.
     • Can you show only checks which have cleared?
   • Clear all filters.
   • Save this as yournameCheckbook
   • When you are finished email this document, as an attached excel workbook, to your instructor.