Excel Quiz 8 Posted on March 21, 2015September 24, 2021 by Vijay A. Verma Quiz 8 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 =SUMPRODUCT(A1:A20<5) 5 10 0 4 2 / 10 What would be the answer for =T(A5) Blanks 5 1 Error 3 / 10 What would be the answer for =SUMIF(A1:A20,">"&A12) 0 Error 18 5 4 / 10 What would be the answer for =COUNTA(A1:A20) 15 14 20 1 5 / 10 What would be the answer for =INDEX(A1:A20,8) #N/A 8 c 4 6 / 10 what would be the answer for =SUMIF(A1:A20,">3") 0 1 4 22 7 / 10 What would be the answer for =COUNTIF(A1:A20,">0") 0 Error 7 6 8 / 10 What would be the answer for =COUNT(A1:A20) 20 0 7 1 9 / 10 What would be the answer for =MATCH("d",A1:A20) 20 1 #N/A 11 10 / 10 What would be the answer for =SUMPRODUCT(--(A1:A20<5)) 4 9 5 0 Your score is LinkedIn Facebook Twitter Retake quiz Exit
