Excel Quiz 24 Posted on October 31, 2015September 25, 2021 by Vijay A. Verma Quiz 24 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 What would be the answer for following for following layout =COUNTBLANK(A:A) 1048566 64000 10 #VALUE 2 / 10 What would be the answer for following - =VLOOKUP("p?",A2:B7,2,0) #N/A 55 46 Polly 3 / 10 What would be the answer for following =COUNTIF(A:A,"?u*") 3 2 0 4 4 / 10 What would be the answer for following =COUNTIF(A:A,{"S*","J*"}) 0 3 10 2 5 / 10 What would be the answer for following for below layout =COUNTIF(A:A,"*") 4 10 6 1048576 6 / 10 What would be the answer for following - =COUNT(A:A) 10 4 0 3 7 / 10 For below layout what would be the answer for =COUNTIFS(B:B,"<15",B:B,">=8") 0 5 4 3 8 / 10 What would be the answer for following - =COUNTIF(A:A,"* * *") 4 0 #VALUE 3 9 / 10 What would be the answer for following - =INDIRECT("A"&MATCH(23,B2:B7,0)) Lisa Christina Polly Chloe 10 / 10 What would be the answer for following =COUNTIF(A:A,">"&AVERAGE(A:A)) 10 4 #VALUE 0 Your score is LinkedIn Facebook Twitter Retake quiz Exit
Question 5 really needs to be updated. The formula now spills two values. Which value are you seeking? Reply
Question 5 really needs to be updated. The formula now spills two values. Which value are you seeking?