GCFLearnFree.org

Your videos are excellent: short, sweet, and to the point.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2007
  • Working with Basic Functions

Excel 2007

Single page view print copy

Working with Basic Functions

Basic functions

Watch the video! (11:34 min)

Download the example to work along with the video.

The parts of a function:

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. Then there will be an argument. An argument is the cell range or cell references that are 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, A3 through A9:

Function With One Argument

An example of a function with more than one argument that calculates the sum of two cell ranges:

Function With Two Arguments

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.

previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.