Excel Charts and Graphs Assignment

Directions: Create a monthly budget that includes the following:

• A title in row 1
• At least 5 budget items and values
• A total of all budget items
• Format the spreadsheet to make it look attractive and neat
• Create a chart using your budget data
  • Add a chart title
  • Add data labels (value)
  • Apply the chart style of your choice
• Print the chart and the data sheet on the same page
• Adjust print options: Fit to one page, landscape orientation, center on page vertically and horizontally, create a custom footer that says your name, print gridlines.
• Save as: Charts

Excel

Budget Assignment

Create a budget worksheet using the information below

1. Enter the data below into the appropriate cells:

A1: Monthly Expenses

A2: January

A3: MortgageB3: 900

A4: TuitionB4: 300

A5: UtilitiesB5: 400

A6: FoodB6: 200

A7: Car PaymentB7: 150

A8: Entertainment B8: 100

A9: ClothingB9: 100

A10: Car Insurance B10: 50

A11: Total

1. Wrap text in column A
2. Use “Autofit” to adjust the column width in column B
3. Set the row height for row 1 to 75 pixels
4. Change the value in cell B7 from 150 to 450
5. Delete January from cell A2
6. Move the cell range A3:B11 to the cell range A2:B10
7. Enter your name in cell B1
8. Name the range A1:B10 Budget
9. Save as: Budget
10. 10. Print and turn in
11. 11.E-mail to phill@jwu.edu