Required File:  Blank Excel Spreadsheet

Act 3.11 checkbook.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Instructions for Checkbook:


1. In row 6, type the following (column A cell A6 - Check), (B cell B6 - Date), (C cell C6
Description), (D cell D6 - Payment), (E cell E6 - Deposit), (F cell F6 - Balance).
2. In row 7, type the following (column A cell A7 - Number), (D cell D - Debit), (E cell E7 -
Credit).
3. In cell F2, type Beginning. In cell F3, type Balance.
4. In cell F4, enter the beginning balance of $500.00
5. In cell F8, enter the following formula =F4-D8+E8.
6. In cell F9, enter the following formula =F8-D9+E9.
7. Click on cell F9 and select copy, then click on cell F10 and copy down for the desired amount
of cells, then select paste or enter.
8. Now, pay some bills, spend some money, and make sure you add a few paychecks or deposits!


Happy calculating!