Page 38 - Trackpad_ipro 4.1_Class8
P. 38

b.   She wants to select all the items to be purchased along with the quantity. Guide her
                             how she can select the same with the help of mouse.

                         c.   After rectifying the formula in cell E2 she wants to calculate the Amount for all remaining
                             items, suggest her the simplest way to do the same.
                         d.   In Cell E8, she typed “=sum(E2:E7), what is she trying to do?
                         e.   She wants to find out, on which item has she spent the most? Suggest her a function
                             to do the same.

                         f.   Help her prepare a pie chart so that she can observe on which item she has spent the
                             least.




                    Crack The            Code                                      #Experiential Learning
                                                                                   #Coding & Computational Thinking


                    Solve the crossword using the clues.
                      Across:
                                                                            1              2
                      3.  Symbols that specify
                                                                                                   4
                         calculations to be
                                                                 3          E              O       S
                         performed
                      5.  Function used to convert
                         text string into uppercase
                                                          5                 R
                      8.  Numbers or text that do
                         not change
                      9.  Function used to convert
                         text string into lowercase
                                                                                                    6
                    10.  Function used to multiply
                         values in cells
                                                                     7
                      Down:
                                                                         8  C                       N
                      1.  Cell address that is to be
                                                             9       O      E
                         used in a calculation

                      2.  Function used to display
                         current date
                                                                                        10          O
                      4.  Function used to add values

                         in cells
                      6.  Predefined formula in Excel

                      7.  Chart type in which data is displayed in the form of vertical bars







                    36     iPro (Ver. 4.1)-VIII
   33   34   35   36   37   38   39   40   41   42   43