Part A

Create a spreadsheet like the one below. Enter all the numbers.

• Change the formatting of the numbers to dollars.
• Make the grid around the cells visible.
• Insert the title Monthly Budget and center and merge it.
  • Change the font to Calibri, size 18.
  • Make the text white and the fill black.
• Insert the subtitle January 2020 June 2020.
  • Change the font to Calibri, size 14
  • Make text white and fill black.
  • Center and merge it.
• Total the expenses at the bottom of each month.
  • Widen columns if necessary so numbers can be seen.
• Put a dark border around the edges of the document.
• Change the amount for gasoline in June from $60 to $70.
• Figure out the average for each row. You must know the formula on your own!
• Center and bold the headings (months and average)
  • Bold the headings in column A.
• Add a header with your name, date, and COMPREHENSIVE PART 1.
• Ensure that it will Print with landscape orientation and everything will fit on the page
• Save and upload

Part B

Keep the work from Part A open. You will be making two graphs from this information.

Graph 1 Pie Chart

This graph will show the total amount of money spent on each category over a six month period.

To do this, you must total the amount spent on each item in column I. Do not include the average in your equation.

Next, highlight the expenses (house payment, gasoline, etc). Hold down the ctrl key and highlight your new totals.

Create a pie chart. Go to data labels and show the percentages.

Cut and paste all the information you need and the graph to a new sheet.

Save and upload

H Average A 1 2 House Payment 3 Charity 4 Groceries 5 Car Payment 6 Gasoline 7 Clothing 8 Utilities 9 Total 10 Income 11 B January 750 200 300 300 45 100 95 February 750 200 425 300 45 75 85 D March 750 200 425 300 50 60 95 E April 750 200 290 300 55 50 90 F May 750 200 325 300 45 100 80 G June 750 200 350 300 60 85 90 H Average A 1 2 House Payment 3 Charity 4 Groceries 5 Car Payment 6 Gasoline 7 Clothing 8 Utilities 9 Total 10 Income 11 B January 750 200 300 300 45 100 95 February 750 200 425 300 45 75 85 D March 750 200 425 300 50 60 95 E April 750 200 290 300 55 50 90 F May 750 200 325 300 45 100 80 G June 750 200 350 300 60 85 90