|
|||
Home Page 1.0 Microsoft Word 1.1 Word Processing 1.2 Simple Web Pages 1.3 Drawing Tools 1.4 Word Activity 2.0 Microsoft PowerPoint 2.1 Day at School Show 2.2 Peer Evaluations 2.3 PowerPoint Activity 3.0 Microsoft Excel 3.1 Formulas and Formats 3.2 Graphing 3.3 Excel Activity |
3.1 Excel - Formulas and Formats Being able to do formulas dynamically in
Excel is definitely it's most powerful feature.
Instead of constantly re-calculating sums after every
change formulas in Excel update themselves automatically
whenever there is a change. Learning how to write
simple formulas is therefore essential.
Cell Addresses: Anyone who has played Battleship before (or is familiar the idea of a Cartesian Plane) should be able to understand that every cell in an Excel worksheet has an address that corresponds to the column and row it is in. For example the cell in the upper left hand corner of the sheet has the address of A1 (column A, Row 1). Writing a Formula: In the example to the left you can see a simple formula in cell A$ that adds whatever is in cell A2 to whatever is in cell A3. A more complex formula might start with "=sum" Excel Formula Tutorial: http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm |
||
© 2008 - 180techtips.com |