Excel Quiz 58
By eforexcel|2019-10-04T12:28:56+05:30Friday, August 30th, 2019|Categories: Quizzes|Tags: Exam, Quiz, Test, Tutorial|0 Comments
Excel Quiz 58
Quiz-summary
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