Excel BI Analytics

Excel Quiz 51

Posted on by Vijay A. Verma

Quiz 51

This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly.

Please fill in your Name & Email to take the Quiz

(Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass)

1 / 10

The shortcut to enter current time in a cell is

2 / 10

Which formula will you use to find the last date of a month given a date in A2? For example if A2 has a date 10-Oct-19, then answers should be 31-Oct-19.

3 / 10

What is the formula to get date from a date field which has both date and time? For example, A2 has 8/25/19 10:35 PM and answer should be 8/25/19.

4 / 10

Which function do you use add months to a given date? Say A2 has 2/13/19 and you need to add 5 months in this.

5 / 10

How do you calculate number of days between two dates? Suppose A1 has start date of 7/25/19 and A2 has end date of 8/31/19. Which formula would be used?

6 / 10

If cell A2 has a year say 2020, what would be the formula to give TRUE or FALSE to test whether year is Leap or not. Hence for 2020, it should give TRUE. For 2000 = TRUE, 2100 = FALSE, 2020 = TRUE, 2021 = FALSE

7 / 10

Which formula will you use to extract HOUR from a time given in A2? Hence, if A2 is having 10:15, the answer should be 10.

8 / 10

What is the shortcut to insert date in a cell?

9 / 10

Which function returns the number of whole workdays between two dates?

10 / 10

Which function do you use to get current date and time?

Your score is

LinkedIn Facebook Twitter

Exit

2 thoughts on “Excel Quiz 51”

  1. Many of the correct answers you give do not have the " " wrapping around the text arguments in the expressions. Is there a statement I missed somewhere that says that we should assume there are quotes wrapping the text arguments?

    Reply

  2. For Question one, in order to get the same value of the number of days option number two needs to have ABS (absolute value) as the calculation Days(A2,A1) in your example give a negative number where as A2-A1 gives a positive number. So, only answer number 1 is the only accurate answer based upon the cell references in your formulas.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *