Topic 19: Do You Really Know the Excel 2007 Function?

[seema]

Excel 2007 Functions are build-in, special commands that incorporated into the formulas to perform mathematical calculations. It can be used to make complex operations simple. Excel 2007 contains a build-in list of worksheet functions, which are categorised to make it easy to search for the ones you need.

Excel has over 300 built-in functions divided into various function categories, including:

Financial Logical Text Date & Time Lookup & Reference Math & Trigonometry Information Database Statistical Engineering CubeHere are some commonly used functions: AVERAGE: Used to determine the average value of the selected cells contents. COLUMNS: Used to return the number of columns within a reference. COUNT: Used to count how many numbers are in the list. MAX: Used to return the maximum number from a list. MIN: Used to return the minimum number from a list. ROUND: Used to round off numbers to a specified number of decimal points. SUM: Used to add the contents of selected cells.

Similar Threads:

• Topic 17: Formatting the Excel 2007 Table As You Needs!
• Topic 16: How to Insert a Table in Excel 2007?
• Topic 10: Getting Help with Excel 2007 Help Feature
• Topic 3: Is There Something New About Excel 2007 Ribbon?
• Topic 1: Microsoft Excel 2007 - Getting Started!

[seema]

To display all the available functions

Open a blank Excel workbook Click on the Formulas tab and within the Function Library group click on the Insert Function icon. From the Insert Function dialog box displayed, under Or select a category: section, select a particular category function, the related functions will displayed.

[seema]

To enter functions directly into the worksheet cell

Select the cell into which the formula will be entered. Insert an equal (=) sign to begin the formula. The formula toolbar ****ons will appear. Enter the name of the function [e.g. SUM], followed by an opening parenthesis [(], any arguments required for the function [e.g. E2:E5], and closing parenthesis[)]. Press Enter. If there are no errors in the formula, the result of the function will be entered in the cell. If you activate the cell again, the function will be displayed in the formula bar.