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