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