## About this lesson

Use to understand the anatomy of Excel functions, and what their components mean.

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Function Anatomy.xlsx13.1 KB Function Anatomy - Completed.xlsx

13.3 KB

## Quick reference

### Topic

Understanding Excel Function Anatomy

### Where/when to use the technique

Use to understand the anatomy of Excel functions, and what their components mean.

### Instructions

#### What is a Function?

- A pre-packaged algorithm which accepts parameters to return a result.

#### Key points to remember

- Functions must be used inside formulas.
- The function name is always followed by ( )
- The parameters for the current function show in Excel’s “Intellisense”.
- The current parameter is always listed in bold.
- Optional parameters are surrounded by [ ]
- Parameters not enclosed in [ ] are required.
- Ranges can be used as parameters.
- Other functions can be used as parameters.

Lesson notes are only available for subscribers.