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 combine many data ranges or tables into one which Excel feature can be used? Group Relationships Consolidate Combine 2 / 10 To import data from a website, which button to use? From Web From Internet From Text From Other Services 3 / 10 The shortcut for Auto Filter is ALT+A+F CTRL+A+F CTRL+SHIFT+L CTRL+SHIFT+A 4 / 10 Excel default sorting is case sensitive TRUE FALSE 5 / 10 Which is not part of What-If Analysis? Scenario Manager Relationships Goal Seek Data Table 6 / 10 What are the maximum number of items displayed in a filter drop-down list 10000 512 65536 1024 7 / 10 The shortcut for Flash Fill is CTRL+SHIFT+F CTRL+F+F CTRL+F CTRL+E 8 / 10 To parse csv file which button can be used Flash Fill Remove Duplicates Advanced Filter Text to Columns 9 / 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 10 / 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 Your score is LinkedIn Facebook Twitter Retake quiz Exit
