transacti ons are recorded in the business's check register. Banks provide
debits (checks writt en and fees charged), credits (deposits made and interest
earned), and ending balance. Businesses reconcile the bank statement balance
to the check register balance to ensure that all transacti ons were properly
recorded by the bank and by the business.
The following acti vity illustrates how spreadsheets can be used to update a
checkbook register by listi ng dates with their respecti ve deposits and checks.
2. Type the data as shown.
3. Format the width of column A to 12.0 and left align.
4. Format cells A10 A40 as dates showing mm/dd/yyyy.
6. Format the width of column C to 12.0 and right align.
9. Format the width of column E to 12.0 and center align.
13. Bold rows 3 9 and row 42.
14. Underline row 9.
15. In cell G10, type 10327 for the "Balance brought forward."
16. Enter a formula to calculate the BALANCE for the fi rst transacti on in the check
G11, type