Page 29 - TP_Plus_v4_Class7
P. 29

Scan the QR code and learn more about Excel.





                                                                                       21 st
                          DIY In The Lab                                             Century   #Technology Literacy
                                                                                      Skills
                 To
                 Subject   Excel Skills


                   Go to your computer lab and do the following:
                   1.  Open Excel in your computer. Create a Blank Workbook and make a list of your 5 friends.

                      a.  Insert columns for the distance of their home from school, distance of post office from their home, etc.









                      b.  Now click on Sort & Filter command and sort the data in an order.
                      c.   Click on Conditional Formatting command to highlight the cells which have distance less than 2.5 km
                         in any cell.

                   2.  Create an Excel sheet and make a list of 4 teachers and subjects taught by them.










                      a.   Click on Sort & Filter command from the Editing group under Home tab and apply Filters on the
                         Subject Taught field.

                      b.  Sort the records according to Teacher Name field in descending order.





                 For The Teacher

                    Demonstrate to the students the concepts of Excel discussed in the chapter.
                    Help the students understand differences between filtering and sorting features.

















                                                                                         #Advanced Features of Excel  27
   24   25   26   27   28   29   30   31   32   33   34