Question: Excel 2019 Assignment Creating a Budget You will be creating a worksheet similar to the example on page 330 in your book. 1. Type the

Excel 2019 Assignment Creating a Budget You will be creating a worksheet similar to the example on page 330 in your book. 1. Type the words in the following cells: a. Budget in cell A1 b. Income (Monthly) in cell A3 c. Paycheck in cell B4 d. Other in cell B5 e. Total Income in cell B7 f. Savings and Investing in cell A9 g. Savings Account in cell B10 h. Investments in cell B11 i. Amount Left for Expenses in cell B13 j. Expenses (Monthly) in cell A15 k. Housing in B16 l. Car Payment/Insurance in cell B17 m. Groceries in cell B18 n. Restaurants / Food Delivery in cell B19 o. Internet in B20 p. Phone in B21 q. Medical Insurance and Copays in cell B22 r. Gas in cell B23 s. Total Expenses in cell B25 2. Enter your personal data in the following cells. (Your actual income, savings, and expenses.) a. Paycheck in cell C4 b. Other in cell C5 c. Savings Account in cell C10 d. Investments in cell C11 e. Housing in C16 f. Car Payment/Insurance in cell C17 g. Groceries in cell C18 h. Restaurants / Food Delivery in cell C19 i. Internet in C20 j. Phone in C21 k. Medical Insurance and Copays in cell C22 l. Gas in cell C23 3. Format the Data as follows: a. Merge and center cells A1:D1 b. Apply the cell style of Title to the word Budget and make the word Bold c. Apply the Blue, Accent 5, Lighter 60% cell shading to cells A1:D1 d. Apply the cell style of Heading 1 to the contents of cell A3, A9, & A15 e. Autofit the column width of Column A & B f. Change the font color of cells B7 & B13 to Gree

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!