Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Creating Functions Using the Library

To make it easier to find the function you need for a specific use, Excel has organized functions into categories—such as Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, and other functions—on the Formulas tab. Functions—such as beta and chi-squared distributions—for the academic, engineering, and scientific community have been improved for more accuracy (New!). Some statistical functions have been renamed for consistency with the real world (New!). If you want to use an older version of a function for backwards compatibility with those who do not have Excel 2010, you can use the old functions on the Compatibility menu (New!) by using the More Functions button. After you use a function, Excel places it on the recently used list. When you insert a function from the Function Library, Excel inserts the function in the formula bar and opens a Function Argument dialog box, where you can enter or select the cells you want to use in the function.

Enter a Function Using the Function Library

  • lightyellow_01.jpg Click the cell where you want to enter the function.
  • lightyellow_02.jpg Click the Formulas tab.
  • lightyellow_03.jpg Type = (an equal sign).
  • lightyellow_04.jpg Click the button (Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, More Functions, or Recently Used) from the Function Library with the type of function you want to use, click a submenu if necessary, and then click the function you want to insert into a formula.

    Excel inserts the function you selected into the formula bar with a set of parenthesis, and opens the Function Arguments dialog box.

  • lightyellow_05.jpg Type the argument or select the cell or range you want to insert in the function.

    You can click the Collapse Dialog button to the right of the text box, select the cell or range using your mouse, and then click the Expand Dialog button.

  • lightyellow_06.jpg Click OK.
  • + Share This
  • 🔖 Save To Your Account