Question

_____________ helps you locate the data based on the specified criteria while hiding the rest.

Answer 1

Answer:

Sorting

Explanation:

Sorting help you locate the data based on the specified criteria while hiding the rest.

Please mark me brainliest

Answer 2

Sorting and filtering help you locate the data based on the specified criteria while hiding the rest.

• "Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively."
• "Filtering data refers to displaying only the rows that meet certain conditions."
• These two commands help to locate the data based on specific criteria
• We can find this in an excel sheet in the data ribbon. there will be a button called sort and filter. Once we select our data and click on this button, we get a prompt asking whether we want to sort in from A-Z or Z-A or 0-9. Then after selecting one the sorting is completed. Now to get specific data we use the filter. When we click on the filter button the headings of all the columns get a small filter symbol near them when we click on these we can choose the data we are looking for and we will get only that data shown and the rest will be hidden. When the filters are removed the whole data can be obtained again
• Hence the correct answer is Sorting and filtering

#SPJ3