To complete the task, we have to provide the Spreadsheet required.
Q1. Note that the given resources including the Spreadsheet Advice PDF and the worksheet video may assist in completing this assignment question.
In this case the Report section will look just like the data section but will contain only formulas. In some cases the cells in the report will be, for example =D8. The yellow highlighted cells will contain the answers.
Q2. Assets, liabilities and owner’s equity
Give 3 examples each of assets, liabilities and owner’s equity (Proprietorship) accounts.
Q3. Chart of accounts
See your text - 6th edition page 56. What is a chart of accounts? Explain a typical account numbering system.
Q4. Debit and credit balances
From the following list of accounts identify those with normal debit or credit balances.
1. Cash
2. Accounts receivable
3. Accumulated depreciation
4. Prepaid rent
5. Wages accrued
6. Accounts Payable
7. Commission received in advance.
8. Drawings
Q5. Trial balance
A. Create a manual solution using pen and paper. Scan or take an e-photo and paste in your assignment.
B. Create a spreadsheet solution. Paste normal and formula views.
C. Change 4 numbers such that the trial balance still balances. Paste this new normal view. There should be no need to paste a new formula view. Ensure that you choose the 4 changes yourself.
Highlight the data changes with the yellow highlighter in Excel.