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