CS100 Lecture Notes - Lecture 4: Equals Sign, Spreadsheet
25 Mar 2016
School
Department
Course
Professor
Document Summary
An electronic spreadsheet can automatically perform calculations and recalculations when data is updated. The workspace for a spreadsheet ile is called a workbook. Each workbook includes one or more worksheets that are large grids of rows and columns. Each column (vertical) is represented by one or more letters, and each row (horizontal) is represented by a number. It is often convenient to refer to a rectangular region of cells, known as a cell range: cell ranges have two addresses separated by a colon, ranges can span multiple columns and rows (e. g. , There are three kinds of entries that can be placed in a cell: labels (e. g. , cost, 12 arbour st. ): A label can contain letters, punctuation, digits, and other characters. Note that a phone number such as 555-1234 is a label because it contains both text (the hyphen representing something other than negation) and digits (5551234: numeric values (e. g. , 34, 22. 45): A numeric value can contain a number only.
