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