All formulas in Excel must begin with an equals sign (=).
This is the case because both the formula and the value it calculates are present in or equal to the cell.
What are the main functions of ms excel?
An Excel function is a pre-written formula that facilitates the completion of mathematical, statistical, and logical tasks. When you are comfortable using a function, all you need to do is enter an equal sign (=) in the cell, the function's name, and the cell range it applies to.
- IF function; Using Excel's IF function, two values are logically compared. Either TRUE or FALSE is the outcome of the IF function. For instance, we can determine whether cell B2's value exceeds cell A2's value. If so, the outcome is TRUE; otherwise, it is FALSE.
- Text Functions: If you work with data that contains text, the functions listed below will help you work more effectively.
- VLOOKUP function; Vertical Lookup is referred to as VLOOKUP. It is a function that instructs Excel to look in a column (the so-called "table array") for a specific value in order to retrieve a value from another column in the same row. You will learn how to use the VLOOKUP function from this tutorial.
- Date functions: One of the main components of data that you use every day is dates, which you may utilize to better evaluate your data.
- MATCH function; The relative location of a value is returned by the MATCH function after searching for it in a range of lineair cells.
- Time Functions: Time can appear in data just like dates do, and you can use time functions to work with data that contains time values.
- Logical Functions: You can use logical functions to build some of your spreadsheet's most useful formulas.
- Statistical Functions: One of Excel's best features is the abundance of statistical functions available for quick data analysis.
- Information Function: You can use these particular functions to learn more about the values you provided.
- Financial Functions: You may easily perform some of the common yet crucial financial calculations with these functions.
To learn more about Function of ms excel, refer to:
https://brainly.com/question/20893557
#SPJ9
