Computer Science 1032A/B Chapter Notes - Chapter 2: Killer Application, Visicalc, Microsoft Excel

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

Document Summary

Before advent of computer, accountants and financial planners used paper spreadsheets to illustrate financial calculations. Spreadsheet is an application designed to handle the organization, summarization, and presentation of primarily numeric data. Store information in cells in a large table (defined by letters as columns and numbers as rows) Spreadsheets allow you to enter information such as: letters (which cannot be used in arithmetic operations, numbers (which can be used for arithmetic operations, and, formulas (must begin with and equals sign. Referencing cells: when you build a formula, you can reference other cells by typing the address of the cell (b4 or c7) In other words, always use references to cells. Useful to show different data cells with an appropriate format. To create graph, select data along with names of items. Click on insert tab at top of screen. On insert tab, you will find a number of graph types to choose from.