Excel Quiz 33 Posted on June 5, 2016September 26, 2021 by Vijay A. Verma Quiz 33 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 Which formula returns the number of whole workdays between two dates NETWORKDAYS NETWORKDAY WORKDAYS No function exists for the same 2 / 10 To calculate the number of completed months between two dates which function should be used? EDATE DATE MONTH DATEDIF 3 / 10 The minimum date which can be inputted into Excel is 0-Jan-1900 1-Jan-1901 1-Jan-1900 1-Jan-2000 4 / 10 To get today's date, which function to use NOW THISDAY TODAY JUSTNOW 5 / 10 If A1=23-Jan-16, what is the answer for following =EOMONTH(A1,0)+1 31-Jan-16 24-Jan-16 31-Jan-17 1-Feb-16 6 / 10 SHIFT+TAB is shortcut for Moving from top to down Moving from right to left Moving from left to right Moving from down to top 7 / 10 If A1=31-Jan-16, then what would be the result for =WEEKNUM(A1) 5 5.7 6 4 8 / 10 If A1=23-Aug-16, what is the result of =EOMONTH(A1,3) 3-Sep-16 23-Aug-13 31-Aug-16 30-Nov-16 9 / 10 If A1=23-Aug-16, then what would be the answer for =MONTH(A1) 2016 8 16 23 10 / 10 If A1=23-Aug-16, then the answer for =EDATE(A1,-2) would be 23-Jun-16 21-Aug-16 23-Aug-14 23-Aug-18 Your score is LinkedIn Facebook Twitter Retake quiz Exit