Page 61 - ModularV1.1 _c6_flipbook
P. 61
C. Fill in the blanks using the words given below.
conditional formatting, subtotal, record, database, pivot table
1. A set of values for the fields is called a ................................. .
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 MS Excel allows to consolidate, summarise and present data.
D. Short answer type questions.
1. What is data validation?
......................................................................................................................................................................................
2. What is the use of the conditional formatting?
......................................................................................................................................................................................
3. What is 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?
In the lab Subject Enrichment
Make a list of your 10 friends in MS Excel. Make columns for the distance of their home from
school, distance of post office from their home, etc.
Use sorting to arrange data in order. Highlight the cells that have distance less than 2.5 km in
any cell.
Make a list of 15 teachers and subjects taught by them. Apply Filters on the subjects field. Take
printouts of various filter options of subjects and their results.
Teacher's Corner
1. Explain the concept of database to the students.
2. Do a walk-through of all the topics covered in this chapter.
Excel as Database 59

