Lecture 19 - Excel 3

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

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

View Full Document Right Arrow Icon
CS170 Computer Applications for Business Fall 2008 Instructor: Kristian Stout Lecture 19 Introduction to Spreadsheets Readings: Chapter 14
Background image of page 1

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

View Full DocumentRight Arrow Icon
Topics List: Spreadsheets Lecture 3 Excel Functions Sum Product If Count Counta Countif Round Trunc Median Average Min Max Today PMT LOOKUP
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
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/07/2011 for the course COMP 178 taught by Professor Stout during the Fall '08 term at Rutgers.

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 Right Arrow Icon
Ask a homework question - tutors are online