What is a function?

Functions can be described as Excel's pre-made formulas. They can perform specific operations and calculations that return a value to the cell they are enter in.

Functions require input in order to perform a calculation this input is called the argument of a function.

 

using ranges as arguments

Reference operators

There are two types of reference operators range and union.

A range reference specified all the cells between and including a cell reference.

unions are town or more addresses separated by a comma

combining range and union references in an equation. (excellent way to skip cells).

• Using quick sum
• Inserting a function
• Typing a function directly into a cell
• "Paste Function" dialogue window

Formula tips

In excel there are two types of input essential and nonessential. Essential input is highlighted in bold this is required data that must be entered into the function for it to operate. Non essential input that does not have to be entered is in regular style text.