There are specific requirements for the assignment.$$ You will be able to enter your own data and choose colors.$$ However, this assignment will be challenging because you will have to determine what formula to use based on the instructions.

ENTER DATA:

Enter data including income, expenses in the cells listed. The columns that need data entered are expected and actual.$$ If there is no expense it is okay to use zero.$$ You can add rows if you like if there is an income$/$ expense that is not listed but remember to include them in your totals when you do your calculations.

FORMAT FOR SPREADSHEET:$($these items must be formatted on the spreadsheet$)$

Add a title for the budget and stretch it across the columns A through FUnderline titlesBold the totals on spreadsheet and choose font$/$background cell color other than black$/$no color for the total rowsFormat all money amounts as Currency or Accounting with $0$ decimal placesCreate a conditional format for the Amount Over$/$Under column and row $($green for over budget$/$red for under budget$)$

FORMULAS AND CHARTS FOR SPREADSHEET:$($create formulas or functions in spreadsheet$)$

Enter a function that gives the current date and the date changes when the day changesEnter a function that calculates Total Income and Total Expenses in the bottom of the income and expense columnsCreate a formula that shows the subtracts expected income from actual income and also expected expense from actual expense in the Budget $($Amount Over$/$Under$)$ rows, then fill the remaining cells in the columnCreate a logical formula in the Over$/$Under Y$/$N row using words on each row to show if the expense is Over$/$Under budget $($If the expense is over, show the word $$yes$$ and if it is under show the word $$no$$ in the Over$/$Under Y$/$N row$/$column$),$ then fill the remaining cells down the columnInsert a function to show the average, largest and smallest expense of each column $($at the bottom of the budget$)$Create two charts: one that displays income and one that displays expenses $($either use expected or actual$)$

Insert title and use a chart theme besides the default themeName x and y axis appropriatelyMake sure the legend has the correct information regarding income or expense

Create a chart that shows the percentage distribution of the expenses $($either expected or actual$)$

Insert title and use a chart theme besides the default themeName the x and y axis appropriatelyMake sure the legend has the correct information regarding income or expense