Carson Lozano a - AutoSave CE Excel Extra Credit FALL 2019 (1) - Protected View - Excel File Home Insert DrawPage Layout Formulas Data Review View Help Foxit PDF Search PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's sater to stay in Protected view Enable Editing 0 x Comments Share D E F G H I J K L M N O P Q R S T 1 Instruction 1. In the Trial Balance Tab l e crop down boxes in the classification column so that a user can chose wether the mis on Reliability ur parlut Ow E yuily. How to create drop down boxes: 1. Go to cell in the Trial Balance tab 2 Click the Data Tab at the top of the excel 3. Click on Data Valdation In the first drop down se ed List 5. Click on the source option and enterF4F7 5. Copy the drop down or created and paste in 2. Aller yu have created drop cu buces, you ruudlu classification for eachium. For wample, in celle your drop down box and select that an Accounts payable How to sort 1. Within the darang light cells :D24 2. Click on Sort 3. When the box opens click the option that as my data has headers and then sort by daratication Snapshots been provided below) 9. Sort the tour by the classifican culun. You ne to surt them in the following orders Liabilities and Formes Date Room Con 15 Sot Flex Sat & 4. Once the accounts have been sorted by classification, Den order accounts were should be listed on the trial balance. For example, ai should be entered for Cash in the Order column in the appropriate cell. USC numbria 1 19. Check lipure: Cuah shuuld be in row Baler Sworn the luna inium. S. Once you have determined the proper ordering then sort the accounts by the order column using the same method that was previously cont for Classification. Check tipure: Cash rould be in row Garter soitin by order. 6. On the financial Sementa, complete three financial s ements Statement of chrows ta omitted for this LREICIS I Lumplutur thu alamanca, link suure when possible and use formules when the m ighlighted in blue. Linking court requires you to hit and then click on the cell that you want tn link This will pull in the mount from the call you nek e You should link from nneth within eurelho annther Check figures Dividers should be in row Owners' Equity and iven the classified as 12 in the Urdu Service Hour should be in row 3 l ife D 'auty and given the numer 13 in the order Accounts Receivable should be given the number 2 In the order column order polles betone Prepalo Accounts Payable should be given the number 7 in the order colum. When ordering liabilities, revenues and expenses poin order of magnitude caning larges: to smallest Score Instructions Trial Balance Financial Statements Reacy - 10% 3:23 PM Type here to search 12/5/20193 Carson Lozano C - 0 x Comments Share AutoSave CE Excel Extra Credit FALL 2019 (1) - Protected View - Excel File Home Insert DrawPage Layout Formulas Data Review View Help Foxit PDF Search PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing F14 fo B C D E F Adjusted Trial Balance August 31, 2017 G H I J K L M N O Classification Order Asset Liability Owners' Equity 5 Description 6 Accounts Payable 7 Accounts Receivable 8 Accumulated Depreciation - Equipme 9 Cash 10 Common Stock 11 Depreciation Expense 12 Dividends 13 Equipment 14 Insurance Expense 15 Prepaid Insurance 16 Rent Expense 17 Rent Revenue 18 Retained Earnings 19 Salaries and Wages Expense 20 Salaries and Wages Payable 21 Service Revenue 22 Supplies 23 Supplies Expense 24 Unearned Rent Revenue Dr./(Cr.) (5,800) 9,400 (4,800) 10.900 (10,000) 1,200 2.800 16,000 1,500 2,500 10,800 (13,100) (5,500) 18,100 (1,100) (34,600) 500 2,000 (800) Score Instructions Trial Balance Financial Statements Reacy + 100% - ? A .Da Type here to search o e a 0 x W 9 L 3:25 PM 3: 12/5/2019 Carson Lozano C - AutoSave CE Excel Extra Credit FALL 2019 (1) - Protected View - Excel File Home Insert DrawPage Layout Formulas Data Review View Help Foxit PDF Search PROTECTED VIEW Be careful_files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing 0 x Comments Share L M N O P Q R S T Retained Earnings Balance Sheet Assets Income Statement 2 Revenues 1 Service Revenue 2 Rent Revenue Total Revenues Beginning Retained Earnings Plus Minute Net Income (Loss) Less Dividends (enter as a postve) Ending Retained Earnings Cash Accounts Receivable Supples Prepaid Insurance Total Current Assets 1 Salaries and Wages Expense 2 Rent Experts 2 Supples Expense 4 Insurance Expense s Depreciation Experise Total Expenses PP&E inct) Total Assets Net Income Current Liabilities Accounts Payable Salaries and Wages Payable Unaarned Ront Revenue Total Current Liabilities formula could be used lok amounts from th e lab Total Liabilities Tip: Service revenue should be a positive amount on the linus slalements but it ka credit on the trial balances. Stockholders Equity Common Stock Retained Earrings Total Stockholders' Equity Total Liabilities and Stockholders' Equity Score Instructions Trial Balance Financial Statements Reacy - 1 o e Type here to search a 0 x W 2 ? Av 9 E1 . D + 75% 3:26 PM 12/5/2019 o