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