APCO 1P01 Lecture Notes - Lecture 3: Exclamation Mark
9 Apr 2015
School
Department
Course
Professor
Document Summary
Spreadsheets: spreadsheets are used for arranging, manipulating and performing calculations on data, can be used for presentation, extrapolation and analysis. Formatting data: two basic ways to format a cell"s contents on excel, traditional text/element formatting (cosmetic details like colour, font, background, etc. , number formats to change the representation of data. We can apply different formats to separate the data from the presentation. Relative cell references: absolute index is one that"s always the same: Indicated with : extending a series won"t increase the index, relative index is more flexible and is the default, you can mix and match. Named cells: the name box (normally shows cell indices) can be used to assign a name, names may be managed on the formulas tab (under defined names) If the worksheet"s name includes a space, make sure you surround its.
