0Function Categories
There are many categories of functions in Excel. Each category has specific functions that pertain to that category.
- Financial: Performs common business calculations including accounting and finance.
- Date & Time: Performs functions involving date or time data.
- Math & Trig: Performs simple to complex mathematical functions.
- Statistical: Performs statistical analysis on ranges of data.
- Lookup & Reference: Finds values in a corresponding table or list and incorporates the data into the calculation.
- Database: Performs a function only on data that meets a criterion.
- Text: Allows text to be manipulated within a calculation that also contains data.
- Logical: Performs what-if analysis to see if a condition is true or false.
