Which tab contains the Sort & Filter option?

In Microsoft Excel, the Sort & Filter option is located under the Data tab on the Ribbon toolbar. This feature is used to organize, sort, and filter data in a spreadsheet, making it easier to analyze and manage large amounts... Read More

1 MS OFFICE MCQS

Which tab contains the Sort & Filter option?

  • File
  • Data
  • Review
  • insert
Correct Answer: B. Data

Detailed Explanation

In Microsoft Excel, the Sort & Filter option is located under the Data tab on the Ribbon toolbar. This feature is used to organize, sort, and filter data in a spreadsheet, making it easier to analyze and manage large amounts of information.


Here’s what the Sort & Filter option includes:




  • Sort A to Z or Z to A (alphabetically or numerically)




  • Custom Sort (by multiple levels)




  • Filter (adds dropdowns to column headers for filtering values)



Discussion

Thank you for your comment! Our admin will review it soon.
No comments yet. Be the first to comment!

Leave a Comment