Excel Quiz 59  Date & Time Quiz
By eforexcel20191221T19:28:52+05:30Thursday, October 31st, 2019Categories: QuizzesTags: Date, Exam, Quiz, Test, time, Tutorial0 Comments
Quizsummary
0 of 10 questions completed
Questions:
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
Information
A general quiz on Excel
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 formula will you use to find the last date of a month given a date in A2? For example if A2 has a date 10Oct19, then answers should be 31Oct19.
Correct
Incorrect

Question 2 of 10
2. Question
Which formula will you use to extract HOUR from a time given in A2? Hence, if A2 is having 10:15, the answer should be 10.
Correct
Incorrect

Question 3 of 10
3. Question
What is the shortcut to insert date in a cell?
Correct
Incorrect

Question 4 of 10
4. Question
If cell A2 has a year say 2020, what would be the formula to give TRUE or FALSE to test whether year is Leap or not. Hence for 2020, it should give TRUE. For 2000 = TRUE, 2100 = FALSE, 2020 = TRUE, 2021 = FALSE
Correct
Incorrect

Question 5 of 10
5. Question
What is the formula to get date from a date field which has both date and time? For example, A2 has 8/25/19 10:35 PM and answer should be 8/25/19.
Correct
Incorrect

Question 6 of 10
6. Question
Which function do you use to get current date and time?
Correct
Incorrect

Question 7 of 10
7. Question
How do you calculate number of days between two dates? Suppose A1 has start date of 7/25/19 and A2 has end date of 8/31/19. Which formula would be used?
Correct
Incorrect

Question 8 of 10
8. Question
The shortcut to enter current time in a cell is
Correct
Incorrect

Question 9 of 10
9. Question
Which function do you use add months to a given date? Say A2 has 2/13/19 and you need to add 5 months in this.
Correct
Incorrect

Question 10 of 10
10. Question
Which function returns the number of whole workdays between two dates?
Correct
Incorrect