Sorting and Filtering Data Excel MCQs
Sorting and Filtering Data in MS Excel – Class 7 MCQs with Answers & Explanations
Class: 7
Subject: Computer Science
Section: Spreadsheets (MS Excel)
Topic: Sorting and Filtering Data
Board: CBSE (Based on NCERT Syllabus)
Subject: Computer Science
Section: Spreadsheets (MS Excel)
Topic: Sorting and Filtering Data
Board: CBSE (Based on NCERT Syllabus)
1. Sorting means arranging data in:
Answer: b) Specific order
Sorting arranges data alphabetically or numerically.
Sorting arranges data alphabetically or numerically.
2. Two types of sorting are:
Answer: b) Ascending & Descending
Ascending = smallest to largest, Descending = largest to smallest.
Ascending = smallest to largest, Descending = largest to smallest.
3. Ascending order for numbers:
Answer: b) 1–9
Numbers increase from smallest to largest.
Numbers increase from smallest to largest.
4. Descending order for text:
Answer: b) Z–A
Text is arranged in reverse alphabetical order.
Text is arranged in reverse alphabetical order.
5. Sorting is found in which tab?
Answer: a) Home/Data
Sort options are available in Data tab and Home tab tools.
Sort options are available in Data tab and Home tab tools.
6. Filtering means:
Answer: b) Showing selected data
Filter displays only required records.
Filter displays only required records.
7. Filter button appears as:
Answer: a) Arrow icon
Drop‑down arrows appear on column headings.
Drop‑down arrows appear on column headings.
8. Filtering hides:
Answer: b) Unwanted data
Only matching records remain visible.
Only matching records remain visible.
9. Custom sort allows:
Answer: a) Multi‑column sorting
Sort by more than one field.
Sort by more than one field.
10. Example of sorting:
Answer: d) All
Sorting applies to many data types.
Sorting applies to many data types.
11. Filter is applied on:
Answer: b) Columns
12. Clearing filter shows:
Answer: b) All data
13. Sorting text uses:
Answer: a) Alphabetical order
14. Sorting numbers uses:
Answer: b) Numeric order
15. Filter improves:
Answer: d) All
16. Sort A→Z means:
Answer: b) Ascending
17. Sort Z→A means:
Answer: b) Descending
18. Filter option is in:
Answer: a) Data tab
19. Sorting helps in:
Answer: d) All
20. Filtering is best for:
Answer: d) All
