Functions and its Types
Formulas or functions are very important in Excel when we want to do some calculations like - adding some cells in a column, multiplying one number by another, averaging the data of a range, etc., then we can formulas for that calculation. Let's use a formula that is filled in the cell where we want to show the result of the calculation. Formulas in MS Excel always start with an equal sign (=).
Excel has pre-defined formulas called functions that can perform various types of functions such as addition, occurrence, multiplication, division, date, time, etc. These types are. Which is as follows.
- Math or String
- Date & Time
- Text
- Financial
- Logical
- Statically
- Lookup or reference
Use of Function
By Direct Type: - In this, type the function after the sign of "=" and insert the Argument into it. And finally you can get the result by clicking inter or clicking on it.
Through the menu : - Clicking on the Insert menu → Function, the function dialog box appears. In which the function is selected. And click on ok button. And then give his arguments in it and click on the ok button.
ConversionConversion EmoticonEmoticon