lab1_demo2 - formula was created and then...

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

View Full Document Right Arrow Icon
Comments Page 1 Operations on Whole Rows or Columns This model shows a number of approaches to performing simple calculations on whole columns of d methods can be used with rows of data. The Datasheet worksheet shows two columns of numbers labelled X and Y, and then two columns - and the other labelled X*Y - which contain the result of adding or multiplying the values in the X and the respective rows. It also contains four further rows labelled Minimum, Maximum, Average, and M contain such values for their respective columns. The calculation of X+Y is done with simple cell references. The first one is created and then "filled" d column. The X*Y column is calculated with a formula using names for the X and Y columns - again t
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
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: formula was created and then "filled" down the column. The Minimum, Maximum, Average and Median rows are also created with two types of formulas. In of cell references is specified and in the other the named cell references are used. Comments Page 2 data. The same - one labelled X+Y d Y columns for edian which down the the first one case a range DataSheet Page 3 Using a copied Using named cell reference ranges X Y X+Y X*Y 4 6 10 24 5 10 15 50 3 5 8 15 7 2 9 14 3 7 10 21 9 3 12 27 8 9 17 72 7 5 12 35 Minimum: 3 2 8 14 Maximum 9 10 17 72 Average: 5.75 5.88 11.63 32.25 Median: 6 5.5 11 25.5...
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 / 3

lab1_demo2 - formula was created and then...

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

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