Excel Quiz 22 Posted on October 3, 2015September 25, 2021 by Vijay A. Verma Quiz 22 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 =FLOOR("10:25 PM","00:10") 10:20 PM 10:25 PM #VALUE 10:30 PM 2 / 10 What would be the answer for following? =IF(2*0,"Yes","No") No FALSE Yes 0 3 / 10 SHIFT+F9 does what? Calculates the Active Sheet Display the formulas in place of results Rebuilds relationships in the Active Sheet Calculates the Active Workbook 4 / 10 Which function key can be used to change the cell? F5 F1 F2 F4 5 / 10 What is the answer for =REPLACE("Republic",3,0,"of") Rep ublic Reofpublic #VALUE Republic 6 / 10 What would be the answer for =MID("Republic of China",13,20) Republic of China China #REF #VALUE 7 / 10 What is the answer for =SUBSTITUTE("Republic","r","Tom") Tomepublic republic Republic Rrepublic 8 / 10 CTRL+F1 is the shortcut for To toggle to show ribbon Help in contracted format Help in extended format Showing help from internet 9 / 10 What would be the answer for following? =2=2 TRUE 0 1 FALSE 10 / 10 In Excel order of calculation precedence, Division gets preference over Multiplication. FALSE TRUE Your score is LinkedIn Facebook Twitter Retake quiz Exit
