This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: values for each of the methods. (The lab handbook leads you through how to do this.) Make sure th new column is inserted between columns B to G. You would like the sum should be updated to acc 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. Comments Page 2 he count Summing Page 3 Adding a list of numbers Method One: dealing with values separately Sum Values: 6 5 8 2 9 7 37 this type of formula should be avoided 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
- Spring '09
- Computer Science, Summation, spreadsheet model, new column