Question

Formulas - Setup the worksheet with formulas! 1. Open the MT Data file and save it as MT School Budget. Select the Budget sheet if it's not already showing on your screen. 2. In D11, calculate the Fall Term Total by adding the One-Time amount (B11) to the Monthly amount (C11) multiplied by the Months in the Term (B5). Make sure to use an absolute reference in the formula so that it will copy correctly in the next step. Note: the formulas you write will result in 0 because you have not yet added data. 3. Copy the formula in D11 down the column through D18. 4. Create similar formulas in G11, J11, and M11 and copy the formulas down the columns through row 18. 5. In N11, sum the totals in columns D, G, J, and M. Copy this formula down column N through row 18. 6. In cells B19:N19, sum rows 11 through 18. 7. Copy B18:N18 to B22:N53. 8. In cells B54:N54, sum rows 22 through 53. 9. In cells B56:N56, calculate NET income which equals Total Income minus Total Expenses. 10. In D57, calculate Projected End Balance by adding Net in column D to the Starting Balance (B4). 11. In G57, calculate Projected End Balance by adding Net in column G to the Project End Balance in column D. Copy G57 to J57 and M57. 12. Save your work. Formatting 1. Select cells B4:B5 and select More Borders under the border pull-down list in the ribbon. Select the color Light Blue, click Outline, and then click Inside. Click OK. 2. With B4:B5 still selected, double-click the Format Painter. "Paint" cells E4, H4, K4, B11:N18, and B22:N53. Click the Format Painter again to deactivate it. 3. Select A10:N10 and add Dark Blue fill color. Bold A10 and make the text color White. 4. Select A10:N10 again and click the Format Painter in the ribbon. "Paint" cells A21:N21.

Answer 1

5 500.00 INCOMES One time Monthly Employment From Parents From Student Loans From Scholarships Transfer From savings 6300 500 1500 250 1000 6300 500 1500 500 1500р 250 1000 | 250 оооооооо Н 1000 о о о 9550 3250 525 9550 o o o o o o o o o EXPENSES П One time Monthly 1200 125 D 1200 125 1200 50р 240 240 25 Tution Fees Housing / Rent Credit Card Payments Books School Supplies Food House Supplies Utilities Cell Phone Bill Car Payment Car Insurance Fuel Medicine 600 240 25 3600 300 3600 50 50 З ТЕГІЗІз вегета 50 600 501 45 100 540 600 S40 1200 900 7во 1200 900 2во 65 15 100 оооооооооооооооооооооооооооооооо ооооооооооооооооооооооооооооо ооо olololololololoo 1640 700 10040 o o o o o o o o o 10040 Net Income 1610 -175 -490 o o o o o o o o o -490

Q NO 3:- Available balance Ticket cost $ 10 $ 125 DEFICIT ($ 115) DECISION As total amount required to go for concert is $ 125. But only $ 10 available at the end. So we cannot afford to go to concert +IF (D22+D23)}<1500,"125,0)) IF STAEMENT FORMULA