A function in Microsoft Office Excel is a predefined formula that performs calculations using specific values in a particular order. One of the key benefits of functions is that they can save you time since you do not have to write the formula yourself. Excel has hundreds of different functions to assist with your calculations.
NOTE: Version markers indicate the version of Excel a function was introduced. These functions aren’t available in earlier versions.
IMPORTANT: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture. Learn more about the differences.
Cube: Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization’s performance.
Add-in and Automation: Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation).
Text: Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
This function isn’t available in Excel 2016 for Mac.
http://kamiltech.com/wp-content/uploads/2016/08/office.png5071000Kayyum Patelhttp://kamiltech.com/wp-content/uploads/2015/11/logo2-300x88.pngKayyum Patel2016-10-13 11:59:182016-10-13 11:59:18Complete List of Office Excel Functions