Advertisements
Advertisements
प्रश्न
How is a Formula different from a Function in Excel?
फरक स्पष्ट करा
Advertisements
उत्तर
| Formula | Function | |
| 1. | The formula is like an equation in Excel which the user types. It can be any type of calculation depending on the user’s choice. | A function in Excel is a predefined calculation which is in-built in Excel. |
| 2. | Manually typing out a formula every time a calculation needs to be performed is time consuming, Eg. = A1 + A2 + A3 | Performing calculations are more comfortable and faster while working with functions. Eg. =SUM(A1 : A3) |
shaalaa.com
Concept of Electronic Spreadsheet (ES)
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
