Date Time Function Excel 17

Test your Excel skills with this 24-question quiz on Date & Time functions! Master from “Date Time Function Excel” Quiz MS Excel formulas like TODAY(), NOW(), TEXT(), NETWORKDAYS, EDATE, and more. Perfect for beginners and advanced users to practice Excel date calculations, formatting, and business-day logic. Let us start with the Date Time Function Excel Quiz now

Online MCQs about Date Time Function Excel with Answers

1. The worksheet contains the following data:

What will be the result of the following formula: =MONTH(G3)?

 04

 #VALUE!

 April

 4

2. Currently, cell R2 is formatted as text and holds the value 12. If we convert this to a short date format using the day/month/year system, what will be the result?

 12/01/1900

 12/01/2000

 Thursday, 12 January, 1900

 12

3. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.

What will the following formula return (after re-formatting the cell to ‘Date’): =EDATE(F3,1)?

 3/04/2020

 #VALUE!

 3/05/2020

 30/04/2020

4. The invoice date is the 3rd of January, 2020, i.e., 3/01/2020, which is held in cell D2. We want to work out how many working days there are between the invoice date and the end of the year, given that the country has a 3-day weekend of Saturday, Sunday, and Monday. What would be an appropriate formula from the list below?

 =WORKDAY.INTL(D2,”31/12/2020″,”1000011″)

 =NETWORKDAYS.INTL(D2,31/12/2020,1000011)

 =NETWORKDAYS.INTL(D2,”31/12/2020″,”1000011″)

 =NETWORKDAYS.INTL(D2,31/12/2020,”1000011″)

5. Assume that today is the 1st of January, 2020 and we are using the day/month/year format for dates. What will be the result of the formula: =TODAY()+7

 #VALUE!

 1/01/2027

 1/08/2020

 8/01/2020

6. The worksheet contains the following data

What will be an appropriate formula to convert this data into Wednesday, given that the 29th of December 1982 is a Wednesday?

 =TEXT(F3,DDDD)

 =TEXT(F3,DDDDDDDDD)

 =TEXT(F3,”DDDD”)

 =TEXT(F3,”DD”)

7. The worksheet contains the following data:

The following formulas are typed into the following cells:
• P2: =DAY(N2)
• Q2: =MONTH(N2)
• R2: =YEAR(N2)
What will the cells P2, Q2, and R2 hold, respectively?

 25 | October | 2020

 Sunday | October | 2020

 25 | 10 | 20

 25 | 10 | 2020

8. An invoice is due 10 working days after the invoice date. Which of the following would be an appropriate formula to get the due date, if the invoice date is 3/01/2020 and this value is held in cell D2?

 =WORKDAY(D2)+10

 =WORKDAY(D2,10)

 =DAY(D2)+10

 =NETWORKDAYS(D2,10)

9. What does the NOW() function do?

 It provides the time that the formula was first typed

 It provides the time that the spreadsheet was opened in the current instance

 It is a function that cannot be used by itself

 It provides the current time and displays this on the spreadsheet

10. The worksheet contains the following data:

What will be the result of the following formula: =TEXT(F3, “DDD/M/YYYY”)?

 Wed/1/1982

 Wed/12/1982

 Wednesday/1/1982

 Wednesday/12/1982

11. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.

What will be the result of the following formula (after re-formatting the cell to ‘Date’): =EDATE(F3,1)-1?

 2/05/2020

 2/04/2020

 3/04/2020

 3/05/2020

12. Assume that today is the 21st of January, 2020, and we are using the day/month/year format for dates. What will be the result of: =TODAY()-7

 21/01/2013

 31/01/2020

 14/01/2020

 #VALUE!

13. Cell N3 currently holds the value: 1/07/2019 (see below), the date that a payment was due (1st of July, 2019).

What would be an appropriate formula from the list below that returns the number of days overdue? (Note: you have to re-format the cell that contains the result to General)

 =TODAY(N3)

 =DAY(TODAY()-N3)

 =TODAY()-N3

 =N3-TODAY()

