Lecture19_Excel3

# Lecture19_Excel3 - Computer Applications for Business...

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

Computer Applications for Business Spring 2008 Instructor: Gayatree Ganu

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

View Full Document
Exam statistics Total = 100 Average = 73.15 Median = 75 Minimum = 6 Maximum = 103
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

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

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

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

View Full Document
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.
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.

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

View Full Document
Sum Function
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.

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

View Full Document
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)
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:

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 02/08/2011 for the course ECONOMICS 101 taught by Professor June during the Spring '08 term at Rutgers.

### 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
Ask a homework question - tutors are online