How to Use Specialized Functions-MS Excel 2007…..!!!!!

0

How to Use Specialized Functions-MS Excel 2007

Method-1: Insert Functions and Function Arguments Manually

To insert functions and function arguments in a worksheet manually:

            1.       Select the cell into which the formula will be placed.

            2.       Type the function and its arguments in the formula bar or directly in the selected cell.

            3.       Press Enter.

Method-2: Insert a Function with Function Entry Dialog Boxes

To insert a function with the Insert Function and Function Arguments dialog boxes:

            1.       Insert the function and open the Function Arguments dialog box.

  • Type the = sign in the formula bar or directly in the selected cell, followed by the name of the function and an open parenthesis, and then click the Insert Function button on the formula bar or in the Function Library group on the Formula tab.
  • Click the drop-down list for the function category in the Function Library group, and select the function from the list.
  • Or, insert the function with the Insert Function button on the formula bar or in the Function Library group.
  • In the Select a Function list box, either double-click the appropriate function, or select it and then click OK.

            2.       In the Function Arguments dialog box for the inserted function, enter the function arguments and then click OK.

……………………………..Thanks everyone

Share.

About Author

Avatar

Leave A Reply

CAPTCHA ImageChange Image