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