Lesson 7 - Lesson 7: Using functions Page 1 By the end of...

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

View Full Document Right Arrow Icon
Page 1 By the end of this lesson, learners should be able to: Understand definition of a function Use Excel 2003 functions in calculations Access Excel 2003 functions Find the sum of a range of data Page 2 Using Functions A function is a pre-defined formula that helps perform common mathematical functions. Functions save you the time of writing lengthy formulas. You could use an Excel function called Average , for example, to quickly find the average of range of numbers. Or you could use the Sum function to find the sum of a cell range. Excel 2003 contains many different functions. Each function has a specific order, called syntax , which must be strictly followed for the function to work correctly. Syntax Order: 1. All functions begin with the = sign. 2. After the = sign define the function name (e.g., Sum). 3. One or more arguments -numbers, text or cell references-enclosed by parentheses. If there is more than one argument, separate each by a comma. An example of a function with one argument that adds a range of cells, B3 through B10: An example of a function with more than one argument that calculates the average of numbers in a range of cells, B3 through B10, and C3 through C10: Excel literally has hundreds of different functions to assist with your calculations. Building formulas can be difficult and time-consuming. Excel's functions can save you a lot of time and headaches. Page 3
Background image of page 1

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

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

This note was uploaded on 07/12/2008 for the course CGS 2531 taught by Professor Desimone during the Spring '05 term at University of Florida.

Page1 / 7

Lesson 7 - Lesson 7: Using functions Page 1 By the end of...

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

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