Page 68 - TP_iPlus_V2.1_Class7
P. 68

#Problem Solving & Logical Reasoning
                           Crack The Code                                             #Digital Literacy


                    1.  Write the cell address at the intersection of first row and first column.

                    2.  What will be displayed in the formula bar if the active cell contains the number 45?
                    3.  Write the cell address at the intersection of fourth column and third row.
                    4.  Write the cell address at the intersection of third row and fourth column.
                    5.  List the cells that fall within the range from A1 to D4.



                                                                                      #Experiential Learning
                     Let’s Explore


                            Use  the  internet  to  research  the  different  data  types  and  custom  styles  available
                            in Excel.



                                                                                      #Collaboration & Teamwork
                                                                                      #Creativity & Innovativeness
                            Be Creative

                     Design a budget tracker sheet for your mother to help her monitor household expenses.



                                                                                      #Ethical & Moral Reasoning

                         Life Skills and Values

                      Always save your files in your own folder. Avoid deleting or copying work from other people's folders.


                                                                                              #Digital Literacy
                                                                                              #Creativity & Innovativeness

                         Practical Time



                       Create the following worksheet in Excel. Enter the marks obtained by the students.










                       Create a folder on the D drive and save the file there. Take note of the file extension.



                      Teacher’s Corner

                  1.  The teacher should cover the various application areas of Excel.
                  2.  A detailed discussion should be held on the different data types used in Excel.


                    66
                         iPlus (Ver. 2.1)-VII
   63   64   65   66   67   68   69   70   71   72   73