Date and Time function

What is the function can returns the number of days between two dates?

• DAYS function

• DATEDIF function

• DATAVALUE function

• DAYS and DATEDIF function

Choose the answer that BEST explains the purpose of

the NETWORKDAYS function?

• This function calculates the number of working weeks between two weeks and its also automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.

• This function calculates the number of working days between two dates and its also automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays supplied as dates.

• This function calculates the number of working days between two dates and its also automatically excludes weekends (Saturday and Sunday).

• This function calculates the number of working days between two dates and its also automatically excludes weekends (Saturday and Sunday) and can optionally exclude a list of holidays.

What is the TRUE syntax of the NETWORKDAYS function?

• NETWORKDAYS(start_date, end_date, holidays)

• NETWORKDAYS(start_date, end_date, (holidays))

• =NETWORKDAYS(start_date, end_date, [holidays])

• All answers are wrong

Which of the following is a syntax error?

• =DATEVALUES(date_text)

• =DATEDIF(start_date, end_date, unit)

• =MONTH(serial_number)

• =DAY(date)

By default, WEEKDAY returns 1 for X and 7 for Y?

And X,Y stand for?

• Monday/Sunday

• Sunday/Saturday

• Saturday/Friday

• All answers are right

"The Excel HOUR function returns the hour component of a time as a number between 0-24". This sentence is TRUE or FALSE?

• TRUE

• FALSE

What are the general characteristics of the HOUR, MINUTE, or SECOND functions?

• Returns the time units HOUR, MINUTE or SECOND as requested

• Returns the time units HOUR as requested

• Returns the time units MINUTE as requested

• Returns the time units SECOND as requested

Which of the following is the correct answer?

• The Excel WEEKNUM function takes a date and returns a week number (1-4) that corresponds to the week of month.

• The Excel WEEKNUM function takes a date and returns a week number (1-12) that corresponds to the week of quarter.

• The Excel WEEKNUM function takes a date and returns a week number (1-54) that corresponds to the week of year.

• All answers are wrong

If you wanted to return the current date, which is constantly updated when the sheet is changed or opened, which function would you use?

• DATE

• TODAY function

• DAYS function

• NOW function

Which of the following is a syntax error?

• =MINUTE(serial_number)

• =TIMEVALUE(time_number)

• =HOUR(serial_number)

• =TIME(hour, minute, second)