This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: formulas for example. Try inserting a new column in the Summing worksheet and entering new values for each of the methods. (The lab handbook leads you through how to do this.) Make sure the new column is inserted between columns B to G. You would like the sum should be updated to account for the new value, but does it happen in each method ? Thirdly, it demonstrates simple but effective formatting aimed at drawing attention to important data. Summing Page 2 Adding a list of numbers Method One: dealing with values separately Sum Values: 6 5 8 2 6 7 34 Method Two: using a function and specifying a range of cells Sum Values: 5 4 2 6 9 11 37 Method Three: using a function and naming a range of cells Values: 6 9 7 2 8 12 44 =B5+C5+D5+E5+F5+G5 =SUM (B11:G11) =SUM (Values)...
View Full Document
This note was uploaded on 02/13/2012 for the course CSE 1520 taught by Professor Kemeny during the Fall '08 term at York University.
- Fall '08