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