What are the formulas and functions of ms excel?



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

Post New Answer

More MS Excel Microsoft Interview Questions

How do I change the default settings in excel 2016?

1 Answers  


How do I change the automatic date formula in excel?

1 Answers  


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?

1 Answers  


How do you expand a sort in excel?

1 Answers  


How would you add comments to a cell?

1 Answers  


Why is my left formula not working in excel?

1 Answers  


How Can You Prevent Someone From Copying Your Worksheets?

1 Answers   Microsoft,


How we can use vlookup in excel with example?

1 Answers  


How do I add a design tool in excel?

1 Answers  


How do you update data in excel?

1 Answers  


What version of excel do I have?

1 Answers  


What are the essential excel skills?

1 Answers  


Categories