Step 30 of 40: Remaining Op. Budget Formulas L 1 November M December N 4 Click Auto Sum on the Home menu or press Cmd-Shift-T. Total 150000 150000 L 12 Operating Expenses 13 Payroll (16,000 14 Utilities (1ther YOUR TURN: Copy the expense amount formula 19 across the columns and down the rows as needed. 153000 153000 ansert Delete 28. O Format X Funds Select Filter -75900 - 15000 -90900 59100 -76500 -1530d -91800 61200 September October Novembe get - 16000 -7000 -19500 17 Total Operating Expenses Net Income 15 16000 -700d -1950 42500 18700 1 November Decenf-SUM(B3.M3) 42500 16600 YOUR TURN: Compute Total Operating Expenses and Net Income 3 150000 153000 . 163800 5 150000 1530 Excel should sum columns B:M on each row. Use Show Formulas on the Formulas menu to review the formulas and make corrections if needed Hold down the Cmd key and select the cells shown Students Step 30 of 40: Remaining Op. Budget Formulas L 1 November M December N 4 Click Auto Sum on the Home menu or press Cmd-Shift-T. Total 150000 150000 L 12 Operating Expenses 13 Payroll (16,000 14 Utilities (1ther YOUR TURN: Copy the expense amount formula 19 across the columns and down the rows as needed. 153000 153000 ansert Delete 28. O Format X Funds Select Filter -75900 - 15000 -90900 59100 -76500 -1530d -91800 61200 September October Novembe get - 16000 -7000 -19500 17 Total Operating Expenses Net Income 15 16000 -700d -1950 42500 18700 1 November Decenf-SUM(B3.M3) 42500 16600 YOUR TURN: Compute Total Operating Expenses and Net Income 3 150000 153000 . 163800 5 150000 1530 Excel should sum columns B:M on each row. Use Show Formulas on the Formulas menu to review the formulas and make corrections if needed Hold down the Cmd key and select the cells shown Students