Question: please help me create this excel sheet. thank you. this is all that the teacher provided she would like us to answer in excel. Sheet

please help me create this excel sheet. thank you.
 please help me create this excel sheet. thank you. this is
all that the teacher provided she would like us to answer in
this is all that the teacher provided she would like us to answer in excel.

Sheet 1: Name sheet Budget 2020. Create a 2020 Budget for yourself. It should include the following: Income, Total Income, Expenses (can include mortgage, electricity, cable or dish, college (tuition, books), insurance, car payment, food, entertainment, etc), Total Expenses, Net Income (Income minus Expenses). Formulas must be designed that calculate accurately. Formulas to include Sum, Min, Max, Count. Work these formulas into your spreadsheet. Format your spreadsheet using Bold, Fonts, Font size, Underline, Merge and Center, Currency, decimal placement, Centering, indenting, and styles. The more you use the better your score. Show me your knowledge of what you learned through the book and class. Sheet 2: Name sheet Car Payment. Do a Payment Function to buy a vehicle within your budget. This car payment will be included in your Budget 2020 worksheet. Enhance this spreadsheet with formatting. Interest Rate is 3.89% Duration: 60 months Sheet 3: Create a Clustered Bar Chart of your Budget 2020 using expenses and months. Move this chart into its on sheet and name the sheet Income Expense Chart. Chart should have Title, Legend, Data Label Call Out on highest expense, Fill color to chart area and plot area. Enhance this chart with formatting too. Create a Column Sparkline on your sheet Budget 2020 to convey the Expenses Totals. Put the Sparkline to the right of your spreadsheet

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 Accounting Questions!