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