Question

Komal has made a database in Excel in which she has entered the Term exam marks. But she wants to see only those records where English marks is 82 and hide the rest record. Which feature she will use in Excel?


Data validation

Advance Filter

Filter

​

Answer 1

Answer:

In addition to sorting, you may find that adding a filter allows you to better analyze your data. When data is filtered, only rows that meet the filter criteria will display and other rows will be hidden. With filtered data, you can then copy, format, print, etc., your data, without having to sort or move it first. To use a filter,

 

Go to the Home ribbon, click the arrow below the Sort & Filtering icon in the Editing group and choose Filter.  

OR

 

Go to the Data ribbon, and then click Filter in the Sort & Filter group.

Explanation:

Answer 2

Answer:

data filtration.....♥️♥️♥️♥️♥️hope it helps you dear♥️♥️♥️♥️♥️♥️♥️♥️♥️ follow me then I will follow u back ♥️♥️♥️♥️♥️♥️♥️