Excel Quiz 23 Posted on October 18, 2015September 25, 2021 by Vijay A. Verma Quiz 23 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 For the below layout what would be the answer for =SUM(CHOOSE(2,B2:B4,B5:B7)) 204 #VALUE 0 124 2 / 10 What would be the answer for =EOMONTH("10-Jan-15",0) 31-Jan-15 01-Jan-15 #VALUE 11-Jan-15 3 / 10 What would be the answer for following layout - =LOOKUP(10^10,B2:B7) 10^10 54 80 55 4 / 10 What would be the answer for following - =SUM(INDEX(B2:B7,MATCH("Polly",A2:A7,0)):INDEX(B2:B7,MATCH("Sue",A2:A7,0))) 69 124 #REF 46 5 / 10 What would be the answer for following - =INDEX(A2:A7,MATCH(23,B2:B7,0)) Chloe Polly Lisa Sue 6 / 10 What would be answer for following for below layout - =INDEX(A1:B7,3,2) 54 46 55 23 7 / 10 What would be the answer for following - =CHOOSE(13,"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec") #VALUE Jan Dec Blanks 8 / 10 What would be the answer for =CODE("A")*2 65 100 0 130 9 / 10 What would be the answer for following layout - =SUM(B4:INDEX(B2:B7,5)) 328 173 103 227 10 / 10 What would be the answer for below layout =VLOOKUP("Ch*",A1:B7,2,0) 54 23 80 70 Your score is LinkedIn Facebook Twitter Retake quiz Exit
