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