What is an Excel database? Explain how database functions differ

What will be an ideal response?

An Excel database is a way of storing data that is made up of records (rows) and fields (columns). Different types of data can be organized in this manner, including common information such as a contact list or a catalog of your smartphone applications. In a database, each record is one unit of data[md]such as an application in your collection, and each field is a specific piece of information[md]such as the application's name. An important aspect of databases is that each record contains the same fields. Thus, each application record will contain a title field, a rating field, a price field, a developer field, and so on. Furthermore, Excel databases must include field names, which are always listed in the first row.
Database functions execute common calculations such as sum, average, and count and are designed specifically for use with an Excel database.The power of database functions lies in the fact that they permit you to identify which records to include in the calculation. All database functions are named using the format DXXX() where XXX is the name of the corresponding non-database Excel function. For example, in the DSUM function, the D indicates that the function is a database function, and SUM is the name of the corresponding non-database Excel function. Additionally, all database functions include the same three arguments.