Excel Quiz 58
By eforexcel20180108T13:11:37+05:30Saturday, December 30th, 2017Categories: QuizzesTags: Exam, Quiz, Test, Tutorial0 Comments
Excel Quiz 58
Quizsummary
0 of 10 questions completed
Questions:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
Information
A quiz based on Excel functions and formulas
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
 Not categorized 0%
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 Answered
 Review

Question 1 of 10
1. Question
Which is a volatile function?
Correct
Incorrect

Question 2 of 10
2. Question
Correct
Incorrect

Question 3 of 10
3. Question
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
Correct
Incorrect

Question 4 of 10
4. Question
Which function can be used to calculate number of months to pay up a loan at constant rate?
Correct
Incorrect

Question 5 of 10
5. Question
If A2 has a number in Text format, then which formula can be used to convert this text number into number format?
Correct
Incorrect

Question 6 of 10
6. Question
What will be the result of this formula?
=FIND("c?o","microsoft excel")
Correct
Incorrect

Question 7 of 10
7. Question
What will be the result of this formula?
=CEILING(1233,1000)
Correct
Incorrect

Question 8 of 10
8. Question
What will be the result of following formula?
=CHOOSE(3*2,"Mon","Tue","Wed","Thu","Fri","Sat","Sun")
Correct
Incorrect

Question 9 of 10
9. Question
If A2 has a date, then following formula can be used to find a date after 3 months
Correct
Incorrect

Question 10 of 10
10. Question
What is the result of following formula
=TEXT(12345678,"0.0,,")
Correct
Incorrect