Activity Two October 5th/6th 10 points
Due: 11:59 p.m. Tuesday, October 11th for MW sections
11:59 p.m. Wednesday, October 12th for TR sections
CHANGE: The quiz covering Excel will be October 17th/18th
The intent of this activity is to become familiar with MS Excel features.
1. Start the Microsoft Excel application. The Program starts with a new worksheet.
2. Save your file as “Act2_lab section number_ last name” in your Home directory on
ONID.
3. Remember to save your file frequently.
4. Create a worksheet that will assist you in keeping track of your income and expenses
this term. You will also need to include an assumptions table that can help you
answer what-if questions such as, what if my rent increases by 10%.
In cell A1, type Cash Flow Projections.
In cell A2, type Fall 2005.
In cell B3, type October. Use the fill handle to add month names through cell D3
(December).
Type Total in cell E3.
Type Income in cell A4.
Type Expenses in cell A6. Start with A7 and type at least 5 (but no more than 8)
essential expense categories down column A (example: Rent, Food, Tuition,
Books, Utilities, Car). Indent your expense category names.
Type Total Expenses in the cell under your last category name in column A and
type Cash Flow in the cell under Total Expenses. These should NOT be indented.
Leave a blank row under Cash Flow and in the next row type Assumptions in
column A. Copy your expense category names and paste under Assumptions.
5. Enter some numbers, preferably not the same, in row 4 to represent your income for
each month.
6. Enter percentage values in column B, preferably not the same, for each of your
expense categories under Assumptions. In deciding these consider, what % of my
income is for rent, food, etc. The total of the percentages should not equal 100. Why?
No cash flow (money left for fun stuff)!
7. Enter formulas for October (column B) for each expense using the values under
Assumptions against your income. (Formulas begin with an ‘=’ sign and these will
need to use the concept of absolute cell reference; in other words, the percentage you
have under Assumptions for each category is multiplied by your income for the
month to determine the amount of the expense. Not realistic for rent because this is
most likely a fixed amount, but this will demonstrate the power of Excel.)
8. Use the SUM function to total your expenses.
9. Cash Flow = Income – Total Expenses
10. Use the fill handle or Menu bar>Edit>Fill to complete the worksheet for the
remaining months.
11. Total each row in column E.
12. Format the worksheet (note to TAs: use as a guide, demonstrate a variety of options).
