Mark the steps as checked when you complete them.

Open the start file EX$2021-$ChallengeYourself$-1-4.$ The start file will be renamed automatically to include your name. Change the file name if directed to do so by your instructor and save it$.$

If the workbook opens in Protected View, enable editing so you can make changes to the workbook.

Make the following changes to the Budget worksheet:

Change the Electric item to Utilities $($cell A$12).$

Change the Insurance value from $90$ to $130($cell B$19).$

Update the text in cell D$6$ to: Quarter expenses

The worksheet is missing formulas to calculate totals. Enter formulas using the SUM function to calculate the following totals. Use any of the methods you learned in this chapter.

Enter a formula in cell B$7$ to calculate the total monthly income.

Enter a formula in cell B$24$ to calculate the total monthly expenses.

Enter a formula in cell E$16$ to calculate the total quarter expenses.

Use the status bar to verify that the formula is calculating the correct total for each cell range.

Cell E$18$ displays the number of months in the quarter. Change the number format in this cell to the Number format with no numbers showing after the decimal $($so the number appears as $3$ instead of $$3\mathrm{.}00).$

The number format in the Quarter Expenses section does not match the number format in the other sections of the worksheet. Change the number format for cells E$11$:E$16$ to the Accounting Number Format.

Review the formulas in the Discretionary Income section.

Cells E$4$:E$6$ should contain references to the cells where you just entered the formulas to calculate totals. Add the appropriate formula to cell E$6$ to reference the value in cell E$16($the total quarter expenses$).$

The quarter is three months long, so the formulas in cells E$4$ and E$5$ should multiply the total monthly income and total monthly expenses by three. Correct the formulas in cells E$4$ and E$5.$ Use an absolute reference to the value in cell E$18($the number of months in the quarter$).$

Use spelling checker to find and correct any spelling errors in the Budget $($Hint: There is one spelling error on this worksheet.$)$

Use the Recommended Charts feature to insert a clustered column chart representing the monthly expenses. Select cells A$10$:B$23$ for the chart data.

Change the chart title to: Monthly Expenses

Save the workbook. Do not close it or exit Excel.

Create a new file from a template called Personal Expenses Calculator. If you do not see this template, search for it using the search phrase personal expenses. NOTE: If you are unable to find the Personal Expenses Calculator template or are unable to complete this step due to your school's computer lab restrictions, download the template from the Resources link. Open the template and move on to step $13.$

Explore the worksheets in this workbook.

If you think you might like to come back to this workbook later for your personal use, this is a good point to save it$.$ Be sure not to close the file. Use the file name: $[$Your Initials$]$PersonalExpenses

You should still have two workbooks open: the college budget workbook from the beginning of the project and the personal expenses workbook based on the template. Arrange the workbooks so you can see both at the same time.

Try different arrangements until you find the one that works best for you.

Practice moving back and forth between the two workbooks.

Make the personal budget workbook active and navigate to the Dashboard worksheet. Modify the zoom to $80\%.$

Save and close the EX$2021-$ChallengeYourself$-1-4$ file. If you made changes to the personal budget workbook and you plan to continue using it$,$ be sure to save the changes and then close it$.$

Upload and save your EX$2021-$ChallengeYourself$-1-4$ project file.

Submit project for grading.