Required: Complete the table in the spreadsheet for each transaction showing the effect on the balance sheet and income statement. Leave unaffected cells blank and use positive and negative numbers for increases and decreases. Be sure to enter a formula to calculate column totals, the accounting equation, and net income. TIP: Create formulas for the Total row and the Accounting Equation before posting transactions. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. lowing transactions: howing the effect on the balance sheet and income statement. Leave rs for increases and decreases. Be sure to enter a formula to calculate fuation before posting transactions