Functions are basically built-in formulas in Excel. They are used extensively in Excel, so it is very important to know how to use them.
The statistical functions.
it helps you to manipulate numerical data with formulas and built-in functions
The formulas tab brings together many of the common things used in working with formulas, like functions, names and auditing formulas.
Recommend the free on-line courses offered by Microsoft. You can learn everything from How to Enter Formulas to Creating Charts. See the related links for training for Excel 2003 and Excel 2007.
functions
There are thousands of formulas and more than a hundred functions used in Excel.
You could not really classify formulas into types as the amount of formulas are infinite and you can have a variety of things happening in a formula. Functions come in categories, and that is maybe what you mean. It will depend on which version of Excel you have, but these are the categories available in later versions: Cube functions Database functions Date and time functions Engineering functions Financial functions Information functions Logical functions Lookup and reference functions Math and trigonometry functions Statistical functions Text functions
Built-in formulas in Excel are known as functions. Here are five common ones: SUM AVERAGE COUNT MIN MAX
Excel is a Microsoft software designed to calculate formulas and is in a spreadsheet layout. Entourage is the Mac version of Microsoft Outlook.
Formulas and Functions.
Formulas.
348, at my count