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