{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lecture 19 - Excel 3

# Lecture 19 - Excel 3 - Computer Applications for Business...

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

CS170 Computer Applications for Business Fall 2008 Instructor: Kristian Stout Lecture 19 Introduction to Spreadsheets Readings: Chapter 14

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

View Full Document
Topics List: Spreadsheets Lecture 3 Excel Functions Sum Product If Count Counta Countif Round Trunc Median Average Min Max Today PMT LOOKUP
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.

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

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

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

View Full Document
Product Function Multiplies all the numbers given as arguments and returns the product.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 27

Lecture 19 - Excel 3 - Computer Applications for Business...

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

View Full Document
Ask a homework question - tutors are online