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.
There are thousands of formulas and more than a hundred functions used in Excel.
functions
Excel is a Microsoft software designed to calculate formulas and is in a spreadsheet layout. Entourage is the Mac version of Microsoft Outlook.
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
Formulas.
Built-in formulas in Excel are known as functions. Here are five common ones: SUM AVERAGE COUNT MIN MAX
348, at my count
MS stands for Microsoft so ms word and ms excel are Microsoft Word and Microsoft Excel respectively. We can create documents in windows operating system with usually MS Word used to create word documents and MS excel for creating spreadsheet for calculation etc.