Homework: what to submit

Chapter 1

Exercises to be submitted this week: Exercise 1, 2 and 3

Check list:

· Cover Page

· Comments worksheet (data view only) for Exercise 1

· MonthlyBudget worksheet (data view) for Exercise 1

· MonthlyBudget worksheet (formula view) for Exercise 1

· Sheet1 worksheet (formula view only) for Exercise 2

· Sheet1 worksheet, with graph (formula view only) for Exercise 3

Discussion:

Exercise 1

Comments worksheet:

A few sentences giving an overview of the spreadsheet.

MonthlyBudget worksheet:

This is fairly straightforward. Just follow the instructions. The labels (headings) can be adjusted using the formatting toolbar. Select appropriate fonts (looks like Arial to me), point sizes and bold as needed. About the only thing not explained is how to get the horizontal lines above and below the totals. After creating the SUM formula in cell C8, go to Format à Cells… à Border (the arrow means the selection from the sub-menu) and select the line style then the position. You get a preview in the large centre box labeled "text". You can make up any numbers you like for the "raw data", but try to be realistic. We're not asking you to expose your personal worth. J Notice that a Deficit, i.e. a negative amount, should be formatted with brackets around an unsigned number.

Exercise 3

The formula for the cosine function, =COS(A3*PI()/180), should be constructed using the "point-and-click" technique, as should all formulas in the future. Why? It's generally quicker and more accurate, especially when the formulas get complex. And occasionally I've encountered problems with Excel where I typed a formula that appeared correct and for some reason Excel rejected it. It's gets tricky when functions are nested. Ask your instructor to demonstrate the technique.