What is Function Library in Excel

Home > Articles > Home & Office Computing > Microsoft ApplicationsTo make it easier to find the function you need for a specific use, Excel has organized functions int

What is Function Library in Excel

Home > Articles > Home & Office Computing > Microsoft Applications

To make it easier to find the function you need for a specific use, Excel has organized functions into categoriessuch as Financial, Logical, Text, Date & Time, Lookup & Reference, Math & Trig, and other functionson the Formulas tab. Functionssuch as beta and chi-squared distributionsfor the academic, engineering, and scientific community have been improved for more accuracy and includes new ones in all categories (New!) and web services (New!). Some statistical functions have been renamed for consistency with the real world. 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

yellow-01.jpg

Click the cell where you want to enter the function.

yellow-02.jpg

Click the Formulas tab.

yellow-03.jpg

Type = (an equal sign).

yellow-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.

yellow-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.

yellow-06.jpg

Click OK.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Video liên quan