Page 72 - modular4.0
P. 72
Chapter Profile
B. Fill in the blanks using the words given below:
form, data validation, database, columns, rows, numeric
1. A allows to store and retrieve a large amount of data efficiently.
2. means to restrict the user to enter a specific range of values in a particular cell
or a range of cells.
3. By default, button is not visible on the ribbon.
4. Data bars can be added to the cells having data.
5. A database contains data in the form of and .
C. Write ‘T’ for true and ‘F’ for false.
1. The database concept is one of the oldest ways to maintain records in a
conventional file-oriented data collection system.
2. To use excel as a database, it is mandatory that every row has a heading.
3. Conditional formatting hides unwanted rows and columns.
4. Using form, it is possible to add, update and delete a record.
5. The filter option is present in the Home tab.
D. Short answer type questions.
1. Define Sorting.
2. What is the purpose of using Pivot table?
3. Define Record.
E. Long answer type questions.
1. Write steps to do custom sort.
2. How does the Filter command hide unwanted data, while Conditional Formatting highlights specific
data?
70 Modular (Ver. 4.0)-VII

