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