What are the formulas and functions of ms excel?
Answer / Laxman Singh
Microsoft Excel is rich in various formulas and functions. Some important ones include:n- Arithmetic functions like SUM(), AVERAGE(), MIN(), MAX(), COUNT()n- Logical functions like IF(), AND(), OR(), NOT(), IFERROR()n- Lookup and reference functions like VLOOKUP(), HLOOKUP(), INDEX(), MATCH()n- Text functions like LEFT(), RIGHT(), MID(), LEN(), CONCAT()n- Financial functions like NETPresentValue(), IRR(), NPV(), PV(), XIRR()
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I change the default settings in excel 2016?
How do I change the automatic date formula in excel?
I am working in ms excel 5.0 in windows 95. I have a spreadsheet where the gridlines are not printing. The sheet is 87 rows by 49 columns, "a1 to aw87." Thegridlines are not printing from column "ap" to "aw." The other gridlines are printing correctly. What is the problem?
How do you expand a sort in excel?
How would you add comments to a cell?
Why is my left formula not working in excel?
How Can You Prevent Someone From Copying Your Worksheets?
How we can use vlookup in excel with example?
How do I add a design tool in excel?
How do you update data in excel?
What version of excel do I have?
What are the essential excel skills?