Excel Quiz 17 Posted on July 25, 2015September 25, 2021 by Vijay A. Verma Quiz 17 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 is the name of Red Zone? Formula Bar Show Formula Bar Function Manager Function Box 2 / 10 When you start Excel, Analyze tab is shown by default. FALSE TRUE 3 / 10 In the Find and Replace Box (you can invoke by shortcut CTRL+F), how can you show the checkbox for Match Case? Search is case insensitive, hence case sensitive search is not provided Click on Option in Find and Replace Box Registry needs to be modified You can do through Home tab 4 / 10 Pivot Table is found in which tab? Formulas Insert Home Analyze 5 / 10 What is the area in Red Zone called? Name Box Function Box Name Manager Formula Box 6 / 10 Items displayed in filter drop-down lists 16384 512 64 10000 7 / 10 When you work with charts, pivot tables, additional tabs get enabled. What is the term for these additional tabs? Sensitive Tabs Pop Up Tabs Contextual Tabs Additional Tabs 8 / 10 Maximum number of arguments in a function 1024 64 255 512 9 / 10 What is the area in red zone called? Ribbon Bar Quick Access Toolbar (QAT) Place Holder Menu Bar 10 / 10 Protect Sheet is found under which tab? Developer Tab Formulas Tab Review Tab View Tab Your score is LinkedIn Facebook Twitter Retake quiz Exit
