Question

Answer the following Long answers: (Any one)

1. Describe the term Database.

2. How is Advanced Filter different from Filter?​

Answer 1

1.A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). ... Most databases use structured query language (SQL) for writing and querying data.

2.Advanced filter: While the regular data filter will filter the existing dataset, you can use Excel advanced filter to extract the data set to some other location as well. Excel Advanced Filter allows you to use complex criteria.

Answer 2

A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). ... Most databases use structured query language (SQL) for writing and querying data.