Go to: Level 1 2 3 4 5 6 7 8 9 10 11 12 16 13 14 15 17

Set Up A Checkbook, part two

Format the columns

  • Select column D, E, and F and use the Currency tool

    • Note: the numbers are aligned with two decimal places

    • Use the toolbar to increase and decrease the decimal places

Set up the Equations

  • Select Cell F3 and enter the following equation: =F2-D3+E3

  • Select Cells F3 through F5 and Edit ->Fill Down

  • Test your equations

 

 

A B C D E F
1

Check No

 Date Description  Amount   Deposit   Balance 
2 Opening Balance  $ 500.00  $ 500.00
3 100 4/7/04 Office Supplies  $   78.50  $ 421.50
4 101 4/7/04 The Phone Store  $ 180.98  $ 240.52
5 102 4/7/04 The Phone Co  $   50.00  $ 190.52

Level 5: Set Up A Checkbook, part one