Excel+Final

Open Excel to a blank worksheet. Part A
 * Excel Final Exam **
 * o Change the formatting of the numbers to dollars.
 * o Make the grid around the cells visible.
 * o Insert the title “Monthly Budget” and center and merge it.
 * § Change the font to Arial Rounded, size 18.
 * § Make the text white and the fill black.
 * o Insert the subtitle “January 2016 – June 2016.”
 * § Change the font to Arial Rounded, size 10
 * § Make text white and fill black.
 * § Center and merge it.
 * o Total the expenses at the bottom of each month.
 * § Widen columns if necessary so numbers can be seen.
 * o Put a dark border around the edges of the document.
 * o Change the amount for gasoline in June from $60 to $70.
 * o Figure out the average for each row. You must know the formula on your own!
 * o Center and bold the headings (months and average)
 * Bold the headings in column A.
 * o Add a header with your name, period, and FINAL PART
 * o Save in the PUBLIC drive. Computer, 8th Grade, Rotation ____

Part B

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. **


 * Graph 2. – Bar Chart **

This will be a bar chart for income and expenses.

Below your total column, type Income in A12. Enter the income for each month. They are as follows:
 * January: 2,000**
 * February: 2,100**
 * March: 2,000**
 * April: 1,900**
 * May: 2,500**
 * June: 2,200**

Create a bar chart that looks like the one below. Include the chart you make and the date for the chart. Save AGAIN and then UPLOAD THIS FILE to your google drive and share it with Mrs. Saxton.