Project Description:

You carefully tracked your income and expenses for three months using one worksheet per month. The wor the same expense categories. You used the Miscellaneous category to include a variety of expenses, inclu June. For each month, you calculated the difference between your income and expenses as you were savir in June. Now you want to create a three$-$month summary to analyze your spending habits.

Steps to Perform:

Step

I

Instructions

$1$ Start Excel. Download and open the file named Exp$22\_$Excel$\_$Ch$09\_$ML$1\_$Expenses.xisx. Grader has automatically added your last name to the beginning of the filename.

$2$ You want to enter a title and apply a cell style to three worksheets at the same time.

Group the April, May, and June worksheets. Type Savings, Income, & Expenses in cell A Select the range $A1$:$C1$ and apply the Heading $1$ cell style.

$3$ With the worksheets grouped, you want to calculate the Ending Savings Balance.

In cell C$6,$ add the Beginning Savings Balance to the Monthly Savings Added.