Excel Quiz 53
By eforexcel|2017-05-20T14:47:51+05:30Saturday, June 24th, 2017|Categories: Quizzes|Tags: advanced filter, Auto Filter, Autofilter, Autoline, comma separate, Consolidate, csv, Data, Flash Fill, From Text, From Web, Group, Outline, Remove Duplicates, Subtotal, Text to Columns, Ungroup, unique, What-if|0 Comments
Excel Quiz 53 - A Quiz on Data Tab in Excel
Quiz-summary
0 of 10 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
Information
This quiz checks your knowledge about Data tab in Excel.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Answered
- Review
-
Question 1 of 10
1. Question
The shortcut for Auto Filter is
Correct
Incorrect
-
Question 2 of 10
2. Question
To refresh all Pivots in your workbook, which button can be used
Correct
Incorrect
-
Question 3 of 10
3. Question
To parse csv file which button can be used
Correct
Incorrect
-
Question 4 of 10
4. Question
To prepare a unique list from a given data set which button can be used
Correct
Incorrect
-
Question 5 of 10
5. Question
What are the maximum number of items displayed in a filter drop-down list
Correct
Incorrect
-
Question 6 of 10
6. Question
Which is not part of What-If Analysis?
Correct
Incorrect
-
Question 7 of 10
7. Question
The shortcut for Flash Fill is
Correct
Incorrect
-
Question 8 of 10
8. Question
To import data from a website, which button to use?
Correct
Incorrect
-
Question 9 of 10
9. Question
Excel default sorting is case sensitive
Correct
Incorrect
-
Question 10 of 10
10. Question
To combine many data ranges or tables into one which Excel feature can be used?
Correct
Incorrect