Answer the following questions.
1. Differentiate between a formula and function with an example.
2. Explain the Autofill feature with example,
3. Explain the different elements of a database with an example.
4. What is a primary key? What is the advantage of creating a primary key in a table?
5. Explain in short the need for creating a database.
Answers
1)
ans)So in summary, a formula is any calculation in Excel, but a function is a pre-defined calculation. =MAX(A1:B20) is a formula containing a function. Mastering the use of functions in formulas is a key skill in learning financial modelling. Happy formula-writing
2)
ans)A feature found in software and applications, that lets you enter a series of numbers or characters in a specified range, and have the software complete the entry you started typing. In Microsoft Excel, for example, you can use a preset function to automatically fill a cell with data.
3)
ans)The most typical object found in a database is a table. Other types of objects can reside in a schema, such as indexes, constraints, views, and procedures. The table is the most fundamental element found in a database schema. ... Tables, columns, and rows are discussed in the following subsections
4)
ans)Using the primary key, you can easily identify and find unique rows in the database table. They allow you to update/delete only specific records by uniquely identifying them. The table's data is sorted based on the primary key. They help you avoid inserting duplicate records in a table.
5)
ans)Manages large amounts of data. A database stores and manages a large amount of data on a daily basis. ...
Accurate. A database is pretty accurate as it has all sorts of build in constraints, checks etc. ...
Easy to update data. ...
Security of data. ...
Data integrity. ...
Easy to research data