R. Craig Collins > BCIS 1301/COSC 1301/ITSC 1309 > Lab 4

Lab 4 © R. Craig Collins, 2005/6

General Lab Directions
Note: There is not enough time in lecture to cover all the material; read your book BEFORE you begin the lab
Note: Typically labs will require you to invest some time in the lab, outside of class lecture hours

Add the following to an Excel worksheet:

• 5% Verify correct numbers entered as starting point
  Total Wages, Rent and Food
• 5% Total Wages B3:E3 in F3
• 5% Total Rent B7:E6 in F6
• 5% Total Food B7:E7 in F7
  Total Expenses
• 5% Total Jan Expenses B6:B7 in B8
• 5% Total Feb Expenses C6:C7 in C8
• 5% Total Mar Expenses D6:D7 in D8
• 5% Total Apr Expenses E6:E7 in E8
• 5% Total Jan-Apr Expenses B8:E8 in F8
  Subract Expenses from Wages, and place the results in Row 10
• 5% Subract Jan Expenses from Jan Wages, =B3-B8 and place the results in B10
• 5% Subract Feb Expenses from Feb Wages, =C3-C8 and place the results in C10
• 5% Subract Mar Expenses from Mar Wages, =D3-D8 and place the results in D10
• 5% Subract Apr Expenses from Apr Wages, =E3-E8 and place the results in E10
  Calculate Income
• 5% Total Income - Expenses B10:E10 in F10
  Finish up
• 5% Format the numbers as currency
• 5% Select cells A10:E10, and create a column chart
• 5% Table and chart should appear as below