Step 2: Excel Workbook

For this part of the project, you will work on a budget in an Excel workbook.

1. Create an Excel workbook and save is as Budget Project Excel FName LName. The workbook will contain three worksheets, created from scratch and not using an existing template.
2. Sheet 1: Name the sheet Budget 2021.
   1. Create a 2021-2022 Budget for yourself or your family. It should have data for 12 months, with some of the data estimated. You may start your budget in October and end in September.
   2. The budget should include the following:
      1. Income
      2. Total Income
      3. Expenses - at least five should be listed (can include mortgage, electricity, cable or dish, college (tuition, books), insurance, food, entertainment, etc). Expenses must include car payment from Sheet 2 below.
      4. Total Expenses
      5. Net Income (Income minus Expenses)
   3. Formulas must be designed to calculate accurately. Formulas to include SUM, MIN, MAX, and COUNT.
   4. Format your spreadsheet. Consider Fonts, Font size, Bold, Underline, Merge and Center, Currency, decimal placement, Centering, indenting, and styles.
3. Sheet 2: Name the sheet Car Payment.
   1. Use the Payment Function to determine the monthly payment to purchase a vehicle within your budget. Use an interest rate of 3.89% and a duration of 60 months.
   2. This car payment will be included in your Budget 2021 worksheet
   3. Enhance this sheet with formatting.
4. Sheet 3:
   1. Create a Clustered Bar Chart of your Budget 2021 using expenses and months.
   2. Move this chart into its on sheet and name the sheet Income Expense Chart.
   3. The chart should have Title, Legend, Data Label Call Out on highest expense.
   4. Use Fill color on the chart area and plot area.
   5. Enhance this chart with formatting too.
5. Create a Column Sparkline on your Budget 2021 worksheet to convey the Expenses Totals. Put the Sparkline to the right of your worksheet.