Microsoft Excel

Use of Statistics and Data Analysis in Microsoft Excel, use of Excel Built-in Statistical Functions, Analysis ToolPak, and creating Sheets for different statistical Analyses and Tests.

Date Time Function Excel 17

by

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:
Date Time Functions Excel Q1


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

 
 
 
 

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


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

 
 
 
 

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


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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

7. What does the NOW() function do?

 
 
 
 

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. The worksheet contains the following data:
Date Time Excel Q5


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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

23. 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))

 
 
 
 

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

 
 
 
 

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

Excel Power Query Questions 16

by

Think you know Excel Power Query Questions? Take this interactive MCQ quiz (about MS Excel Power Query Questions) to test your knowledge on data source in Power Query, Power Query Editor, merging queries, joins (inner, outer, anti), M language, data transformation, and more! Perfect for Excel users, Power BI analysts, and data professionals looking to master ETL (Extract, Transform, Load) techniques. Let us start with the MS Excel Power Query Questions Quiz now.

Online MS Excel Power Query Questions with Answers
Please go to Excel Power Query Questions 16 to view the test

Online Excel Power Query Questions Quiz

  • A Merge Query performs a similar functionality to some Excel functions. Which functions are they?
  • For a Merge Query to work, we do not need the column headings to match; however, we do need the values of one column in one query to relate to the values of a column in the other query.
  • Suppose that we have two queries containing two employment data sets. Each data set has the historical employee details of two subsidiary companies of the same parent organisation. What type of join is required to find out the employees who have worked in both organisations?
  • What could you do if you needed to merge three queries?
  • If you have a query that displays the output from a Right Anti Join, the last few characters of the M code in the formula bar will read JoinKind.RightAnti. What will happen if we edit the text in the formula bar to replace JoinKind.RightAnti with JoinKind.RightOuter and press Enter?
  • What is Power Query primarily used for?
  • In which Microsoft applications can Power Query be used?
  • Which Power Query feature allows combining data from multiple sources?
  • What is the M language in Power Query?
  • How do you refresh data in Power Query?
  • What does “Unpivot Columns” do in Power Query?
  • Which of the following is NOT a data source in Power Query?
  • What is a “Query Step” in Power Query?
  • How can you remove duplicates in Power Query?
  • Where does Power Query store its transformation steps?
  • What does the “Group By” feature in Power Query allow you to do?
  • Which Power Query operation would you use to split a single column into multiple columns?
  • What is the purpose of the “Parameters” feature in Power Query?
  • How can you handle errors (e.g., division by zero) in Power Query?
  • What happens when you disable “Load” for a query in Power Query Editor?

Learn about the R Programming Language

Conditional Formatting Excel Quiz 15

by

Test your MS Excel skills with this 20-question Trend-Based Conditional Formatting Excel Quiz! Learn how to highlight data trends, use icon sets, color scales, and sparklines, and master custom formatting rules. Ideal for Excel users who want to visualize patterns, analyze data efficiently, and automate formatting tasks. Can you answer all questions correctly? Take the Conditional Formatting Excel Quiz now and level up your spreadsheet expertise! Let us start with the Trend-Based Conditional Formatting Excel Quiz now.

Online Trend Based Conditional Formatting Excel Quiz with Answers
Please go to Conditional Formatting Excel Quiz 15 to view the test

Trend Based Conditional Formatting Excel Quiz

  • Conditional formatting allows you to automatically apply formatting to one or more cells based on the cell value. This means that conditional formatting can automatically change the cell colour, font, border, or even show a different number of decimal places.
  • What does trend-based formatting do?
  • When applying Icon Sets, the original values still appear in the cell.
  • Which of the following methods allows us to remove conditional formatting (more than one may apply)?
  • Which would be the appropriate Conditional Formatting set if you wanted to highlight all values over 300?
  • Conditional formatting can be used to highlight duplicate values.
  • Conditional formatting by using a formula is advantageous over other conditional formatting because:
  • Excel allows us to record macros to automate difficult or repetitive procedures. Which of the following is true of recording macros?
  • What is the key difference between a sparkline and a chart in Excel?
  • Sparklines are a useful data visualisation tool for which of the following cases (more than one may apply):
  • After creating a sparkline, we can drag the fill handle to create multiple sparklines.
  • If you use the fill handle to create multiple sparklines, the sparklines will form a set of connected charts, meaning if you change one, you change all of them. It is possible to unlink sparklines if you do not wish them to behave this way.
  • Custom number formats can be accessed in which of the following ways:
  • When customising a number format:
  • When customising a number format, which character acts as the separator for specifying different formats for different types of values?
  • What type of brackets should we use when specifying colours for our custom number formats?
  • If a cell contains the value 0, what will be displayed when we apply the following custom number format: [Red]â–²;[Green]â–¼;
  • What is the primary purpose of trend-based conditional formatting in Excel?
  • Which conditional formatting option is specifically designed to show trends?
  • When using color scales for trend analysis, what does a red-yellow-green color scale typically represent?

Statistics For Data Analyst