Lecture+21+-+Excel+3

Lecture+21+-+Excel+3 - CS170Lecture21 Spreadsheetspart3...

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

View Full Document Right Arrow Icon
CS 170 Lecture 21 Spreadsheets part 3 Kristian Stout stouty@rci.rutgers.edu Office IN: Livingston Student Center, A lounge near “the rock” and the commuter lounge. Office Hours: TTH 5:30 – 6:30
Background image of page 1

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

View Full DocumentRight Arrow Icon
A Note on Referencing Cells A1  this Relatively references the cell A1 $A$1 this Absolutely references the cell A1 A1:B4 this references the RANGE of cells from A1 to B4 ie this is a “box” that encompasses all of the cells  between and including A1 and B4 You can use absolute references in ranges eg $A$1:$B$4
Background image of page 2
Sum Function Probably the most popular function in any spreadsheet is the  SUM function. The Sum function takes all of the values in each  of the specified cells and totals their values. The syntax is:  =SUM(first value, second value, etc)  In the first and second spots you can enter any of the  following: constant, cell, range of cells.  Blank cells will return a value of zero to be added to the total.  Text cells can not be added to a number and will produce an  error. 
Background image of page 3

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

View Full DocumentRight Arrow Icon
Sum Function Let's use the table here for the discussion that follows:  We will look at several different specific examples that  show how the sum function can be used! Notice that in A4 there is a TEXT entry. This has NO  numeric value and can not be included in a total.
Background image of page 4
Sum Function
Background image of page 5

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

View Full DocumentRight Arrow Icon
Product Function Multiplies all the numbers given as arguments  and returns the product. Syntax =PRODUCT ( number1 ,number2,. ..) Remarks Only arguments that are numbers or logical values are  acceptable. Text arguments that cannot be translated  into numbers cause errors. 
Background image of page 6
Product Function =PRODUCT(A1:A3) Multiplies the numbers in the cells A1  through A3 (93750) =PRODUCT(A1:A3, 2)Multiplies the  numbers above and 2 (187500)
Background image of page 7

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

View Full DocumentRight Arrow Icon
IF Function The IF function will check the logical condition  of a statement and return one value if true and a  different value if false. The syntax is:
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/17/2011 for the course BUSINESS 198:170 taught by Professor Staff during the Spring '09 term at Rutgers.

Page1 / 35

Lecture+21+-+Excel+3 - CS170Lecture21 Spreadsheetspart3...

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

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