Lab 1 Notes - Thehe name bar T function icon Lab 1 Notes this type of formula should be avoided(B5 C5 D5.etc the name bar allows you to select a

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

View Full Document Right Arrow Icon
The name bar: The function icon: Lab 1 Notes this type of formula should be avoided (B5 + C5 + D5….etc). the name bar allows you to select a range of cells and name it SomeFunctionName( someArgumentList ) Allows you to execute a function The raw data on this worksheet – that is the data that is entered by hand Formulas: select a cell/ fx/select formula/click cell range/press enter/fill down by clicking the right hand corner and dragging down In Excel 2007 use Formulas/Name Manager to see the list of names. You’ll see that the cell reference is prefixed by the worksheet name – Parameters! in this case. This method of specifying a cell or range as coming from a particular worksheet is part of the syntax of Excel formulas EXP function (which calculates the value of e x , where x is the argument of the function). The RAND() function produces a random number between 0 and (less than) 1, The INT function does the conversion to an integer. The
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/15/2010 for the course CSE CSE 1520 taught by Professor Paul during the Spring '09 term at York University.

Page1 / 2

Lab 1 Notes - Thehe name bar T function icon Lab 1 Notes this type of formula should be avoided(B5 C5 D5.etc the name bar allows you to select a

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