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