Excel Quiz 14 Posted on June 6, 2015September 25, 2021 by Vijay A. Verma Quiz 14 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 If you type a number longer than 10 digits, Excel replaces digits after 10 digits with 0s. True. Excel stores only 10 significant digits in a number. False. Excel replaces the digits only after 15 digits. 2 / 10 What would be the answer for =COUNTIF(A1:A10,">"&AVERAGE(A1:A10)-2) 5.5 6 7 0 3 / 10 Which Excel function can be used to count blank cells COUNTBLANKS COUNTNOTHING COUNTA COUNTBLANK 4 / 10 For the below range, what would be the answer for =COUNTA(A1:A5) Column B shows the formulas used in column A. 5 0 4 3 5 / 10 Answer for =FACTDOUBLE(7) would be 5040 42 105 10080 6 / 10 For the given range, what would be the answer for =COUNTIF(A2:A10,"g") #REF 0 1 9 7 / 10 For below data range, what would be the answer for =COUNTIF(A2:A10,"L*") 1 4 0 3 8 / 10 For given range, what would be the answer for =COUNT(A2:A10) 1 9 3 0 9 / 10 For given range, following formulas will give same result - =COUNTIF(A2:A10,"a") =COUNTIFS(A2:A10,"a") No Yes 10 / 10 For given range, the answer for =COUNT(A2:A10) would be #Value 1 0 9 Your score is LinkedIn Facebook Twitter Retake quiz Exit