Excel Quiz 45 Posted on December 3, 2019September 26, 2021 by Vijay A. Verma Quiz 45 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 ISBLANK function is found under which group of functions Financial Engineering Logical Information 2 / 10 Which function is not part of TEXT group of functions FIND ROUND LEFT LEN 3 / 10 VLOOKUP is found under which category of functions TEXT FINANCIAL LOGICAL LOOKUP & REFERENCE 4 / 10 How can defined names be created? Name Manager Define Names Create from selection All of the above 5 / 10 To insert page break in Excel Insert > Page break Page Layout > Page break Page Layout > Breaks > Insert Page break Home > Insert Page break 6 / 10 What set of keys are pressed to enter Array formula in Excel? CTRL+ALT+ENTER ALT+ENTER CTRL+SHIFT+ENTER SHIFT+ENTER 7 / 10 The shortcut for Insert Function is SHIFT+F3 CTRL+F3 CTRL+IF ALT+F2 8 / 10 Following is not a calculation option Automatic Manual Manual except for data tables Automatic except for data tables 9 / 10 Which one is not one of the functionalities under Formulas tab Remove Arrows Insert Arrows Trace precedents Trace dependents 10 / 10 Shortcut for Calculate Sheet is SHIFT+F9 CTRL+F9 SHIFT+F2 ALT+F9 Your score is LinkedIn Facebook Twitter Retake quiz Exit
