Excel Quiz 25 Posted on November 14, 2015September 25, 2021 by Vijay A. Verma Quiz 25 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 - =COUNTIF(A:A,3)+COUNTIF(A:A,4) 0 2 4 3 2 / 10 An Excel workbook can contain only 3 worksheets TRUE FALSE 3 / 10 What would be the answer for following - =COUNTIF(A:A,">10") 10 2 0 1048576 4 / 10 Track Changes in Excel is not possible TRUE FALSE 5 / 10 To concatenate, two cells A1 and B1, following can be used = A1+B1 FALSE TRUE 6 / 10 Is it possible to set Excel to Manual calculation mode? FALSE TRUE 7 / 10 The function to generate random number is Rnd TRUE FALSE 8 / 10 SUMPRODUCT can be used to perform COUNT FALSE TRUE 9 / 10 Excel can open Access files FALSE TRUE 10 / 10 You can not filter on color in Excel TRUE FALSE Your score is LinkedIn Facebook Twitter Retake quiz Exit
