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

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

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

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