budget template

Lab 11: Excel I - Budget Template

1. Show your notes from the last three topics (Google Drive, Word, Internet) to the TA 10

2. Show your current Historical Prices table in the Access database to the TA. There should be at least 27 entries now (3 products x 3 vendors x 3 weeks)

10

3. Open your Budget Template Excel document and save it as your own under a different name.

Change the template's spending categories to match your spending patterns.

Insert new worksheets for the months of February - July, rename them to the month's

names, and populate all months with the budget template.

Do a budget for June.

(You may have already have done this part, but now you are getting points for it)

20

4. "Freeze panes": title row and date column of your data 15

5. Add a column to the “Cost of Food” section that contains a formula for computing the total food cost (=Vx+Wx+Xx+Yx) in each row.

5

6. Add a column to the section with the Deposits column that contains a formula for converting total income in dollars to a foreign currency (choose any non-US

currency).

5

7. Format result of foreign currency to 2 decimals. 5

8. Insert formula for rent as a Percent of total budget. Calculate at least one more category as a percentage of your total budget (e.g. Food or Entertainment)

5

9. Format the % to 1 or 2 decimals. 5

Total: 80