COMP 1010 Lecture 45: Lecture 45
17 May 2017
School
Department
Course
Professor
Document Summary
2 main functions of spreadsheets: processing tabular (numeric) data, presenting it in a meaningful fashion. Create more visually attractive spreadsheets using formatting techniques. For types of data that are not numeric, a graphical presentation (chart) may be more appropriate. Worksheet made up of cells containing values or formulas. Currency format: using currency format adds a $ to cells results, and rounds results to 2 decimals, e. g. If you wanted the actual value to match the displayed value, use round function. Formatting is applied to a value after it is calculated. Formatting affects only the display, not the value of the cell used in calculations. Worksheets only show a particular view of the cell (other view: graphical view: view differs from actual contents. Encounter views when a formula produces an error e. g. =a2/0: cell will display #div/0!, but if you look at the formula bar it will show =a2/0.
