Page 67 - TP_Modular_V2.1_Class7
P. 67
2. A ................................. contains data in the form of rows and columns.
3. Color Scales is a feature available in ..................................
4. The ................................. command allows you to calculate group-wise sum.
5. The ................................. feature of Excel 2016 allows to consolidate, summarise and present data.
C. 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. .....................
D. Short answer type questions.
1. What is data validation?
..................................................................................................................................................................................................
2. What is the use of the conditional formatting?
..................................................................................................................................................................................................
3. Define sorting.
..................................................................................................................................................................................................
E. Long answer type questions.
1. Write the steps to search a record in a form.
..................................................................................................................................................................................................
..................................................................................................................................................................................................
..................................................................................................................................................................................................
2. What is the difference between sorting data and filtering data?
..................................................................................................................................................................................................
..................................................................................................................................................................................................
..................................................................................................................................................................................................
..................................................................................................................................................................................................
21 st
Century #Critical Thinking
F. Competency-based/Application-based question. Skills
Anaya was making a list of all the students of her class. She wants to sort them
alphabetically. Which type of sorting can she use for this?
Excel as Database 65

