EECS 1520 Lecture Notes - Lecture 2: Window Decoration, Cash Register, In Step

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: John Hofbauer

Document Summary

This chapter is intended to expand on the features of excel introduced in the demonstration models of chapter 1. In addition some principles of how to design a model are introduced. Here is a list of what the lab covers: naming data ranges, creating intersheet formulas, using more of the functions available in excel, creating more charts and graphs. This chapter consists of a number of different exercises that demonstrate the use of multiple worksheets in a spreadsheet model. The first few exercises lead you through most of the details of building the models but as you progress fewer and fewer instructions are provided. It is expected that you will not simply follow the instructions by rote, but rather think carefully about what you are doing and why you are doing it so that you can apply the same principles and techniques yourself.