{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Guide - v2007

# Excel Guide - v2007 - HW1 Excel Project ED370 Fall 2008 The...

This preview shows pages 1–2. Sign up to view the full content.

HW1 – Excel Project ED370 – Fall 2008 The purpose of this assignment is to learn how to enter basic mathematical formulas in excel and create graphs. The data are estimates of the ratio of financial obligations (required payments on outstanding mortgage and consumer debt, automobile lease payments, rental payments, homeowners’ insurance, property tax payments, etc.) to personal disposable income. The figures in the data set are percentages (i.e. 17.3 = 17.3%). 1) Download “US Financial Obligations.xls” from Blackboard and open the file. 2) First, let’s figure out how much worse off renters are in terms of financial obligations. In cell D2, enter the formula “ = B2 – C2” and hit enter. You can double click on the square shown (and circled) in the screenshot and Excel will populate the remaining rows (it keeps going until the data in the immediately adjacent cells – column C – run out). Note: Excel takes formulas interactively with the mouse so rather than type the target cells for your formula you can just type “=”, select cell B2 with the mouse, type in a minus sign, and select cell C2 with the mouse then press enter.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

Excel Guide - v2007 - HW1 Excel Project ED370 Fall 2008 The...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online