R. Craig Collins >Common > Budget Lab

Budget Labs © R. Craig Collins, 2005/8

To details on completing yourname-my-budget.xls (do after completing yourname-budget.xls)

Details on completing yourname-budget.xlsx
Created a folder named lab5. Download and save the budget starter in the lab5 folder (right click on budget-starter.xlsx, and choose Save Target As...)

After finishing some practice steps, you will encounter the following:

First make Column A wide enough so you can read Income - Expenses in A42
Autofill or type in Mar and Apr between Feb and Total

Total Wages, Rent and Food

• 5% Total the Wages in B35 through E35 (B35:E35) in F35
• 5% Total the Rent in B38:E38 in F38
• 5% Total the Food in B39:E39 in F39
  
  Total Expenses
• 5% Total the Jan Expenses B38:B39 in B40, fastest way, select B40, then click
• 5% Total Feb Expenses C38:C39 in C40
• 5% Total Mar Expenses D38:D39 in D40
• 5% Total Apr Expenses E38:E39 in E40
  
• 5% Total Jan-Apr Expenses B40:E40 in F40
  
  Subtract Expenses from Wages, and place the results in Row 42
• 5% Subtract Jan Expenses from Jan Wages, =B35-B40 and place the results in B42
• 5% Subtract Feb Expenses from Feb Wages, =C35-C40 and place the results in C42
• 5% Subtract Mar Expenses from Mar Wages, =D35-D40 and place the results in D42
• 5% Subtract Apr Expenses from Apr Wages, =E35-E40 and place the results in E42
  
  Calculate Income
• 5% Total Income - Expenses B42:E42 in F42
  
  Finish up
• 5% Format the numbers as currency ($)
• 5% Select cells A42:E42, and create a column chart
  
  Bonus, instead select A1:E1, then hold the [Ctrl] key and add A10:E10 to the selection
  This will add the names of the months to the chart
  
• 5% Table and chart should appear as below

• Prepare for printing
• 5% Select the numbers and chart, then choose File\Print Area\Set Print Area
  Choose File\Page Setup\Header and Footer and click Custom Header to add your Name to printouts


Save

• 15% Save as yourname-budget.xlsx

Your budget

Use the budget starter Sheet2, or Start a new spreadsheet file, save it in the lab5 folder, and call it yourname-my-budget.xls.
This spreadsheet should have ALL the features of the demo budget, and these changes

• 5% 6 months
• 15% at least two types of income, with a Total Income row
• 15% at least four types of expense , with a Total Expenses row
• 10% calculate total of each income row for the entire 6 months
• 10% calculated total of each expense row for the entire 6 months
• 10% calculate profit for the entire 6 months by subtracting total expenses from total income
• 10% calculate profit for the each month by subtracting total expenses from total income
  Should be similar to layout below...
• 10% chart monthly income-expenses (do not include total)
• 15% Format as currency, add remove my text and my cell fill colors, add your own formatting, then Save as yourname-my-budget.xlsx

Zip files together and rename with yourname and lab number to submit.