lab1_demo1 - formulas for example. Try inserting a new...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Comments Page 1 Adding a list of numbers - Three Methods This is the first spreadsheet model in the course. As simple as it is, it nevertheless   demonstrates a number of principles of a spreadsheet model. Firstly, this worksheet itself - i.e. the Comments worksheet.  All models should contain such a worksheet to: • briefly describe the purpose of the model • describe each of the worksheets in the model • describe how the worksheets are interrelated • draw attention to any unusual features of the model In a complex model further documentation could be added to other worksheets - and a Comments worksheet such as this could become quite extensive. Secondly, the model demonstrates the use of formulas that are as general as possible. This means that when data is added to the worksheet it is not necessary to write new
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

lab1_demo1 - formulas for example. Try inserting a new...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online