Steps in creating a checkbook

  1. Click on Start
  2. Click on programs
  3. Click on Excel
  4. Go to the little cell above the 1 and left of the column A. Click on it, then go to the font size and change to size 12. When this is done go to step 5.
  5. Go to the word, file, and click. Go to page setup and click. Go to page and click on landscape. Then go to margins and click on it. Change all margins to 0.5. Then go to sheet and click on it. Now find the word, gridlines, and click on it. Finish by clicking on OK.
  6. Go to A1 and type your name. Do not change the size of the column.
  7. Go to A3. Click on it and type in the word, number.
  8. Go to B3. Click on it and type in the word, Date.
  9. Go to C3. Click on it and type in the words, Description of Transaction.
  10. Go to D2. Click on it. Then go to the column letters, click on the line between C and D and drag to the end of the word transaction.
  11. Go to D3. Type in the words, Payment/Debit. Click on E2Then go to the column letters, click on the line between D and E and drag to the end of the word transaction.
  12. Go to E3. Type in the letter capital T.
  13. Go to F3. Click on it. Then go to the column letters, click on the line between E3 and F3 and drag to the end of the letter T.
  14. In F3 Type the word, fee. Click on G3. Go to the line between column F3 andG3. Click and move the line to the end of the word, fee.
  15. Type in the word, Deposit.
  16. Go to H3. Click on it. Type in the word, Balance.
  17. Got to the cell I3. Click on it. Now click on print preview. Click on the word close. This will produce a page line.
  18. Go to the line between Columns C and D. Click and drag to the right to the end of the word payment. Release the button.
  19. Click on Column D then go to the menu bar and click on Format.. Then click cells. Click on the word Currency. Make sure there are 2 decimal places and in the Symbol box a $ appears. Then click OK. Do this for columns G and H also.
  20. Click on cellA5, hold the left button down, and Highlite the cells of the rowFrom A to H. Go to the paint bucket icon and click on the down arrow opening up the color panel pick a color. Repeat this for each odd number row on the first page of the check book.

You now have the basic layout for the check book.

You need to enter the following information in the proper columns.

  1. Your staring balance is $2100 in cell H5.
  2. A check with the number 2022 was written to Sam’s Clubin the amount $65.97of meaton December6, 2007. The words for food should be written in the colored line. Start in A6.
  3. A check with the number 2023 was written to WalMart in the amount $37.56 for cleaning supplies on December 6, 2007.The words for cleaning supplies should be written in the colored line.
  4. A check with the number 2024 was written to Electronic Boutiquein the amount $53.97X Box Game on December 6, 2007.The words for X Box Game should be written in the colored line.
  5. A check with the number 2025 was written to Old Navy in the amount $124.35 for Clothes on December 6, 2007.The words for clothes should be written in the colored line.
  6. A check with the number 2026 was written to Staples in the amount $203.57 for Printer on December 7, 2007.The word for printer should be written in the colored line.
  7. A check with the number 2027 was written to Barnes and Noblein the amount $157.67 for computer books on December 7, 2007.The words for computer books should be written in the colored line.
  8. A check with the number 2028 was written to Edusoftware INC. in the amount $213.34 for Drafting Software on December 7, 2007.The words for drafting software should be written in the colored line.
  9. A check with the number 2029 was written to NYS. Department of Motor Vehicles in the amount $104.50 for car registration for your cars on December 7, 2007.The words, for car registrations, should be written in the colored line.
  10. A check with the number 2030 was written to NYSEG in the amount $180.00 for bill #234561760-1 payment on December 12, 2007.The words and numbers, bill #234561760-1, should be written in the colored line.
  11. A check with the number 2031 was written to Verizon in the amount $64.95 for Bill# 607-2345-3452-3 on December 15, 2007.The words and numbers, for Bill# 607-2345-3452-3, should be written in the colored line.
  12. A check with the number 2032 was written to Verizon Wirelessin the amount $49.95 for Bill# 231-234-2345-3002-1 on December 15, 2007.The words and numbers, for Bill# 231-234-2345-3002-1, should be written in the colored line.
  13. Depositinto your account $875 from a paycheck on December 19, 2007.The word, paycheck, should be written in the colored line.
  14. A check with the number 2033 was written to Time Warner Cable Televisionin the amount $130.35 for Bill# 3445678901-2 on December 19, 2007.The words and numbers, for Bill# 3445678901-2, should be written in the colored line.
  15. A check with the number 2034 was written to John Smith in the amount $354.35 for rent on December 20, 2007.The words for rent should be written in the colored line.
  16. Deposit into your account $2100 from a bonus check on December 21, 2007. The word, bonus, should be written in the colored line.
  17. A check with the number 2035 was written to Dick’s Sporting Goodsin the amount $325.56 for skison December 22, 2007.The words, for skis, should be written in the colored line.

You need to write the formulas for the balance column to keep a running balance in your account.