Excel Quiz 46 Posted on February 8, 2020September 26, 2021 by Vijay A. Verma Quiz 46 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 To import data from a website, which button to use? From Web From Internet From Text From Other Services 2 / 10 Excel default sorting is case sensitive TRUE FALSE 3 / 10 Which is not part of What-If Analysis? Scenario Manager Relationships Goal Seek Data Table 4 / 10 The shortcut for Auto Filter is ALT+A+F CTRL+A+F CTRL+SHIFT+L CTRL+SHIFT+A 5 / 10 What are the maximum number of items displayed in a filter drop-down list 10000 512 65536 1024 6 / 10 To prepare a unique list from a given data set which button can be used Remove Duplicates Advanced Filter Either of these None of these 7 / 10 To refresh all Pivots in your workbook, which button can be used No button is offered by Excel to Refresh all Pivots Refresh All Existing Connections Data Validation 8 / 10 To parse csv file which button can be used Flash Fill Remove Duplicates Advanced Filter Text to Columns 9 / 10 To combine many data ranges or tables into one which Excel feature can be used? Group Relationships Consolidate Combine 10 / 10 The shortcut for Flash Fill is CTRL+SHIFT+F CTRL+F+F CTRL+F CTRL+E Your score is LinkedIn Facebook Twitter Retake quiz Exit