Microsoft Office Tutorials and References
In Depth Information
Entering Functions Using the Insert Function Dialog Box
Table 2-1
Function Categories in the Insert Function Dialog Box
Category
Type of Functions
Most Recently Used
The last several functions you used
All
The entire function list, sorted alphabetically
Financial
Functions for managing loans, analyzing investments, and
so forth
Date & Time
Functions for calculating days of the week, elapsed time,
and so forth
Math & Trig
A considerable number of mathematical functions
Statistical
Functions for using descriptive and inferential statistics
Lookup & Reference
Functions for obtaining facts about and data on worksheets
Database
Functions for selecting data in structured rows and columns
Text
Functions for manipulating and searching text values
Logical
Boolean functions (AND, OR, and so forth)
Information
Functions for getting facts about worksheet cells and the
data therein
User Defined
Any available custom functions created in VBA code or
from add-ins; this category may not be listed
Engineering
Engineering and some conversion functions. These
functions are also provided in the Analysis ToolPak
Cube
Functions used with online analytical processing (OLAP)
cubes
Compatibility
Some functions have been updated in Excel 2010 and Excel
2013. The functions in this category are the older versions
that remain compatible with older versions of Excel.
Web
A few functions that are useful when sharing data with
web services
Entering Functions Using the
Insert Function Dialog Box
Now that you’ve seen how to search for or select a function, it’s time to use
the Insert Function dialog box to actually insert a function. The dialog box
makes it easy to enter functions that take no arguments and functions that do
take arguments. Either way, the dialog box guides you through the process of
entering the function.
Search JabSto ::




Custom Search