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. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
Date Time Excel Q7


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

 
 
 
 

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


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)

 
 
 
 

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


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

 
 
 
 

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?

 
 
 
 

5. 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?

 
 
 
 

6. The worksheet contains the following data:
Date time function excel 2


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

 
 
 
 

7. The worksheet contains the following data:
Date Time Excel Q5


What will be the result of the following formula: =MONTH(1&G3)&”/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?

 
 
 
 

9. 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

 
 
 
 

10. The worksheet contains the following data:
Date time Excel Q6


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

 
 
 
 

11. 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. The worksheet contains the following data:
Date time Excel Q6


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

 
 
 
 

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

 
 
 
 

14. The worksheet contains the following data
Date Time Functions Excel Q1


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

 
 
 
 

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?

 
 
 
 

16. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
Date Time Excel Q7


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

 
 
 
 

17. The worksheet contains the following data:
Excel Date Time Q3


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?

 
 
 
 

18. Cell F3 holds the value: 3/04/2020, i.e., the 3rd of April, 2020.
Date Time Excel Q7


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

 
 
 
 

19. The worksheet contains the following data:
Date time Excel Q6


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?

 
 
 
 

20. The worksheet contains the following data:
Date Time Functions Excel Q1


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

 
 
 
 

21. What does the NOW() function do?

 
 
 
 

22. 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

 
 
 
 

23. The worksheet contains the following data:
Date Time Excel Q5


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

 
 
 
 

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


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

 
 
 
 

Question 1 of 24

Date Time Function Excel Quiz Q4

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

MCQs Permutations Combinations 14

Test your knowledge of permutations and combinations with this interactive quiz! The MCQs Permutations Combinations Quiz covers essential concepts like factorials, combinations, arrangements, and real-world applications. This quiz is perfect for students and enthusiasts looking to sharpen their probability and counting skills. Let us start with the MCQs Permutation Combinations Quiz now.

Learn about Counting Techniques in Probability

Online MCQs Permutations Combinations with Answers
Please go to MCQs Permutations Combinations 14 to view the test

Online MCQs Permutations Combinations

  • The number of ways to select 2 persons from 6, ignoring the order of selection, is
  • $n!=$?
  • An arrangement of all or some of a set of objects in a definite order is called
  • An arrangement of objects without caring for the order is called
  • ${}^nP_r$ =
  • ${}^nC_r$ =
  • In how many ways can a team of 6 players be chosen from 11 persons
  • How many terms are in the expansion of the $(q+p)^n$
  • ${}^{10}C_5=$
  • ${}^5C_5$ is equal to
  • The difference between permutation and combination lies in the fact that
  • Which of the following statements is true?
  • A homeowner doing some remodeling requires the services of both a plumbing contractor and an electrical contractor. If there are 15 plumbing contractors and 10 electrical contractors available in the area, in how many ways can the contractors be chosen?
  • How many permutations of size 3 can be constructed from the set (A, B, C, D, E)?
  • How many combinations of size 4 can be formed from a set of 6 distinct objects?
  • An experiment consists of three stages. There are five ways to accomplish the first stage, four ways to accomplish the second stage, and three ways to accomplish the third stage. The total number of ways to accomplish the experiment is
  • The $0!$ is
  • In how many ways can be letters in the word UNIVERSITY be arranged randomly
  • Seventeen teams can take part in the Football Championship of a country. In how many ways can the Gold, Silver, and Bronze medals be distributed among the teams?
  • The number of 3-digit telephone area codes that can be made if repetitions are not allowed is

See Recursion in R Language

Econometrics Quiz and Answers 8

Test your econometrics knowledge with this comprehensive Econometrics Quiz and Answers MCQs Test! Perfect for statisticians and econometricians preparing for exams or job interviews. Covers measurement errors, multicollinearity, heteroscedasticity, dummy variables, VIF, and more. Check your understanding of key concepts in Econometrics today! Let us start with the Online Econometrics Quiz and Answers now.

Online Econometrics Quiz and Answers
Please go to Econometrics Quiz and Answers 8 to view the test

Online Econometrics Quiz and Answers

  • If measurement errors are present only in the dependent variable, then the parameter estimates remain
  • If we have a categorical variable with 4 categories, then how many dummy variables can be used in with intercept regression model
  • In a regression model with 3 explanatory variables, there will be ————- auxiliary regressions
  • When measurement errors are present in the explanatory variable(s), then parameter estimates become
  • Which one is NOT the rule of thumb?
  • The variance of regression slopes becomes infinite in the  case of
  • If the calculated value of VIF is equal to 1321, then it is an indication of
  • In case of multicollinearity, the confidence interval tends to be much ———–, leading to the acceptance of the zero null hypothesis
  • A high value of VIF indicates
  • In case of perfect multicollinearity, the $X’X$ is a ————-.
  • The presence of heteroscedasticity does not destroy the —————- of OLS estimators.
  • In case of homoscedasticity, we have
  • Robust standard errors are those that are corrected by
  • If the calculated value of the condition number is equal to 1, then it is an indication of
  • If the correlation coefficient between two explanatory variables approaches 1, then
  • If there is no overlap between regressors, then
  • Which of the actions does not make sense to take to struggle against multicollinearity?
  • Spearman’s rank correlation test can be applied for
  • The Park test can be applied for
  • If the calculated value of VIF is equal to 1, then it is an indication of

Learn R Language through R Frequently Asked Questions