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