Scribd
Upload
31 views2 pages

Sorting vs. Filtering in Excel

The document provides a Q&A format explaining sorting and filtering in data management, highlighting their definitions and differences. It includes information on accessing sorting and filtering options, as well as details about conditional formatting. Additionally, it features fill-in-the-blank and true/false questions to reinforce understanding of the concepts.

Uploaded by

supreetbhutani.work
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
31 views2 pages

Sorting vs. Filtering in Excel

The document provides a Q&A format explaining sorting and filtering in data management, highlighting their definitions and differences. It includes information on accessing sorting and filtering options, as well as details about conditional formatting. Additionally, it features fill-in-the-blank and true/false questions to reinforce understanding of the concepts.

Uploaded by

supreetbhutani.work
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Q & A (Short and Long Questions)

1.​ Q: What is sorting?​


A: Sorting is arranging data in ascending or descending order in columns and
rows.​

2.​ Q: What is filtering?​


A: Filtering is the process of displaying only the rows that meet the filter criteria
while hiding the other rows.​

3.​ Q: What is the difference between sorting and filtering?​


A: Sorting arranges data in order (ascending/descending), while filtering hides
unwanted data and shows only the data of interest.​

4.​ Q: From which ribbon can you access the Sort & Filter option?​
A: From the Home ribbon in the Editing group.​

5.​ Q: What can you do with filtered data?​


A: You can copy, format, print, or analyze the filtered data without sorting or
moving it.​

6.​ Q: What is conditional formatting?​


A: Conditional formatting is a feature that automatically applies formatting (like
font color or bolding) to a cell when the data in that cell meets specific criteria.​

Differentiate Between Sorting and Filtering


Sorting Filtering

Arranges data in ascending or Displays only the rows that meet


descending order. certain criteria.

Affects the order of all data in Hides unimportant data, without


the column/row. changing the order.

Example: A → Z or 1 → 100. Example: Show only values


greater than 50.
Fill in the Blanks
1.​ Sorting means arranging data in __________ or __________ order.​

2.​ In filtering, only rows that meet the __________ criteria will display.​

3.​ The Sort & Filter option is found in the __________ ribbon in the Editing group.​

4.​ __________ formatting automatically applies formatting to a cell when the data
meets specific criteria.​

True or False
1.​ Sorting hides unwanted data.​

2.​ Filtering helps in displaying only the data you are interested in.​

3.​ Conditional formatting changes the content of a cell.​

4.​ In Excel, you can sort data both in ascending and descending order.​

5.​ Filtering data is the same as sorting data.

You might also like