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