Question

write down short notes on storing data,using advanced filter and data validation​

Answer 1

Here is your answer:-

To filter data:
Begin with a worksheet that identifies each column using a header row. ...
Select the Data tab, then locate the Sort & Filter group.
Click the Filter command. ...
Drop-down arrows will appear in the header of each column.
Click the drop-down arrow for the column you want to filter. ...
The Filter menu appears.


Filter Unique Records
Select a cell in the database.
On the Excel Ribbon's Data tab, click Advanced.
In the Advanced Filter dialog box, choose 'Copy to another location'.
For the List range, select the column(s) from which you want to extract the unique values.
Leave the Criteria Range blank.

Hope it help

Plzzzzzzzzzz mark me as Brainlist