Please help my get through the first part of this. Do steps 1-5 because the financial statements are already completed. thank you

Excel Extra Credit FALL 2019 (1) - Excel Carson Lozano C - AutoSaveCH File Home A X Cut 0 x Comments Insert DrawPage Layout Calibri 12 BIU - - Formulas AA - A * Autosum A7 O Share 4 Ideas Peste Data Review View Help Foxit PDF Search === Wrap Text Gencral Merge a Center - $ -% S8 Alignment 5 Number Copy Insert Delete format Sort & Filter Sensitivity Formatting Table Styles Clear Find & Select Format Painter clipboard Styles g E7 1 Instructions 1. In the Trial Balance Tab, create drop down bones in the classification column so that a user can chose whether the item is an Asset, Uability or part of Owners' Equity. Assistance How to create drop down boxes 1. Gotocalcinthe nel cab 2 Click the Cats last the top uithe excel worksheet 3 Olck on Data Valdon in the trst drop down wed List 5. Gick on the court phone and enter ? Copy the drop down to created and cause in 2. Alter you have created drop down boxes, you need to click on the dropdown and enter Uc appropriate classification for each item. For example, in cell 05 G your drop down bus and let thulun Alcuni puble L lity How to sort 1. Within the dara highlight cells AB:D24 2 Click on Sort 3. When the box bens dick the opion thalas data has headers and then sort by dasarication Snapshoo been provided below) 2. Allons by the classification colun. You Do suit them in the following Order A cl Liabilities ar en Owners' Ecuily. Romas De Review Vo 4 od 131 Proprio then order the accounts the way they should be listed on the trial balance. For example, a I should be entered for Cash in the Order column in the appropriate cell. Use 5 sorting the accounts inite 3 te accounts by the order column using the same method that was previously cone for Clessitication. Check tipure Cash should be in row Gatter sorting by order statements Statement of cash flows is omitted for this Check Sures Dividers should be in row 17. classified as Owners' Equity and given the number 12 in the order column To complete the statements, link sources when possible and use formules when the mishishli ed in blue. Linking an account vu to h and then click on - tell that you want turk. This will pull in the amount from the call you won You should link from antal SAT VIL H aled in uw 18, Lilius Uma Equity and enth 19 in the under Aernunterrible should be in the number in the realumn Order Splies before Prepaid Score Instructions Trial Balance Anunt Payelehould helvenniher 7 in the under cum Financial Statements 1 - + 10% 634 PM Type here to search o e a 0 x W 9 12/5/2019 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