Lecture19_Excel3

Lecture19_Excel3 - Computer Applications for Business...

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

View Full Document Right Arrow Icon
Computer Applications for Business Spring 2008 Instructor: Gayatree Ganu
Background image of page 1

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

View Full DocumentRight Arrow Icon
Exam statistics Total = 100 Average = 73.15 Median = 75 Minimum = 6 Maximum = 103
Background image of page 2
Excel Exam Dates postponed: Exam will be in the week of April 28 th during your recitation Talk to me right after class if you have a conflict
Background image of page 3

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

View Full DocumentRight Arrow Icon
Software Extra Credit 10 points Due on May 5 th No late period Your own work, no support fromTAs
Background image of page 4
Topics List: Spreadsheets Lecture 2 Excel Functions Sum Product If Count Counta Countif Round Trunc Median Average Min Max Today PMT LOOKUP
Background image of page 5

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

View Full DocumentRight Arrow Icon
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 6
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 typical 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 7

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

View Full DocumentRight Arrow Icon
Sum Function
Background image of page 8
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 9

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

View Full DocumentRight Arrow Icon
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 10
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 11

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

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

Page1 / 31

Lecture19_Excel3 - Computer Applications for Business...

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

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