If you missed our class on Spreadsheets (5.4),here is what we did:
Open Excel and name Sheet 1 "Balance Sheet" and Sheet 2 "Income Statement"
Use page 143 as your guide for the B.Sheet.
Use the same headings, accounts, and dollar figures, but number the accounts (as in the Chart of Accounts section)
Also use formulas tp get all totals , not just copying numbers.
Use page 145 as your guide for the I. Statement.
Use the same accounts (number these as well), dollar figures and put formulae in for the totals. Same as the last one.
Email to dcopp@mail.gssd.ca when you're done.
No comments:
Post a Comment