Page 61 - ModularV1.1 _c7_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
   56   57   58   59   60   61   62   63   64   65   66