14. The worksheet contains the following data:

What will be the result of the following formula: =MONTH(1&G3)&”/2020″?

 April/2020

 4/2020

 1/04/2020

 1/April/2020

15. An invoice is due 10 working days after the invoice date. Which of the following would be an appropriate formula to get the due date, if the invoice date is 3/01/2020 and this value is held in cell D2, and given that the country has a 3-day weekend of Saturday, Sunday, and Monday?

 =WORKDAY(D2,10,”1000011″)

 =WORKDAY.INTL(D2,10,”1000011″)

 =WORKDAY(D2,10,3)

 =WORKDAY.INTL(D2,10,3)

16. The worksheet contains the following data:

What would be an appropriate formula from the list below to generate the last day of this month, given that the year is 2020?

 =DATE(2020,MONTH(1&B2)-1,1)-1

 =DATE(2020,MONTH(1&B2)-1,1)+1

 =DATE(2020,MONTH(1&B2)+1,1)-1

 =DATE(2020,MONTH(1&B2)+1,1)+1

17. The syntax for NETWORKDAYS is NETWORKDAYS(start_date, end_date, [holidays]). If there are 3 public holidays held in cells H3, H4, and H5. Which of the following formulas would work when trying to work out the number of working days in 2020?

 =NETWORKDAYS(1/01/2020,31/12/2020,H3:H5)

 =NETWORKDAYS(“1/01/2020″,”31/12/2020”,H3:H5)

 =NETWORKDAYS(“1/01/2020″,”31/12/2020”,H3,H4,H5)

 =NETWORKDAYS(1/01/2020,31/12/2020,H3,H4,H5)

18. The worksheet contains the following data:

What would be an appropriate formula from the list below to generate the first day of this month, given that the year is 2020?

 =DATE(2020,MONTH(1&B2),1)

 =DATE(2020,MONTH(1&B2)&1)

 =DATE(2020,MONTH(B2),1)

 =DATE(2020&MONTH(1B2)&1)

19. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.

What does the following formula effectively generate =WORKDAY(EDATE(F3,1)-1,1)?

 The next working day after the end of the year

 The next working day after a year

 The next working day after a month

 The next working day after the end of the month

20. The worksheet contains the following data:

To generate the last day of this month, the following formula is used: =DATE(2020, MONTH(1&B2)+1,1)-1. Which option explains the roles of +1, 1, and -1 within the formula the best?

 The +1 takes the date forwards by a month, while ,1 makes it the first of the month ahead. Then the -1 takes it forwards by a day, which is the last day of the original month

 The +1 takes the date forwards by a month, while ,1 makes it the first of the month ahead. Then the -1 takes it back by a day, which is the last day of the original month

 The -1 takes the date backwards by a month, while ,1 makes it the first of the original ahead. Then the +1 takes it forward by a day, which is the last day of the original month

 The -1 takes the date backwards by a month, while ,1 makes it the first of the previous month. Then the +1 takes it forward by a day, which is the last day of the previous month

21. Of these three functions, which of these functions returns a number of days: DAYS, WORKDAY, NETWORKDAYS

 DAYS, NETWORKDAYS

 DAYS, WORKDAY, NETWORKDAYS

 DAYS, WORKDAY

 WORKDAY, NETWORKDAYS

22. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.

What is the result of the following formula (after re-formatting the cell to ‘Date’): =EOMONTH(EDATE(F3,1),1)?

 #VALUE!

 31/05/2020

 30/06/2020

 30/04/2020

23. The worksheet contains the following data:

What will be the result of the following formula:
=”On “&TEXT(F3,”ddd/m/yyyy”)&” due “&VALUE(RIGHT(C3,6))

 On Wed/12/1982due700.43

 On Wed/12/1982dueAUD700.43

 On Wed/12/1982 due 700.43

 On Wed/12/1982 due AUD700.43

24. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.

