Page 60 - ModularV1.1 _c6_flipbook
P. 60
Recap
A database implies organising the data in a manner that helps to store and retrieve a
large amount of data efficiently.
A form is a window used to display or enter a record in an Excel worksheet.
Custom Sort is used to apply sorting on more than one column in selected range on
different criteria.
Excel can apply filters to show only the required information and hide unwanted
information.
Conditional Formatting can be applied on the basis of various criteria.
Data validation means to restrict the user to enter a specific range of values in a
particular cell or a range of cells.
The Subtotal command allows you to calculate group-wise sum.
The Pivot Table feature of MS Excel allows you to analyse a large amount of data.
Exercise
A. Tick ( ) the correct option.
1. Which of the following is called field in a database?
a. Column b. Row c. Cell
2. Which of the following is a window used to display or enter a record in an Excel worksheet?
a. Row b. Form c. Textbox
3. Which of the following options is used to search a record in a form?
a. New b. Criteria c. Clear
4. We use Sort A to Z option to sort ........................... .
a. Numbers b. Text c. Symbols
5. In which group of the Data tab is the Data Validation command present?
a. Data Tools b. Outline c. Sort & Filter
B. Write ‘T’ for true and ‘F’ for false.
1. Excel can arrange data in ascending order only. .....................
2. You cannot sort more than one column at a time in a selected range of cells. .....................
3. A form displays only one record at a time. .....................
4. We cannot add records using form. .....................
5. Before using the Subtotal command, data must be sorted in ascending or .....................
descending order.
58 Modular (Ver. 1.1)-VII

