Homework: what to submit

Chapter 3

Exercises to be submitted this week:

Chapter (Lab) 3: Exercise 1 (Sales Person Bonus Model)

Exercise 3 (Sales Discount Model)

3.2 (An Alternative Sales Discount Policy)

Exercise 5 (Kasch Pulse Recovery Study Again)

5.2 (Gender Dependence)

Check list:

· Cover Page

· Sales_Record worksheet (formula view only) for Exercise 1

· Discounts worksheet (formula view only) for Exercise 3.2

· Fitness_Data worksheet (formula view only) for Exercise 5.2

don't forget your name and student number in the header and

worksheet tab name in the footer of each worksheet in the

checklist.

Discussion:

Nothing much to say about this lab. Just follow the instructions very carefully.

On page 3-12 there is a parenthetic remark about clicking on the OK button after creating the OR function and thereby prematurely terminating the creation of the IF. Actually this isn't a problem. The author of the Lab Manual was not aware of how to get around this situation. The solution is: do not click on the OK button when you finish a function nested inside another function. Instead just move the mouse up to the formula bar and position it in the middle of the name of the function that you want to resume building, the IF in this case (literally position the cursor between the I and F of the word IF), and click the mouse. The function argument dialog box for IF returns. Now move the mouse into the field you want to resume working on and click. This activates the dialog box again. Only when everything is finished do you click the OK button.