Locked lesson.

## About this lesson

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

## Exercise files

Download this lesson’s related exercise files.

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

13.4 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.