Microsoft Excel 1A: Check Register: Formulas, Sum, Cell Formatting

Business documents (Check Register) :

• Figure: 1A1 below is a check register that you may have seen before inside a check book which contains many checks.
• Each time a check is written you would record the date, to whom the check was written for and the amount of the check.
• The first line of this particular check has Balance Fwd. in the PAYEE column.
  • This means that the balance has been forward from a previous page.
  • Therefore, at the beginning of the day on January 1 there was $3,251.52 in the account.
• Most employers use direct deposit to automatically deposit your earnings from a job.
• In this case you receive a pay remittance slip at work indicating that $1,200.00 was deposited in the account.
• The third line shows a check in the amount of $650.00

Figure: 1A1

• You may be familiar with tables like those used in Microsoft Word.
• The table below shows the same information as above in a table form.
• As you can see it is easier to distinguish numbers and mistakes are avoided in calculations.

Figure 1A2

• Note balance on the second line above is calculated as follows:
  • (beginning balance) $3,251.52 + (paycheck) $1,200.00 = $4,451.52
• Note the balance on the third line above is calculated as follows:
  • (balance on second line) $4,451.52 - (rent) $650.00 rent = $3, 801.52
• Use a calculator or pencil and paper to calculate the balance of the account on the third and fourth line, you will need the answers to these questions for the review question section coming up.

Using a spreadsheet to calculate automatically:

• Spreadsheets are much better than a table above.
• You can enter formulas into a spreadsheet that will make calculations for you automatically.
• For example, in the check register, a formula can be placed in all the cells in the balance column which will automatically calculate the balance, all you have to do is enter the date, payee and either the check or deposit amount.

Answer questions based on the Lesson Overview and the Step-By-Step Tutorials in your student question file.

Click here for download page for Questions

This website is copyright protected see contact page for details.