Long answer type question:
a) What is a database? Give an example.
b) How will you create a database table in Excel?
c)
What is the use of sorting the data?
d) What do you mean by "Data Validation Rules"?
e) Define the following:
i. Series
ii. Sorting
Write the procedure of:
a) Generating a month series (January to December)
b) Sorting the data in ascending or descending order.
Answers
{Answer}
A) DBMS lets users to create a database, store, manage, update/modify and retrieve data from that database by users or application programs. Some examples of open source and commercial DBMS include MySQL, Oracle, PostgreSQL, SQL Server, Microsoft Access, MongoDB.
b) •Enter the name of the database field (column headings).
•Enter data into the database.
•To use the database turn to tools «DATA».
•Assign the name of the database. Select the range of data - from the first to the last cell. Right mouse button - the name of the band. We give any name.
c) It is a feature that lets you arrange data in ascending or descending order.
d) Data validation uses validation rules that check for correctness, meaningfulness, and security of data, which is the input to the system. Data validation is used to restrict the cell entries within the specified range.
e) Series :- + ... is called the series associated with given sequence.
Sorting:-Sorting is the process of separating fleece (hair) of different textures. It is done after the removal of dirt, grease and dust from the raw sheared fleece.
a) Key in the name of the month that begins the series.
b) Sorting character data in ascending or descending order is based on a coding, or collating, sequence assigned to numbers and letters by the computer.