4. 8/28) Part 2: 1. Open the Microsoft Excel spreadsheet named Accounts 2. Select Sheet1. 3. Format Text: a Select cells A1 through E1. Merge and center the data. Change the Cell Styles to Title b: Select cells AS through E. Change the Cell Styles to Heading 3. Center the text. Bold cells A3, A4, and 03. Use italics for cells 83 through 84 and E3. d. Select cells A15 through E16. Change the Cell Styles to Total. Change background to light gray Format Numbers: a. Select cells At through A14. Format the cells as date to display the month and year (Format: 1. Select cells 06 through D14. Format as commas with two (2) decimals. Select cells E6 through E15, C15, and D15. Format as Accounting with two (2) decimals. 5. Formulas: a Use the following if Statement to write the formula in Excel to calculate the balance: if(Credit greater than 0, Balance plus Credit, Balance minus Debit) b. Find total Debit and Total Credit c. Final Proof: Balance plus (Total Debit minus Total Credit) 6. Rename the Sheet 1 tab, Accounts Payabile. Change the tab color to blue 7. Select Sheet 2 and rename it Accounts Receivable. Change the tab color to green. 8. Format Text: a. Select cells A1 through El. Merge and center the data. Change the cellStyles to Title 5. Select cells AS through ES. Change the Cell Styles to Heading 3. Center the text. Bold cells A3, A4 and 03. Use italics for cells B3 through 84 and 13. d. Select cells A15 through E16. Change the Cell Styles to Total. Change background to light gray 9. Format Numbers a. Select cells AG through A14. Format the cells as date to display the month and year (Format: 8/28) b.Select cells 06 through D14. Format as commas with two (2) decimals. c Select cells E6 through E15, C15, and D1S. Formatas Accounting with two (2) decimals. 10. Formulas: a. Use the following if Statement to write the formula in Excel to calculate the balance: = f(Debit greater than 0, Balance plus Debit, Balance minus Credit) b. Find total Debit and Total Credit c. Final Proof: Debit less Credit 10:48 HODODDO + Accounts - Saved . fc . E F H . K M Clementing High School Accounts Payable 1 2 1 Arrunt 210 Name L. Dexter Cleaning Services Address 1300 Oak Street, Mobile, AL 36604-2147 Den Credit 4 5 6 7 B Balance 1075.1 05.91 1075.1 90S 1517.9 10 11 12 11 14 15 28 Opening Balance 31-Invoice 106 14 Sep Check 57 21-Sep Inice 121 30 Sep woice 124 S-Oct Check 59 13 Octwoice 1219 20-0ct Invoice #229 30 Oct Invoice 245 Final Proof 403.1 196 51B 17 ES