1. Prepare an income statement from a list of accounts. FILE HOME INSERT PAGE LAYOUT Preparing an income statement - Excel FORMULAS % DATA ? - REVIEW VIEW A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Calibri 11 Paste BIU Clipboard Font H2 fx A B 3 4 5 6 1 The list below shows select accounts for Reading Readiness Company as of January 31, 20X1. 2 (Accounts are in alphabetical order.) Accounts Payable Accounts Receivable Cash 8,088 6,960 13,445 7 Equipment 4,800 8 Insurance Expense 1,350 9 Operating Expense 11,800 10 Other Expenses 3,482 11 Other Revenues 6,050 12 13 14 15 Rent Expense Salaries Expense Short-term Notes Payable Test Prep Revenue 4,800 6,882 17,200 15,400 16 Tutoring Revenue 9,100 17 Unearned Revenue 1,046 18 19 Required: 20 1. Prepare an Income Statement for the month ended January 31, 20X1. Use cell references 21 to select account titles and amounts to be included on the income statement. E F G H Sign In