Page 113 - Ms Excel Note and Workbook
P. 113
MICROSOFT EXCEL NOTE AND WORKBOOK
The Function Library
While there are hundreds of functions in Excel, the ones you'll use the most will depend on the type
of data your workbooks contain. There's no need to learn every single function, but exploring some
of the different types of functions will help you as you create new projects.
To access the Function Library, select the Formulas tab on the Ribbon. Look for the Function
Library group.
Click the buttons in the interactive below to learn more about the different types of functions in
Excel.
TIP
You can even use the
Function Library on the
Formulas tab to browse
functions by category, such
as Financial, Logical, Text,
and Date & Time.
To insert a function from the Function Library:
In the example below, we'll use the COUNTA function to count the total number of items in
the Items column. Unlike COUNT, COUNTA can be used to tally cells that contain data of any kind,
not just numerical data.
1. Select the cell that will contain the function. In our example, we'll select cell B17.
104 | P a g e
