Computer Science 1032A/B Lecture : Computer Science 1032 Excel Notes.docx

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Diane Goldstein

Document Summary

Workbook: a collection of one or more spreadsheets (every excel workbook has three spread sheet tabs) An application designed to handle the organization, summarization, and presentation xof primarily numeric data. Turned out to provide incredible labour savings, and were greatly used in the early adoption of personal computers. Filling formulas: relative reference: a type of referencing that adjusts during a copy operation. Default mode; when an equation is copied from one cell to another, the value of the formula are changed relatively to the position from the location of the copied formula. Ex: if the formula in a5 is =b23*d9-k12 is copied to b6, b6 contains =c24*e10-l13: absolute reference: a type of referencing that remains constant when copied. Used when a cell reference is not supposed to change during replication. A row or a column designator that must not change during replication must be prefixed with $".