Page 75 - iPro_trackGPT_V5_Class7
P. 75

4.  Differentiate between contiguous and non-contiguous cell ranges.

                        ...................................................................................................................................................................................
                        ...................................................................................................................................................................................

                        ...................................................................................................................................................................................

                     5.  Describe the steps to format numbers in Excel.
                        ...................................................................................................................................................................................

                        ...................................................................................................................................................................................

                        ...................................................................................................................................................................................

                 C.  Application-based questions.

                     1.  Aryan has created a list of product prices in a worksheet, but he wants to make the data
                        more understandable by displaying them in rupees. How can Aryan format the cells to
                        display the numbers as currency?
                     2.  Maya wants to enter a formula that adds the values from cells A1 to A10.
                        However, she does not want to manually enter each value in the formula.
                        What shortcut can Maya use to calculate the sum?


                                                                                  #Digital Literacy
                 Higher Order Thinking Skills (HOTS)
                     1.  You have merged several cells to create a single large cell, but now you need to
                        unmerge them. How would you ensure that the content is properly distributed and
                        the formatting is retained?

                     2.  How would you use the Auto Fill feature to extend a custom series that is not
                        automatically recognise by Excel?



                     Code Clues                                                   #Coding & Computational Thinking
                                                                                  #Experiential Learning


                 Locate eight features of Excel in the grid.

                                           A   U   T   O   F   I   L  L   B   H   L   G   P
                                           H   K   F   E   H   F  T   K   B   F   T   F   J

                                           W H     A   V   R   B  P   Y   N   T   W   I   P
                                           R   F   M   D   L   P  R   N   D   E   Z   L   C
                                           A   T   E   X   T  C   O   L   O   R   V   L   M
                                           P   R   R   B   R   T  H   D   Q   I   M   C   K

                                           T   L   G   F  N M     Y   R   E   W   P   O   T
                                           E   S   E   S   P   L   I  T   C   E   L   L   S
                                           X   R   O   U   B  G   D   S    J  T   C   O   I

                                           T   Y   C   E   L   L  B   O   R   D   E   R   X


                                                                                         More on Spreadsheets    73
   70   71   72   73   74   75   76   77   78   79   80