Excel as a Database Ch-2 Class 7th

EXERCISES:-

A) TICK THE CORRECT ANSWERS.

1. This is an organised collection of information.

Ans-database

2. It is the smallest screen that contain the field of a database along with the shape to add, modify, or view a record.

Ans-Form

3. This is used to rearrange data in a specific order.

Ans-sorting

4. This button in the seat one dialogue box lets you search a record by entering data in a uniquely identified field.

Ans-criteria

5. It contain data and information about one person, item or an organisation in a database.

Ans-record

B) fill in the blanks.

1. The form feature lets you work on the individual record at a time.

2. The data validation feature allow you to set certain rules to restrict the type of data or value to be entered in a cell.

3.The sorting option arrange and sort the text value in alphabetical order.

4. Click on the clear button present on the data tab to remove the filter.

5. A record appear as a row in a database.

C) write true or false statements.

1. Field is a column that contain only one type of data-True.

2. The remove duplicate button is used to remove any unwanted duplicate value from the range.True.

3. The structure of database is made up of boxes and shapes.False.

4. Field name is a row level in a database-False.

5. The conditional formatting command is present in the styles group of the home tab-True.

D) answer the following questions.

1. Explain the term field, record and field name.

Ans- Field-if it is a column that contain only one type of data.

Record-A record appear as a row in a database.

Field name-  if field is considered a column in a database, therefore, field name is also referred to a column label.

2. Describe the form feature in Excel.

Ans-if form is a smaller screen that contain the fields of a database along with the space to add, modify, or view a record.

3. What is the difference between sorting data and filtering data?

Ans-sorting data-MS Excel allow you to rearrange the data numerically or alphabetically and on the basis of date, colour and so on. Rearranging data in a specific order is called sorting.

Filtering data-MS Excel lets you display the record which meet certain criteria and conditions is specified by you,whereas item temporarily blocks for hight the unwanted data from being viewed. This feature is called filtering.

4. Explain custom filtering.

Ans-custom filtering is used to quickly filter data based on certain specific condition.

5. Describe the data validation feature.

Ans- data validation allow you to set certain rules to restrict the type of data or values to be entered in a cell.