4.1 Functions and the Formulas Tab in Excel 2016
These are the following functions categories in Excel 2016 as they appear on the Formulas tab Ribbon from left-to-right:
- Date & Time
- Lookup & Reference
- Math & Trig
- More Functions:
If you select the Formulas tab, you will see something similar to the graphic below. For example, if you are desiring a function that involves manipulating text data in your worksheet, you would probably want to investigate the “Text” category, which we see in the graphic below. By selecting the “Text” icon on the Ribbon, we see a drop-down menu with a list of the various functions that are related to text usage in your worksheet. Let’s imagine we are interested in the “LEFT” function.
By selecting it from the menu, we can further gain additional information on its usage.
END OF SECTION 4.1