Excel Quiz 39 Posted on November 28, 2017September 26, 2021 by Vijay A. Verma Quiz 39 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 Below can be invoked from which Excel functionality Colors Themes Effects Cell Styles 2 / 10 The syntax for Custom Format in Excel is <TEXT>;<ZERO>;<POSITIVE>;<NEGATIVE> <POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT> <POSITIVE>;<NEGATIVE>;<TEXT> <ZERO>;<POSITIVE>;<NEGATIVE>;<TEXT> 3 / 10 What would be the the answer for following - =VLOOKUP("Ann*",$A:$B,2,0) 4000 1340 5000 #N/A 4 / 10 What would be the answer for following =VLOOKUP("Anne",$A:$B,2,0) #N/A 4000 3200 1340 5 / 10 The shortcut for Insert Function dialog box is SHIFT+F3 CTRL+F3 ALT+F3 F3 6 / 10 Calculate Sheet can be invoked through following shortcut SHIFT+CTRL+F9 F9 SHIFT+ALT+F9 SHIFT+F9 7 / 10 How many maximum records can be shown in a filtered list? 999 65000 1000 10000 8 / 10 CUMIPMT function is used to Cumulative interest paid up in 1st year Cumulative Interest Paid Up between a Period for a loan Cumulative Total Paid Up between a Period for a loan Cumulative Principal Paid Up between a Period for a loan 9 / 10 Mail Merge is a functionality of Excel True False 10 / 10 What is the answer for following =QUOTIENT(50,3) 17 16 #N/A 2 Your score is LinkedIn Facebook Twitter Retake quiz Exit
