Top 10 Excel Formulas Interview Questions & Answers (2022)

[soybean]

7) MAX Formula: =Max(D27)

This excel formula will retain the cells that have the highest value in the column, for example, here we want to know the highest value for computer items, and it retains the value $12000. Likewise, you can execute same formula to get a minimum value, in the formula you have to replace Max with Min.

 

[soybean]

Below, screen shot shows the highest value in the column.

MAX Formula

 

[soybean]

8) Factorial Formula= FACT(number)


Factorial formula will return the factorial of the number. To know the factorial number for 3, we use this formula. You can use this formula to know the probability for any number, here we will have factor 3=3x2x1.

Factorial Formula

 

[soybean]

9) VLookup Formula = Vlookup(value, range, and get me value in the column, is my list sorted)

VLookup formula is used when you know anyone detail of any object or person and, you retain other formation based on that detail. For example here we have an example of the keyboard, where you know the retail price of the keyboard but you don’t know how much total sale it made in California by selling keyboard. To know that you will use =Vlookup(20,D27,2,False). This formula will give you the total sale amount based on the retail price. While applying this formula you have ensure that whatever you are placing as ref, must be unique, for example you are looking for any particular employee with its ID number it should not be allotted to others otherwise it will show an error.

 

[soybean]

When formula is executed, the total sale amount shown is $2500

VLookup Formula

 

[soybean]

10) IF function formula: IF (E2>2000, correct/Incorrect)


Here we have used IF function; this function is used when you want to refer whether the following condition met is correct or incorrect. Here we have used “good” as any sales made greater than 2000 should be remarked as good. Likewise, you can set this as “bad”, “correct” or “incorrect”.

 

[soybean]

Below table shows when we applied our formula it highlighted cell as “good”.

IF function formula

Free PDF Download: Excel Formulas Interview Questions & Answers​