Assignment
Instructions
1. In the Trial Balance Tab, create drop down boxes in the classification column so that a user can chose whether the item is an Asset, Liability or part of Owners' Equity.
2. After you have created drop down boxes, you need to click on the dropdown and enter the appropriate classification for each item. For example, in cell C6 use your drop down box and select that an Accounts payable is a Liability.
3. Sort the Accounts by the classification column. You need to sort them in the following order - Assets, Liabilities and then Owners' Equity.
4. Once the accounts have been sorted by classification, then order the accounts the way they should be listed on the trial balance. For example, a 1 should be entered for Cash in the Order column in the appropriate cell. Use numbers -19. Check figure: Cash should be in row 8 after sorting the accounts in item 3.
5. Once you have determined the proper ordering, then sort the accounts by the order column using the same method that was previously done for Classification. Check figure: Cash should be in row 6 after sorting by order.
6. On the financial Statement tab, complete three financial statements. (Statement of cash flows is omitted for this exercise.)
To complete the statements, link sources when possible and use formulas when the item is highlighted in blue. Linking an account requires you to hit ""="" and then click on the cell that you want to link. This will pull in the amount from the cell you are linking. You may link from one tab within excel to another."
Attachment:- Excel_Assignment.xlsx