Excel Quiz 18 Posted on August 8, 2015September 25, 2021 by Vijay A. Verma Quiz 18 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 the below, What would be the answer for =COUNTIF(A1:A10,3) 2 3 6 0 2 / 10 What would be the answer for =RAND()*100 100.100 Can not be predicted System Time * 100 System Date * 100 3 / 10 Calculation Options is under which tab? Analyze Tab Picture Tab Formulas Tab Tools Tab 4 / 10 If A1 = "Vijay A. Verma", what does below formula do? =LEFT(A1,FIND(" ",A1&" ")-1) Extracts Middle Name Extracts Last Name Gives Error Extracts the first Name 5 / 10 What would be the answer for =MOD(187,5) 13 2 7 0 6 / 10 Developer Tab is enabled by default? Yes No 7 / 10 If A1=10, what would be the answer for following =POWER(A1,3) 10 0 100 1000 8 / 10 55th Row, 3rd Column $3$55 C55 A55 C1 9 / 10 What is the answer for =ODD(10) 9 11 10 FALSE 10 / 10 SHIFT+TAB will move the cursor from which direction to direction Left to Right Bottom to Top Top to Bottom Right to Left Your score is LinkedIn Facebook Twitter Retake quiz Exit
Question Five answer is 6 not 2. Countif({1,2,2,3,4,5,6,2,2,3,3,3,3,3},3) = 6.