Excel Date and Time Online Test

Please enter your email:

1. What is the syntax of Excel DATE function ?

(YEAR,month,day)

(start_date,months)

(date_text)

(end_date,start_date)

2. What is the syntax of Excel DAYS function ?

(start_date,end_date,[holidays])

(end_date,start_date)

(start_date,end_date,[weekend],[holidays])

(serial_number)

3. What is the syntax of Excel WORKDAY.INTL function ?

(time_text)

(serial_number,[return_type])

(start_date,end_date,[weekend],[holidays])

(start_date,days,[weekend],[holidays])

4. What is the syntax of Excel NOW function ?

()

(hour,minute,second)

(serial_number,[return_type])

(date)

5. What is the syntax of Excel EOMONTH function ?

(start_date,end_date,[method])

(start_date,months)

(serial_number)

(hour,minute,second)

6. What is the syntax of Excel DATAVALUE function ?

(start_date,end_date,[method])

(serial_number,[return_type])

(serial_number)

(date_text)

7. What is the syntax of Excel WEEKDAY function ?

(start_date,days,[holidays])

(serial_number,[return_type])

(time_text)

(start_date,end_date,[basis])

8. What is the syntax of Excel TIMEVALUE function ?

(serial_number)

(start_date,end_date,[weekend],[holidays])

(start_date,end_date,[basis])

(time_text)

9. What is the syntax of Excel EDATE function ?

(year,month,day)

(serial_number)

(start_date,months)

(serial_number,[return_type])

10. What is the syntax of Excel WEEKNUM function ?

(end_date,start_date)

(time_text)

(start_date,months)

(serial_number,[return_type])

ComExcelHub

Excel Date and Time Functions Online Exam

Bypavan75venky

Related Post

Excel Date and Time Functions Quiz-2

Excel VBA Quiz

EXCEL Lookup & reference functions practice test

You missed

How to use Excel LOWER Function

How to use Excel UPPER function

How to use Excel PROPER function

How to use Excel RIGHT function

ComExcelHub