EXCEL
BuiltIn Formulas and Functions
Excel has a variety of builtin functions that can be accessed using the Formula Wizard, click the link for instructions on how to use the Formula
Wizard.
If the function you want is not
shown when you click the dropdown arrow on the function list you can click the More
functions option at the bottom to display a window giving you access to all
Excel’s builtin functions as shown below.
You can either choose All
from the list on the left to show all the builtin functions on the right
(scroll down to find the one you want) or you can choose a category that may
contain the function and look for it in there.
When you have chosen a function and click OK the function wizard
will proceed to help you complete the arguments.
Builtin functions can be categorised as follows:
Function

Action

Mathematical/Trigonometric

Take a number as data,
transform it, and produce a numerical result. For example, sine
and absolute value are math functions.

Logical

Consider a condition and
return True or False

Text

Manipulate or create strings

Date/Time

Perform calculations on
dates, times, and combinations of dates and times

Statistical

Return statistical values to
sets of numbers. For example, average, count, min, max, etc.

Database

Same as statistical, however
datasets are taken from a database

Financial

Helpful when calculating
such things as interest, monthly payments, and assist in whatif
scenarios

Information

Used to get information
about the contents of a cell

Lookup/Reference

Manipulate or examine areas
of a worksheet

Click here to
return to the Excel index.
webmaster@allaboutoffice.co.uk 