Which of the following is an appropriate formula to calculate the end date of this month?

 =EOMONTH(F3,1)

 =EOMONTH(F3,0)

 =EOMONTH(F3,31)

 =EOMONTH(F3)

 Loading …

Question 1 of 24

Online Date Time Function Excel Quiz

• The MS Excel worksheet contains the following data
  What will be an appropriate formula to convert this data into Wednesday, given that the 29th of December 1982 is a Wednesday?
• The MS Excel worksheet contains the following data:
  What will be the result of the following formula: =TEXT(F3, “DDD/M/YYYY”)?
• The MS Excel worksheet contains the following data:
  What will be the result of the following formula: =”On “&TEXT(F3,”ddd/m/yyyy”)&” due “&VALUE(RIGHT(C3,6))
• Currently, cell R2 is formatted as text and holds the value 12. If we convert this to a short date format using the day/month/year system, what will be the result?
• Assume that today is the 1st of January, 2020, and we are using the day/month/year format for dates.
  What will be the result of the formula: =TODAY()+7
• Assume that today is the 21st of January, 2020, and we are using the day/month/year format for dates.
  What will be the result of: =TODAY()-7
• What does the NOW() function do?
• The worksheet contains the following data:
  The following formulas are typed into the following cells:
  • P2: =DAY(N2)
  • Q2: =MONTH(N2)
  • R2: =YEAR(N2)
  What will the cells P2, Q2, and R2 hold, respectively?
• Cell N3 currently holds the value: 1/07/2019 (see below), the date that a payment was due (1st of July, 2019).
  What would be an appropriate formula from the list below that returns the number of days overdue? (Note: you have to re-format the cell that contains the result to General)
• The MS Excel worksheet contains the following data:
  What will be the result of the following formula: =MONTH(G3)?
• The MS Excel worksheet contains the following data:
  What will be the result of the following formula: =MONTH(1&G3)&”/2020″?
• The worksheet contains the following data:
  What would be an appropriate formula from the list below to generate the first day of this month, given that the year is 2020?
• The MS Excel worksheet contains the following data:
  What would be an appropriate formula from the list below to generate the last day of this month, given that the year is 2020?
• The MS Excel worksheet contains the following data:
  To generate the last day of this month, the following formula is used: =DATE(2020, MONTH(1&B2)+1,1)-1.
  Which option explains the roles of +1, 1, and -1 within the formula the best?
• Of these three functions, which of these functions returns a number of days: DAYS, WORKDAY, NETWORKDAYS
• An invoice is due 10 working days after the invoice date.
  Which of the following would be an appropriate formula to get the due date, if the invoice date is 3/01/2020 and this value is held in cell D2?
• An invoice is due 10 working days after the invoice date.
  Which of the following would be an appropriate formula to get the due date, if the invoice date is 3/01/2020 and this value is held in cell D2, and given that the country has a 3-day weekend of Saturday, Sunday, and Monday?
• The invoice date is the 3rd of January, 2020, i.e., 3/01/2020, which is held in cell D2. We want to work out how many working days there are between the invoice date and the end of the year, given that the country has a 3-day weekend of Saturday, Sunday, and Monday. What would be an appropriate formula from the list below?
• The syntax for NETWORKDAYS is NETWORKDAYS(start_date, end_date, [holidays]). If there are 3 public holidays held in cells H3, H4, and H5.
  Which of the following formulas would work when trying to work out the number of working days in 2020?
• Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
  What will the following formula return (after re-formatting the cell to ‘Date’): =EDATE(F3,1)?
• Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
  Which of the following is an appropriate formula to calculate the end date of this month?
• Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
  What is the result of the following formula (after re-formatting the cell to ‘Date’): =EOMONTH(EDATE(F3,1),1)?
• Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
  What will be the result of the following formula (after re-formatting the cell to ‘Date’): =EDATE(F3,1)-1?
• Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
  What does the following formula effectively generate =WORKDAY(EDATE(F3,1)-1,1)?

Try Python MCQ Online Test 5