Which is a volatile function?

What will be the answer for following formula =VLOOKUP(105,A:C,4,0)

Which of the following formulas can be used to extract last name from a cell if a cell contains First Name Last Name like

A2 = John Doe

hence answer should be Doe

Which function can be used to calculate number of months to pay up a loan at constant rate?

If A2 has a number in Text format, then which formula can be used to convert this text number into number format?

What will be the result of this formula?

=FIND("c?o","microsoft excel")

What will be the result of this formula?

=CEILING(1233,1000)

What will be the result of following formula?

=CHOOSE(3*2,"Mon","Tue","Wed","Thu","Fri","Sat","Sun")

If A2 has a date, then following formula can be used to find a date after 3 months

What is the result of following formula

=TEXT(12345678,"0.0,,")

To extract the first two characters from a string, which function is preferred?

Which is not a function in Excel?

Which is not a menu tab in Excel?

What is not supported in Conditional Formatting?

What is not part of Font formatting in Excel?

The default font in Excel 2016 / 365 is (unless changed)

Which function would you use to add to or subtract months from a date?

Which menu tab is not part of default installation of Excel unless added explicitly?

Which is not a way to create a named range?

Power Pivot is available in which version of Excel 2016 / 365?

In which tab, Conditional Formatting is found apart from Home tab?

Which Excel command / tool to be used when you want to keep an eye on changing cells when you update your sheet?

SHIFT+F2 is shortcut for

Which is the best chart in case you want to show percentage distribution of various categories where sum is 100%?

What is the expansion of VBA?

What does SHIFT+Spacebar do?

What is the answer for following if A1: = Barack Hussein Obama

=REPLACE(A1,FIND(" ",A1),LEN(A1),"")

If A1: = 15-Jan-2016, then what would be the answer for
=TEXT(A1,"mmmmm")

Which error will you get if you try to enter following formula -
=VLOOKUUP(A1,L2:N1000,2,0)

What would be the answer for following -
=MROUND(1238,10)