Excel Date and Time Functions Quiz-2

Free Excel Quiz to Test your knowledge

This quiz will improve your Knowledge in Excel Date and Time Functions

Please enter your email:

1. How to get the 01-Jan-2021 using EOMONTH function if the start date is 25-Dec-2020?

 
 
 
 

2. Select any one function, which helps us to calculate the number of working days between 2 dates with Friday and Saturday as week-offs.

 
 
 
 

3. Select the correct formula using below start date to get the result using EDATE Function.

Start Date:01-Dec-2020

Result: 06-Dec-2021

 
 
 
 

4. Select the correct Function to get Minute of the time.

Time: 01:29:35 PM

Result: 29

 
 
 
 

5. Select the correct Function to get Hour of the time.

Time: 01:29:35 PM

Result:13

 
 
 
 

6. Select the correct Function to get second of the time.

Time: 01:29:35 PM

Result: 35

 
 
 
 

7. Select the correct Function using below HOUR, MINUTE, SECOND get the proper time.

Hour: 13

Minute: 29

Second: 35

Result Time: 01:29:35 PM

 
 
 
 

8. Select the correct Function using below Year, Month, Day to create a proper date.

Year: 2020

Month: 8

Day: 15

Result Date: 15-08-2020

 
 
 
 

9. Select the correct Function to get only the day of the date.

Date: 15-08-2020

Result: 15

 
 
 
 

10. Select the correct Function to get the only Month of the date.

Date: 15-08-2020

Result: 8

 
 
 
 

11. Select the correct Function to get the only year of the date.

Date 15-08-2020

Result: 2020

 
 
 
 

Contact to us