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