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 For given range, what would be the answer for =COUNT(A2:A10) 1 9 3 0 2 / 10 For the below range, what would be the answer for =COUNTA(A1:A5) Column B shows the formulas used in column A. 4 5 3 0 3 / 10 Which Excel function can be used to count blank cells COUNTNOTHING COUNTA COUNTBLANK COUNTBLANKS 4 / 10 What would be the answer for =COUNTIF(A1:A10,">"&AVERAGE(A1:A10)-2) 7 0 6 5.5 5 / 10 For given range, the answer for =COUNT(A2:A10) would be 0 1 9 #Value 6 / 10 For below data range, what would be the answer for =COUNTIF(A2:A10,"L*") 0 4 3 1 7 / 10 Answer for =FACTDOUBLE(7) would be 5040 105 10080 42 8 / 10 For given range, following formulas will give same result - =COUNTIF(A2:A10,"a") =COUNTIFS(A2:A10,"a") Yes No 9 / 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. 10 / 10 For the given range, what would be the answer for =COUNTIF(A2:A10,"g") 0 1 9 #REF Your score is LinkedIn Facebook Twitter Retake quiz Exit