Question

1.what is the process of Advanced filter in database sheet? write down the statement.​

Answer 1

EXCEL ADVANCED FILTER (Examples)

• Select the entire data set (including the headers).
• Go Data tab –> Sort & Filter –> Advanced. (You can also use the keyboard shortcut – Alt + A + Q). ...
• In the Advanced Filter dialog box, use the following details: Action: Select the 'Copy to another location' option. ...
• Click OK.

Hope it helps you