York University

EECS 1520 3.0 — Computer Use: Fundamentals

Winter 2016


Lecture Schedule

Course Outline



York University


Important Resources:

Chapters:    0    1    2    3    4    5    6    7    8    9   

Chapter 3 Homework

Support Files

What to Submit

  • 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 to put your name and student number in the header, and worksheet tab name in the footer, of each worksheet in the checklist.

Discussion, Hints & Tips

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.