DLiteracy.com

Directions: Create a weekly budget spreadsheet using Microsoft Excel.

1. Listen to a presentation about how to use Microsoft Excel.
2. Create a new folder called math.
3. Create an index.html math home page.
4. Save the file as budget.xls in the math folder.
5. Link the assignment to your math homepage.
6. Create a document that includes formulas to determine your personal weekly budget.
7. Create 4 columns that include the date, item, expense, and income.
8. Include at least 10 rows of weekly entries.
9. Create a Total and Grand Total for the income and expense columns and make them bold.
10. Include 3 formulas, example: =sum(d4:d14) and =d16-b16.
11. The document includes bold titles at the top of each column and for the totals.
12. The document includes a title in size 18 bold font.
13. All cells containing numbers use a currency format.