7. The third area on your spreadsheet should calculate, for each month, how much extra money you will have, or how much money you are short. This is your net income after your mandatory expenses 8. The fourth area to your Excel spreadsheet, which will look similar to your area showing your mandatory expenses, that shows optional expenses. Optional expenses might include categories such as entertainment, dining out, and contributions to your savings and/or other investments. Include a total row and total column, similar to what you did for your income and expenses. In this area of your spreadsheet, you only should budget what you have available to spend. For example in the previous step if you found you have $200 extra one month, you only should spend up to $200 in optional expenses 9. The last area on your Excel spreadsheet that calculates, for each month, your month left over after all mandatory and optional expenses (Income - Mandatory Expenses - Optional Expenses), and then include a cell to total these values so that you can see how much extra money you might have (or money you are short) at the end of the year. For each cell in this area, apply conditional formatting (use the Conditional Formatting feature, and do not manually format each cell based on its value). The font color should be green if the value in the cell is greater than or equal to zero, or red if the value in the cell is less than zero. This information is your net income after all expenses Technical Requirements In addition to meeting the content requirements for this assignment, you also will need to demonstrate your proficiency of Microsoft Excel by applying the following formatting. Please note that you should not perform any calculations manually; if a cell should contain a calculated value, use a function or formula to calculate that value. ' Change the worksheet tab so that it displays "Monthly Budget" instead of "Sheetl." Also, change the tab color to one of your choosing - Create a title on your worksheet. Change the font, font size, font color, and fill color from the default values, and then Merge & Center the cell across the top of the worksheet - All Column Widths should be set to properly display all contents in the column (nothing should be cut off, and columns shouldn't be so wide that there is a lot of blank space in each cell) - For all cells that contain a dollar value, apply the Accounting Number Format - Add appropriate labels above each of the five areas of the worksheet to identify the information. For example for the table displaying the income, you might insert a row above the table containing text that reads, IIMonthly Income" to identify the information. This text also should be formatted using a different font, font color, and font size from the default so that it stands out - Create cells in your worksheet (near the table showing your mandatory monthly expenses) that use Excel functions to calculate the following using your mandatory monthly expense totals: 0 The total from the month where the mandatory monthly expenses are the lowest 0 The total from the month where the mandatory monthly expenses are the highest 0 The average amount of money you spend on mandatory expenses in a 12-month period - In a new worksheet (not a new workbook), create two charts (both charts should display side-by-side on the same, new worksheet)