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