Excel Introduction Assignment
Budget Assignment
The given spreadsheet is a reflection of how you have spent your money over the first six months of the year. You are planning on saving money for a down-payment on a new car and need to have a good idea of where your money is going every month. Your assignment is to apply what you have learned to date about spreadsheets and create a budget for yourself.
Numbers are right aligned and words are left aligned when creating spreadsheets.
Instructions:
Open Excel, the spreadsheet program. Using the information found below, create a spreadsheet. Save your spreadsheet as Personal Finance.
Your Expenses for January are: Rent $650, Utilities $78.96, Telephone $35.99, Groceries $75.66, Dining out $100.00, Car Payment $349.23, Gas $60.00, Repairs $25.00, Cable TV $34.99, Internet $29.00, Movie Tickets $20.00, Clothes $50.00, Accessories $20.00, Gifts $30.00, Salon $125.00, Savings $200.00, Tuition $1500.00, Books $300.00
Your Expenses for February are: Rent $650, Utilities $68.50, Telephone $42.53, Groceries $65.10, Dining out $100.00, Car Payment $349.23, Gas $60.00, Repairs $25.00, Cable TV $44.99, Internet $29.00, Movie Tickets $20.00, Clothes $45.00, Accessories $20.00, Gifts $15.00, Salon $125.00, Savings $175.00
Your Expenses for March are: Rent $650, Utilities $89.54, Telephone $39.99, Groceries $79.19, Dining out $100.00, Car Payment $349.23, Insurance $265.90, Gas $65.00, Repairs $25.00, Cable TV $34.99, Internet $29.00, Movie Tickets $20.00, Clothes $50.00, Accessories $20.00, Gifts $30.00, Salon $125.00, Savings $200.00
Your Expenses for April are: Rent $650, Utilities $75.20, Telephone $53.98, Groceries $69.99, Dining out $100.00, Car Payment $349.23, Gas $60.00, Repairs $25.00, Cable TV $54.99, Internet $29.00, Movie Tickets $20.00, Clothes $45.00, Accessories $15.00, Gifts $30.00, Salon $125.00, Savings $200.00
Your Expenses for May are: Rent $725, Utilities $92.34, Telephone $44.67, Groceries $82.13, Dining out $100.00, Car Payment $349.23, Gas $75.00, Repairs $25.00, Cable TV $34.99, Internet $29.00, Movie Tickets $40.00, Clothes $50.00, Accessories $20.00, Gifts $30.00, Salon $125.00, Savings $200.00, Books $175.00
Your Expenses for June are: Rent $725, Utilities $88.63, Telephone 35.99, Groceries $71.41, Dining out $100.00, Car Payment $349.23, Insurance $265.90, Gas $60.00, Repairs $25.00, Cable TV $49.99, Internet $29.00, Movie Tickets $30.00, Clothes $45.00, Accessories $15.00, Gifts $30.00, Salon $125.00, Savings $200.00
Formula Instructions:
Include Totals by the month and by the expense. Add another column or row to calculate the percentage of total expenses for each category by dividing each category expense total by the Grand Total
Formatting Instructions:
1. Resize the columns, if needed.
2. Bold and underline the title (Budget)
3. Center the title across the columns being used in the spreadsheet, (Merge and Center button)
4. Bold, italicize and center the column headings.
5. Use additional formats to make the report attractive.
6. Spreadsheet, when printed, is centered vertically and horizontally on page.
7. Scale the spreadsheet proportionately on the page, but keeping it on one page.
8. Your Name and Period are in the right header of the page in a custom header.
9. The name of the spreadsheet (Personal Finance) is in a customer header on the left side of the spreadsheet.
10. Print spreadsheet. Print formula page and attach it to first spreadsheet. Turn both spreadsheets in for credit.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- writing assignment for 2nd grade
- aesop substitute assignment aesop online
- 6th grade writing assignment ideas
- 6th grade writing assignment pdf
- 9th grade writing assignment worksheet
- 9th grade writing assignment classroom
- 10th grade writing assignment idea
- biol 101 individual assignment 1
- aesop substitute assignment pin number
- literacy narrative assignment essay
- online homework assignment help
- introduction to excel 2016 pdf