Using the Function Library in Microsoft Excel 2019

The Excel functions are continuously being updated and improved inthe Function Library group on theFormulas tab. Each book along theribbon houses functions in categories, which makes it much easier forthe user to locate functions and understand the purpose of using them.We will be looking at some functions from the various books available inthe Function Library group. The firstexample we will use is the COUNTAfunction, which can easily be typed into the cell directly, but we willtake the long-method route for the purpose of demonstrating the processof using the Function Library. TheFunction Library group can be seen inthe following screenshot:

ms office 149
  1. Open the SSGRegions.xlsx workbook. 
  2. Click on the cell in which to apply a function—in the case of thisexample, we will use cell B30 to work out the count of theemployees. From the Function Library,select the function book you desire. We are using a statisticalfunction, so will need to visit the Statistical book under the More Functions drop-down list.
  3. Once you click on the MoreFunctions book, choose the Statistical category, after which adrop-down list will appear with all the available functions from thatcategory, as illustrated in the following screenshot:

ms office 163

  1. If you click on the COUNTAfunction to select it, Excel will automatically place an = sign into the cell at the start of theformula, and then insert the function directly after the equals (=) sign.
  2. The Function Arguments dialog boxwill appear, where the user is able to enter values as cell referencesto construct the formula. Excel automatically assumes the range to use,which you need to remove as you would like to select your own range ofcells from the worksheet. Select range A8:A11 for Value1 and A20:A24 for Value2, as illustrated in thefollowing screenshot:

ms office 263

  1. Notice that the formula description is displayed at the bottom ofthe Function Arguments dialog box aswell as the result of the formula.
  2. Click on OK when complete to viewthe result.

Leave a Comment