excel budget m3 a2
Part 1: The Spreadsheet
- Begin by opening a new Microsoft Excel file. (You may use the template found here.)
- Save it as LastnameFirstInitial_M3_A2
- Use Rows 1 and 2 for a title.
- Beginning in row 4, use column A to list your different expenses.
- Label the next three columns (B, C, D) for the past three months.
- Fill in the appropriate amount for each expense for each month.
- Beside the column with your third monthâ€™s entries, create another column for totals for each category.
- Use a formula to calculate a total for each category of expense.
- In the row below your last expense entry, create another row for the monthly totals of expenses.
- Use a formula to calculate a total for each month of expenses.
- Beside the column add another column for calculating the percent of the budget for each expense category.
- Use a formula to calculate the percent that each expense category is of the total expenditures.
- Format the worksheet by adjusting column widths and wrapping text, and by applying appropriate financial number formatting and cell styles.
Please Note: While some calculations might be easy to do in your head or using a calculatorâ€”merely typing the answer into the appropriate cellâ€”the point of this assignment is to get you accustomed to using formulas. In situations requiring frequently updated data or more complex calculations, Excel is a very powerful tool if you know how to use it. Your grade is based on your demonstrated ability to use the required formulas.
Part 2: The Chart
Below your table of monthly expenses, you will create a chart using the numbers from your spreadsheet similar to the example below.
- Open the Insert ribbon at the top of the screen.
- Click on a populated cell inside your spreadsheet, then, click on Column on the Insert ribbon. Select the style of column chart you like.
- Click and drag your column chart into position below your spreadsheet.
Attached is an example.
Use figures below: